Adminer - Database management in single PHP file
Category:
Adminer - Database management in single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.

PDO vs. MySQLi: Which Should You Use?
Category:
PDO vs. MySQLi: Which Should You Use? | Nettuts+
When accessing a database in PHP, we have two choices: MySQLi and PDO. So what should you know before choosing one? The differences, database support, stability, and performance concerns will be outlined in this article.

Tenzing A SQL Implementation On The MapReduce Framework
Category:
Tenzing A SQL Implementation On The MapReduce Framework
Tenzing is a query engine built on top of MapReduce for ad hoc analysis of Google data. Tenzing supports a mostly complete SQL implementation (with several extensions) combined with several key characteristics such as heterogeneity, high performance, scalability, reliability, metadata awareness, low latency, support for columnar storage and structured data, and easy extensibility.

DELETE IGNORE on Tables with Foreign Keys Can Break Replication
Category:
STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication - MySQL Performance Blog
DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, you could be in for a surprise.

How to recover a single InnoDB table from a Full Backup
Category:
How to recover a single InnoDB table from a Full Backup - MySQL Performance Blog
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is a little bit different story.

SQL Server Compact 4.0
Category:
Download Details - Microsoft Download Center - SQL Server Compact 4.0
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix, and seamless migration of schema and data to SQL Server.

Google Cloud SQL - Google Code
Category:
Google Cloud SQL - Google Code
Google Cloud SQL is web service that allows you to create, configure, and use relational databases with your App Engine applications. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

By offering the capabilities of a MySQL database, the service enables you to easily move your data, applications, and services into and out of the cloud. This allows for high data portability and helps in faster time-to-market because you can quickly leverage your existing database (using JDBC and/or DB-API) in your App Engine application.

SQL Generator for testing SQL servers
Category:
SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL) in Launchpad
This project implements a pseudo-random data and query generator that can be used to test any Perl DBI, JDBC or ODBC-compatible SQL server, in particular MySQL, but also JavaDB and PostgreSQL.

A day in the life of a slow page at Stack Overflow
Category:
A day in the life of a slow page at Stack Overflow
Tuning SQL is key, the simple act of tuning it reduced the load time for the particular page by almost 50% in production. However, having a page take 300ms just because your ORM is inefficient is not excusable. The page is now running at the totally awesome speed of 20-40ms render time. In production. ORM inefficiency cost us a 10x slowdown.

PHP implementation of the MySQL old_password function
Category:
PHP implementation of the MySQL old_password function
MySQL has a built in function called password that calculates the hash of a password for secure storage in a database. In MySQL versions older than 4.1 the hashing function was very basic so all newer versions uses the cryptograpichally secure SHA-1 hashing algorithm

How to calculate a password hash the 'old way'