PUBLIC MARKS from mbertier with tag sql

Interactive sql tutorial - excellent

Modeliseur de BDD en AJAX. Impressionnant

This theme is an old one of mine, but it is worth repeating. I have been seeing too many questions about SQL trees and hierarchies in the newsgroup discussions.

When we talk about database “portability” in PHP, we need to discuss three separate concepts. 1. API portability 2. Data type portability 3. Command and service portability I’ll address points 1 and 2 in this posting, and point 3 in a later one.

Connect to most popular databases like PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase and FrontBase; Generate the complete ER-diagram from your Database; (Dia format)

Le présent tableau fait une synthèse des fonctions de la norme SQL, mais aussi des fonctions que l'on trouve dans les principaux dialectes des SGBDR que sont Paradox, Access, MySQL, PostGreSQL, SQL Server, Oracle et InterBase. Ce tableau ne prétend pas à l'exhaustivité mais permet la comparaison de l'implémentation des fonctions du SQL dans différents dialectes.

Building Truly Portable Database Applications in PHP

The following is a HOWTO document for installing PHP with iODBC as an Apache module on Linux or Unix.

For rich web application developers, the TrimQuery engine from TrimPath is a lightweight GPL open-source component that lets you have the power of SQL-like queries while running in a web browser.

PHP REST SQL is a class used to open a HTTP REST interface to a MySQL database using PHP and a HTTP server. Using standard HTTP requests, the data in a database can be created, retrieved, modified and deleted.

Native SQL support for Mozilla