Upcoming News » Database
If you're not testing, please stop reading this and start TATFT. If you are testing, you have no doubt had to deal with testing with a database. Testing with a database is usually inevitable, even if you go to extremes to prevent it (and you should). Testing with a database creates several issues.
Paul Reinheimer's PHP memory pro tip shows how re-assigning a value to a variable doesn't release the original value until the new data is ready. With large data lengths, this unnecessarily increases the peak memory usage of the application.
In Oracle you might come across this situation when dealing with LOBS. Here's an example that selects an entire LOB into PHP's memory. I see this being done
Hi, I’m Ashay Chaudhary, Program Manager at Microsoft. Today at DrupalCon SF 2010, we are reaching an important milestone by releasing a Community Technology Preview (CTP) of the new SQL Server Driver for PHP 2.0, which includes support for PHP Data Objects (PDO). Alongside our efforts, the Commerce Guys, a company providing ecommerce solutions with Drupal, is also presenting a beta version of Dr
Anil Kumar Panigrahi maintained a blog related to PHP - OSCommerce - CakePHP - CodeIgniter - JavaScript - Smarty - Drupal - Articles on PHP - SEO
Yesterday we were having a conversation on IRC about the need for more useful information about the internals of the database. "SHOW STATUS" is just too primitive in its design to provide the sort of detailed information you need to do operations. Yesterday we got a bug request over the number of "open tables" found after a particular query. The user had assumed the number was off, but what they
MySQL is known for its willingness to accept invalid queries, data values. It can silently commit your transaction, truncate your data....
The SQL Server Driver for PHP (also called the " sqlsrv " driver for it’s API prefix) has been available since July of 2008, but I still often see the "old" driver (the " mssql " driver) used to connect to SQL Server from PHP scripts. Many of the tutorials
TRUNCATE is usually a fast operation (much faster than DELETE FROM). But sometimes it just hangs; I’ve has several such uncheerful events with InnoDB (Plugin) tables which were extensively written to. The TRUNCATE hanged; nothing else would work; minutes pass.
Working on mycheckpoint, I have the intention of adding custom monitoring. That is, letting the user define things to monitor. I have my own thoughts, I would be grateful to get more input!
I'm seeking help from the MySQL community for what tools are used today to generate complex reports for enterprise applications that use MySQL. In an Oracle
MySQL has the same level of data integrity for numbers and strings as Oracle; when MySQL is correctly configured. By default (a reason I wish I knew why it is still the default), MySQL performs silent conversions on boundary conditions of data that will result in your data not always being what is specified. Let’s look at the following examples to demonstrate default behavior.
One of the things that’s great about the Internet is that it’s open to everyone. There are a million sites, all different, and everyone is free to invent their own way of doing things. Of course, that has left us with a legacy of systems which don’t always work well together.
All about how to make create / drop database with mysql using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article.
Several of my recent posts have focused on how to use the SQL Server Driver for PHP in various ways. You might think that I would know the driver API by heart at this point, but alas, my many trips back to the documentation are proof that my brain is like a fixed length queue – if something new goes in, something else must go out.
I just rolled a 0.0.2 release. In case you had 0.0.1 installed, just use pear upgrade-all to get it automatically. This release is trying to fix a random hang while reading documents from the source server.
