|
Writing and reading
SQLData is an extension of
Execute SQL from a file on a
SQLiteManager is a
configuration for your
the DB class that is meant
MySQL database. Use this to
multilingual web based tool
scripts has never been so
to provide object-relational
import your database
to manage SQLite
easy. Using MySQL as the
mappings to store and
structure and data without
database.
The programming
backend and a minimal,
retrieve persistent objects
the use of e.g. phpMyAdmin.
language used is: PHP4 and
automatically updated
in a SQL database.
The
work fine with PHP5.
Work
conf.php file, SQLconf
class comes with additional
just as well on a platform
provides a solution for all
scripts for generating
Linux as on Windows or Mac
your configuration needs.
classes that can be used by
OsX.
This project is in
applications to access given
course of developpement, but
database table using the
it is alway very functional.
SQLData class as means to
The various functionality
store and retrieve data with
are:
- Management of
SQL statements.
These
several database
-
scripts are meant to run
Creation 'Connection' to
from the command line. They
several database
-
retrieve the definitions of
Property of the database.
a given database table and
- Management of the
then the generate classes to
options of the database. -
access the table rows as
Creation / update / delete
objects or to manipulate
tables
- Management of the
them via Web forms.
indices - Showing / Insert /
Experience has shown that
ALter / Suppression of data
the automatic generation
in the tables
- Imports
handles about 80% of the
data from a file
-
repetitive work involved in
execution of manual query
building classes and
from 'SQLite' format or from
forms.
SQLData was
'MySQL' format (conversion)
designed to make it easy to
- Create / Update / Delete
automate the construction of
of View
- create / Update
the application specific
/ Delete of Trigger
-
classes interfacing to SQL
Management of the user
tables. SQLData supports
defined function. (usable in
all databases supported by
SQLiteManager query)
-
the DB class, currently
exports structure and data
MySQL and PostgreSQL 8.0 and
to the SQL format
up.
Date: Mar, 03 2003 Date: Oct, 21 2006 Date: Oct, 02 2006 Date: Aug, 26 2004 |
|
SQLmax provide you an SQL
This is a script for dumping
I find this little script
This script automatically
layer to manage your
data out of Sybase for use
very useful for web
searches for the databases
database connection with an
with other database systems
applications that need to
within MySQL on your server.
database free relationship.
- tested with MySQL.
automatically generate
It then goes through each of
(independant from the
tables. I wrote it because I
the databases (it checks
database).
For the
felt it was wrong to have a
first to see if you have
moment we add the MySQL
script execute create table
permission to those
driver but other drivers
SQL statements for tables
databases) and optimizes all
(Oracle, ...) can be added
that already existed.
the tables within them. The
easily to our SQL layer.
only thing you have to
SQLmax provide you an
change in the script is your
additional internal cache
hostname, username and
system support wich can
password for MySQL.
increase the speed of your
database access (by 2 or 3
times). By managing the
paramaters you can switch
your dynamic website to
static one during the time
you need.
Developpers
will be happy to see an easy
syntax with a commented
scripting.
Date: Sep, 08 2005 Date: Jun, 30 2006 Date: Apr, 17 2005 Date: Feb, 06 2002 |