Database Admin Controller for Code Igniter and Ext JS 4
I have been using Code Igniter and Ext JS 4 for several months. In that time, I have created a couple basic templates to display MySQL tables and perform CRUD…
Read moreEXTJS – JsonWriter not respecting DateFormat used with JsonReader
Recently while working on a project that used Extjs as the front-end to a MySQL application, we came across an interesting issue with Extjs’s JsonStore. The JsonStore automatically creates a…
Read moreCount number of tables in the database – MySQL
Determining the number of tables that are contained in a MySQL database is very straight-forward, although it is an often asked question. The simplest way to accomplish this is using…
Read moreWhat database does Facebook use?
What database does Facebook use is one of the most common questions asked when folks start taking about what database is the most scalable for large scale web applications. …
Read moreMySQL – ORDER BY does not sort data properly…
Imagine a developer working late at night trying to complete some simple queries for a report due the next day. No matter what she does, the resulting query will just…
Read moreMySQL – A simple script to truncate all MySQL tables in a Database
Want a quick and dirty way to Truncate all the tables in a MySQL DB? You can use the following one line script. mysqldump -ppassword YourDBName –no-data dumpfile | mysql…
Read more