Hi people!
I just read on php.net that PHP 5 beta 4 is realeased and i just wanted to look at SQLite's website but i don't have any clue to use this new database. We can still use mysql but it's not bundled, i know that.
but...
should we continue using mysql or sqlite is better and try to learn how to code to use it?
any info about it will be appreciated. thank you.
SQLite?
Moderator: General Moderators
Whether or not to stick with mySQL is up for discussion - individually. The licensing change means that you can still develop open source/free PHP applications, but if you are developing them for commercial purposes, you'd have to pay license fees. If PHP bundled with MySQL is a hobby to you - stick with it. If you earn your living with it: think about Postgres or SQLite or any of the other free databases.
There is a nice discussion here: http://www.sitepoint.com/forums/showthread.php?t=115514
and quite indepth look at SQLite at:
http://www.hwaci.com/sw/sqlite/lang.html
There is a nice discussion here: http://www.sitepoint.com/forums/showthread.php?t=115514
and quite indepth look at SQLite at:
http://www.hwaci.com/sw/sqlite/lang.html
-
Straterra
- Forum Regular
- Posts: 527
- Joined: Mon Nov 24, 2003 8:46 am
- Location: Indianapolis, Indiana
- Contact:
I currently use SQLite because my server is too slow to run MySQL. It is usefull for smaller applications and I even wrote a music management system with SQLite. I would be more than happy to answer any questions you may have about SQLite, but I 100% recommend it!
The link for my management system is viewtopic.php?t=16773 or http://eckclan.sytes.net/music.php
The link for my management system is viewtopic.php?t=16773 or http://eckclan.sytes.net/music.php
- voodoo9055
- Forum Commoner
- Posts: 51
- Joined: Sat Apr 26, 2003 3:27 pm
- Location: Montgomery, AL
-
ilovetoast
- Forum Contributor
- Posts: 142
- Joined: Thu Jan 15, 2004 7:34 pm
First off, I for one am enthusiastic about SQLite and the bundling switch for PHP. It is an awesome db that is more than enough for 75%+ of all PHP projects I've ever seen/heard of. It is more than enough to handle virtually anything you did with MySQL.
The few things it doesn't do, MySQL doesn't really do well anyways. MySQL is not a true RDBMS, as everyone here knows. If you truely need an RDBMS you shouldn't be using MySQL anyways. Postgres or Sybase or Oracle or Frontbase or any of several others are better options.
Only problem is really for Winblows server users. SQLite works great on Winblows. Postgres does not. Oh well, add that as reason number #598 why I thank God every day I don't use Winblows.
To answer your question voodoo, yes. You have to have SQLite somewhere, just as with MySQL you have to have MySQL somewhere. It is a tiny thing and I assume it will be bundled with PHP5 (I'm not sure as I haven't touched the beta).
The few things it doesn't do, MySQL doesn't really do well anyways. MySQL is not a true RDBMS, as everyone here knows. If you truely need an RDBMS you shouldn't be using MySQL anyways. Postgres or Sybase or Oracle or Frontbase or any of several others are better options.
Only problem is really for Winblows server users. SQLite works great on Winblows. Postgres does not. Oh well, add that as reason number #598 why I thank God every day I don't use Winblows.
To answer your question voodoo, yes. You have to have SQLite somewhere, just as with MySQL you have to have MySQL somewhere. It is a tiny thing and I assume it will be bundled with PHP5 (I'm not sure as I haven't touched the beta).