Date: 04/11/05 (MySQL Communtiy)    Keywords: mysql, sql

I've finally put together a code-based load balancing scheme for distributing server load to a pool of slaves. The issue I'm up against now is a way to poll the slaves to see which has the lowest load, and there doesn't seems to be a standard simple MySQL command to report that.

I'd like to keep the methods confined to SQL commands that can be executed via remote connections. The only option I can see at the moment is do "show processlist" and filter it to see the number of currently executing queries and get the average execution time, though that seems to be a bit "heavy".

I haven't seen anything in show status or the like that shows something as basic as server load.

I'm sure this has been covered before but I haven't been able to find any references. Any ideas?

Source: http://www.livejournal.com/community/mysql/53451.html

Date: 04/13/05 (MySQL Communtiy)    Keywords: mysql, sql

SELECT * from schedule WHERE (clientid = 95145) AND (date BETWEEN '2005-04-10' AND '2005-04-30') ORDER BY date

Any one know of a good site with a elaborate description of the WHERE clause of the SELECT statement? I am trying to select data that matches a client id and a date range. The MySQL manual doesn't seem to get into it in detail.

I got it to work. I had left out the quotes. Sheesh.

Source: http://www.livejournal.com/community/mysql/54122.html

Date: 04/15/05 (SQL Server)    Keywords: xml, sql

I have an XML document which contains 10,000 rows of item master information, 12 columns per row. I want to read that XML document and use it in a SELECT statement, just as if it was a table or view.

The SQL help file suggests using OPENXML, which looks pretty simple, but in order to use that, I need to create an internal representation of the XML document with sp_xml_preparedocument.
In order to do THAT, I have to have the entire XML document in a text parameter. This is not a small file (4.8MB), and is representing about 10,000 rows of data. No way in hell can I pull all of that into an ntext variable.

I have never worked with XML in SQL Server before. I am familiar with the data in the document (.XML file contains the schema information in the header) but not with the T-SQL functions and procedues used to manipulate XML data.

How do I read the XML file, either as a part of a SQL SELECT, or by dumping it into a temporary cursor?

Source: http://www.livejournal.com/community/sqlserver/24405.html

Date: 04/15/05 (PHP Community)    Keywords: php, mysql, sql, web

Anyone know any good cheap webhosts for the uk?

With features like PHP and MySQL included in the package of course.

Source: http://www.livejournal.com/community/php/286063.html

Date: 04/16/05 (PHP Community)    Keywords: php, mysql, sql, web, linux, hosting, apache

I am currently hosting my web site with powweb, the problem is that I am outgrowing its feature set. I’m working on some applications that need the MySQL InnoDB table type, or at least would find it very useful. Does anyone know of a hosting provider that supports the following:

PHP 5.0x
MySQL 4.1.x With InnoDB
Apache (1.3 or 2.0 would be fine)

Ideally running linux or BSD

Source: http://www.livejournal.com/community/php/286793.html

Date: 04/18/05 (Web Hosts)    Keywords: php, mysql, database, sql, hosting

www.subnixus.com now has three easy ways to earn free hosting.

1. Being an active member of the forum. It's that simple, by posting on our forum you can earn free hosting. Read about it here: http://www.subnixus.com/forums/viewtopic.php?id=798

2. By signing up for one of our sponsers, such as DISH Network, you can earn one year of free hosting. Read about it here: http://www.subnixus.com/forums/viewtopic.php?id=799

3. By making a donation of $10 or more you will earn one year of free hosting. Read about that promotion here: http://www.subnixus.com/forums/viewtopic.php?id=802

Your hosting package will be reviewed and given on a case by case basis. The minimum package includes (but you could qualify for more):

www.yourname.com
125MB of Space
1G of bandwidth
1 MySQL Database
POP Email
Control Panel
FTP
(basically anything you need to get your site up and running)


This new program starts this week. All accounts that are earned between April 18 - 22 will be setup on Sat. the 23rd. Please visit www.subnixus.com for all of the details.

Source: http://www.livejournal.com/community/webhosts/26063.html

Date: 04/19/05 (Java Web)    Keywords: blogging, software, sql, web

We often talk about understanding an application from code and unit tests with catch phrases like - "code is the documentation". In my experience I haven't found a better and more concise documentation then reading the SQL schema for any application, assuming it has one. Today I was looking at Fatima - a weblogging software. [...]

Source: http://blog.taragana.com/index.php/archive/relational-schema-still-speaks-volumes-about-any-application-a-look-at-fatima/

Date: 04/19/05 (PHP Community)    Keywords: php, mysql, database, sql

Greetings... Semi-novie with PHP here. Toyed with it years ago, and just started working on a project that is based in PHP. I'm getting some information from a MySQL database, and I've used str_replace to modify most of what I need, but I'm pulling a domain name from a sentence, so what string_replace leaves me with is 'domain.name.com.'

I'm trying to get rid of the trailing period, and I've tried using:

$text="domain.name.com.";

$newtext=rtrim($text, '.');

The . does not go away. I've tried with double quotes as well.

Any help would be most graciously appreciated!




EDIT: Got it... thanks for all your help!

Source: http://www.livejournal.com/community/php/288213.html

Date: 04/20/05 (PHP Community)    Keywords: php, mysql, browser, html, database, sql

Hi all,
I have a program that gets its images from a mysql database. I pass a string to the program that gets the picture inside an HTML image tag like this:

<*img src=\"show_image.php/thumbnails/$boxData[thum_id]/img.jpg\">

This is what the string looks like when it has been passed:

show_image.php/thumbnails/7678/img.jpg

This is the program show_image.php

$pic_id = get_pic_id($_SERVER['REQUEST_URI']);

$table_name = get_table_name($_SERVER['REQUEST_URI']);

$file_data = get_file_data($pic_id, $table_name);

header("Content-type: " . $file_data['type']);

echo $file_data['binary_data'];

Source: http://www.livejournal.com/community/php/288307.html

Date: 04/21/05 (MySQL Communtiy)    Keywords: mysql, sql

Ok, got an odd question. Is it possible, given a list of words to be matched against a FullText index...when you get the results...how can you know what word (or words) the result was actually matched against? I'm using a few tricks from the online MySQL manual to get a relevance score, but what I really want to know is which word(s) gave the strongest "reason" for returning any given result.

Source: http://www.livejournal.com/community/mysql/54662.html

Date: 04/22/05 (Computer Geeks)    Keywords: php, mysql, sql, web

you guys know of a program that can emulate a webserver where I can test PHP scripts and also has mysql? Thanks.

Source: http://www.livejournal.com/community/computergeeks/666412.html

Date: 04/23/05 (Web Hosts)    Keywords: php, mysql, sql, web, hosting

I manage two domains, each under 10MB. For the past two years, they've been hosted with dr2.net, but then service got spotty and then they merged with Mesopia and the reviews got worse.

So, I'm looking to switch both domains to a new shared host. After checking out webhostingjury.com, I like the features of the standard plan of u-hs.com but the price seems a tad too steep. Looking for something in the area of $10 to $25 a year. One of the domains I expect to migrate to PHP and MySQL in the next few months.

Suggestions?

Source: http://www.livejournal.com/community/webhosts/26292.html

Date: 04/25/05 (WebDesign)    Keywords: php, mysql, asp, sql, web, hosting

I just recently register my domain name, and now I'm asking for those that have domains with storage access what hosting company are you using ? I prefer for the hosting company to be in the USA, and if it's not at lease have payment options in USA dollars.

I would like for the hosting company to have the following for service
FTP Access
PHP
ASP
CGI-BIN
MYSQL
WEB MAIL
ALLOWS MULTIMEDIA (really important I've been searching around hosting sites,but the ones I'm finding doesn't allow it)
SUB DOMAIN

and a good amount of space and bandwidth

Source: http://www.livejournal.com/community/webdesign/863860.html

Date: 04/26/05 (WebDesign)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev
I apologize in advance to all the people that are members of one or more of these communities

Source: http://www.livejournal.com/community/webdesign/864449.html

Date: 04/26/05 (Web Development)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev
I apologize in advance to all the people that are members of one or more of these communities

Source: http://www.livejournal.com/community/webdev/192585.html

Date: 04/26/05 (Web Development)    Keywords: php, programming, asp, sql, java, jsp

Koders.com is the leading search engine for open source code. Our source code optimized search engine provides developers with an easy-to-use interface to search for source code examples and discover new open source projects which can be leveraged in their applications.


excellent site for help with your computer programming. there seems to be a good bit of source code in here on these languages: Ada, ASP, Assembler, C, C#, Cpp, ColdFusion, Delphi, Eiffel, Erlang, Fortran, Java, JavaScript, JSP, Lisp, Lua, Mathematica, Matlab, ObjectiveC, Perl, PHP, Prolog, Python, Ruby, Scheme, Smalltalk, SQL, Tcl, VB, VB.NET

i wish they included verilog.

Source: http://www.livejournal.com/community/webdev/192304.html

Date: 04/26/05 (PHP Community)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev

Source: http://www.livejournal.com/community/php/291689.html

Date: 04/26/05 (PHP Community)    Keywords: php, mysql, html, database, sql, web

I'm trying to do some really wacky stuff with a form.

Essentially, I'm reading in multiple columns from a table in a MySQL database (looping, obviously), and creating a form as I present the data. The challenge this presents is that for each loop, the form values have to have a unique identifier, so I'm trying to use variables. It's not working so well, but I'm using standard HTML to try to process the form. I've gleaned bits and pieces searching the web that PHP has its own method to handle form input.

So, I need a good book that has a lot of detail on how to work with forms. A good web resource would work too.

Thanks in advance!



This is a quick mockup of the code and how I'm presenting the form...

$count=0; while(list($name, $id, $message)= $result->fields) { echo "<input name=\"name$count\" value=\"Y\" type=\"checkbox\">$name<br>"; echo "<input name=\"id$count\" value=\"Y\" type=\"checkbox\">$id"<br>; echo "<input name="\msg$count\" value=\"$message\" type=\"hidden\">$message<br>"; $count++; $result->MoveNext(); }

So, in theory here, each loop should give a unique value to each form element. I just need to know how to process it. I'm writing selected data back into a seperate table, so I need to loop through the results and write them out.

Again, help is appreciated!

Source: http://www.livejournal.com/community/php/291348.html

Date: 04/26/05 (PHP Development)    Keywords: php, mysql, html, sql, web

I'm looking for a good PHP search engine with full text indexing, the ability to crawl pages itself, preferably MySQL storage, and advanced search options. It'd also be nice if it rendered output in streamlined xhtml, or uses Smarty but not required.

Any suggestions?

Posted in:
php php_dev webdesign webdev
I apologize in advance to all the people that are members of one or more of these communities

Source: http://www.livejournal.com/community/php_dev/55407.html

Date: 04/27/05 (C Sharp)    Keywords: database, sql, web, tracker

AxoSoft OnTime defect tracker

I thought I'd bring this nifty app to your attention. I'll start by saying that I'm not affilated with AxoSoft, I just happened upon their site one afternoon and found that they offer their bug tracking tool free of charge for single-user installations. They basically offer a Windows client, Web client and VS.NET client and database backend to a well featured bug and new feature tracking tool. It utilises a SQL Server database, so you'll need either a version of MSDE or SQL Server Personal Edition but obviously they're availble free of charge too.

After you've installed it, you can get a product key from the site to unlock the tool(s) you've installed indefinitely. I realise that outside of a team environment lone Developers often find it unnecessary to use such a tool, but I've found it to be pretty useful since installing it. So, I suppose YMMV :)

Source: http://www.livejournal.com/community/csharp/27649.html