Current time: 07-31-2014, 03:34 PM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLite/PostgreSQL Support?
10-25-2006, 11:07 PM
Post: #1
SQLite/PostgreSQL Support?
Hello all,

I think it would be a really nice add if there was SQLite and or PostgreSQL support in MyBB, because I personally aren't fond of MySQL and it could help to expand the userbase of MyBB.

-maddog39
Visit this user's website Find all posts by this user
Quote this message in a reply
10-26-2006, 04:38 AM
Post: #2
RE: SQLite/PostgreSQL Support?
Both are already planned for 1.4 Smile
Visit this user's website Find all posts by this user
Quote this message in a reply
10-26-2006, 07:04 PM
Post: #3
RE: SQLite/PostgreSQL Support?
Dang, 1.4, thats such a long ways away. Im a PHP programmer, is there anyway I can possibly make a mod to do this, by modding the database abstraction layer, or would I need to modify all files.
Visit this user's website Find all posts by this user
Quote this message in a reply
10-26-2006, 07:25 PM
Post: #4
RE: SQLite/PostgreSQL Support?
You could try making a db_sqlite.php file that replicates all the functionality of db_mysql.php, then set your $config['dbtype'] to sqlite. I think some code modifications would be needed in inc/init.php, and the installer, and probably some other places as well to make everything compatible. I'm really not sure though. Toungue

Speaking of SQLite, is it really practical for a bulletin board application? Since everything is stored in one file, and there's no server, how well does it handle multiple concurrent users/queries?
Visit this user's website Find all posts by this user
Quote this message in a reply
10-27-2006, 11:08 PM
Post: #5
RE: SQLite/PostgreSQL Support?
Okay, I think ill try to make a DB file that replicates db_mysql.php, and both PostgreSQL and SQLite are compatible with most MySQL syntax, so i shouldnt have to mod much of the raw code at all. Also, yes SQLite is designed so it can handle fairly large loads at a time and its a ton faster than MySQL, too my knowledge SQLite can handle concurrent connection fairly well, I would assume that what it does is buffers all data going in and so that its not possible for it to have an I/O problem with two clients accessing the db at one time.
Visit this user's website Find all posts by this user
Quote this message in a reply
10-28-2006, 06:23 AM
Post: #6
RE: SQLite/PostgreSQL Support?
I've split the rest of the thread into http://community.mybboard.net/showthread.php?tid=13371 for further debating Wink

Dennis Tsang
http://dennistt.net
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication