|
|
Beginner's guide to SQLite?
|
|
|
|
Mac Elite
Join Date: Mar 2001
Location: CO
Status:
Offline
|
|
I've been doing my own PHP/MySQL for a while now.
For small web sites where I might rather not create its own MySQL db, the idea of SQLite being included in the PHP5 install is very attractive. My hosting service has it activated.
But I can't get a sense whether my style of operating with PHP/MySQL will easily transfer over (I'm not doing anything object-oriented as yet).
And the "manual" at http://us3.php.net/sqlite does NOT start with an overview. I'd love it if there were the equivalent of PHPMyAdmin for sqlite... since using that helped me out oftentimes in getting a feel for how to structure commands for MySQL.
Since I'm working on a remote host I've not got access to command line for working on the SQLITE db.
Anyone know a good primer (site or book)? I looked at "The Definite Guide to SQLite" but the reviews at Amazon really don't give me an idea of whether the move from MySQL to SQLite is going to be a piece of cake or not.
Many thanks.
|
TOMBSTONE: "He's trashed his last preferences"
|
|
|
|
|
|
|
|
Mac Enthusiast
Join Date: Aug 2001
Location: Durango CO
Status:
Offline
|
|
Well its pretty simple if you already know MySQL and i think there is something called phpSQLite admin or some such nonsense (to lazy to look it up right now). All you have to remember is your sqlite file has to be writable by the web server. You need to write a few functions to connect, select, insert etc. or just copy someone else's. All I used was the docs you mentioned and it wasn't too much trouble. It is nice not to have to setup a mysql db for quick and dirty stuff.
|
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Mar 2001
Location: CO
Status:
Offline
|
|
|
TOMBSTONE: "He's trashed his last preferences"
|
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Dec 2006
Status:
Offline
|
|
Originally Posted by Love Calm Quiet
Use MAMP instead. It makes the whole process too easy!
|
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Mar 2001
Location: CO
Status:
Offline
|
|
Sounds very cool, but what about it not keeping up to date, esp.with PHP now being at 5.2.xx. Here's what they list as specs of last build:
Version: 1.3.1
released on: 07-13-2006
Included software & libraries
Apache Version: 2.0.55
MySQL Version: 5.0.19
PHP Version: 4.4.2 & 5.1.4
eAccelerator: 0.9.5b2
Zend Optimizer: 2.6.0
phpMyAdmin 2.7.0-pl2
SQLite Version: 2.8.16
SQLiteManager Version: 1.1.3
Freetype Version: 2.1.9
t1lib Version: 5.1.0
curl Version: 7.14.0
jpeg Version: 6b
libpng Version: 1.2.5
gd Version: 2.0.28
|
TOMBSTONE: "He's trashed his last preferences"
|
|
|
|
|
|
|
|
Mac Enthusiast
Join Date: Aug 2001
Location: Durango CO
Status:
Offline
|
|
Uh - you really shouldn't stress about keeping up with the latest server side stuff - your web host will most likely be a few versions behind except for security updates. heck half of em still use apache 1.3 and it still works fine.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|