Category Archives: Databases
- October 22, 2008
- Aqua Data Studio 7 includes an ER modeler– also posted in Tools
Those of you who miss diagramming support when using MySQL tools will be pleased to know that the latest version of Aqua Data Studio has support for ER Modeling
The Entity-Relationship (ER) Modeler we’ve built into Aqua Data Studio 7 is as powerful as even the best standalone database diagramming tools. Use it to [...]
- August 22, 2008
- MySQL aliases (just like table names) are case sensitive on *nix
As you might know when using MySQL on a case-sensitive OS (like Linux) you must reference your table names in a case sensitive manner. So if you have a table called products the following sample query will NOT work:
SELECT productId
FROM ProductsIt won’t work because MySQL stores the table information in directories on the file system, therefore these [...]
- May 22, 2008
- INSERT DELAYED with MySQL
Yet another tip for MySQL users, INSERT DELAYED.
What does it do? Well when you execute your query MySQL will return an ok immediately to your application, and the request then gets queued to be INSERTED when the table in question is not being used by any other thread. This obviously means your application doesn’t [...]
- April 24, 2008
- INSERT or UPDATE in one statement with MySQL – performance test
Yesterday I posted on a handy MySQL feature where you can combine an INSERT and UPDATE on a record in the one statement.
Someone asked about the performance of this so I ran a little test to get some basic numbers.
One thing to note is that even when MySQL is actually UPDATING your record (ON DUPLICATE [...]
- April 23, 2008
- INSERT or UPDATE in one statement with MySQL– also posted in ColdFusion
A little while ago I mentioned combining multiple INSERT statements with MySQL, here is another helpful approach to a common problem.
In many systems you will give the user a chance to ADD and EDIT a record, a News post for example. As usual there are many ways to handle writing any changes to the database, [...]