A tool I use a lot is the WWW SQL Designer, and I recently made some changes that make it work easier. These were merged into the project as version 1.4 this week. Among other minor changes, I re-wrote the backend that handles saved schemas to use PHP Data Objects instead. This enables the use of other database engines (besides MySQL), and allows saving schemas out-of-the-box (using SQLite). As of 1.4, this new functionality is optionally available (the old io.php is still the default). To enable it, change io-pdo.php to io.php and then (if necessary) modify the DSN to match your setup.
/*
How to set up a database connection
If you change nothing, an SQLite database called database.db will be
created in the install directory (if it's writable by the web server),
and saving/loading schemas will work out-of-the-box.
You can also specify a custom DSN to use some other database system
(like MySQL) or to use an existing database from a previous version of
WWW SQL Designer.
SQLite example: sqlite://./var/db/wwwsql/schemas.db/wwwsqldesigner
This designates a SQLite file at /var/db/wwwsql/schemas.db with
a table called wwwsqldesigner
MySQL example: mysql://user:pwd@sakila.example.com/schemas/wwwsqldesigner
This will connect to a MySQL server at sakila.example.com using the
username 'user' and a password of 'pwd' to access a database
called 'schemas' with a table called 'wwwsqldesigner'
If you use 'localhost' instead of 'sakila.example.com' this will
connect to a database server on the same machine as the web server.
*/
//define('DSN', 'mysql://user:pwd@localhost/database/table');
//define('DSN', 'sqlite://./absolute/path/to/database.db/table');
define('DSN', 'sqlite://.'.dirname(__FILE__).'/database.db/wwwsqldesigner');
Scratch that. We got as far as Killeen and my starter gave out. I did get it started so we could drive back home, but I'll spend today under my truck. Everyone with a yellow flag (including Dave B., who didn't even get time for his flag to appear) should be expecting a phone call instead of a visit.
We'll be headed for the homestead for Thanksgiving. If you'd like a yellow flag somewhere along a blue line, send me an email quick.
You have got to be fucking kidding me.
You cannot install Adobe Creative Suite 3 to a volume that uses a case-sensitive file system, such as HSFX or UFS. Adobe Creative Suite 3 installation is supported on volumes using HFSJ or HFS+ file systems.
I have to re-install just to get Photoshop? Bollocks.
[ home - archives - quoteboard - blogger decoder - wishlist ]
This work is licensed under a
Creative Commons License.