Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Developer Center > Beginner's guide to SQLite?

Beginner's guide to SQLite?
Thread Tools
Love Calm Quiet
Mac Elite
Join Date: Mar 2001
Location: CO
Status: Offline
Reply With Quote
Dec 12, 2006, 06:40 PM
 
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"
     
mania
Mac Enthusiast
Join Date: Aug 2001
Location: Durango CO
Status: Offline
Reply With Quote
Dec 17, 2006, 06:40 PM
 
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.
The Bitcastle
graphic design, web development, hosting
     
Love Calm Quiet  (op)
Mac Elite
Join Date: Mar 2001
Location: CO
Status: Offline
Reply With Quote
Dec 23, 2006, 07:47 PM
 
Thanks, I found that there's work on resurrecting phpSQLite admin. See:
Fosilis.com - home of phpSQLiteAdmin, nSpire and other goodies
But I've yet to figure out how to get it loaded. Let's see what Fosilis comes up with.
TOMBSTONE: "He's trashed his last preferences"
     
cyber1
Fresh-Faced Recruit
Join Date: Dec 2006
Status: Offline
Reply With Quote
Dec 25, 2006, 09:54 AM
 
Originally Posted by Love Calm Quiet View Post
Thanks, I found that there's work on resurrecting phpSQLite admin. See:
Fosilis.com - home of phpSQLiteAdmin, nSpire and other goodies
But I've yet to figure out how to get it loaded. Let's see what Fosilis comes up with.
Use MAMP instead. It makes the whole process too easy!
     
Love Calm Quiet  (op)
Mac Elite
Join Date: Mar 2001
Location: CO
Status: Offline
Reply With Quote
Dec 26, 2006, 12:17 PM
 
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"
     
mania
Mac Enthusiast
Join Date: Aug 2001
Location: Durango CO
Status: Offline
Reply With Quote
Dec 26, 2006, 10:34 PM
 
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.
The Bitcastle
graphic design, web development, hosting
     
   
Thread Tools
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 07:34 AM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,