Jump to content











Photo
- - - - -

SQLite forum


  • Please log in to reply
2 replies to this topic

#1 Nuno Brito

Nuno Brito

    Platinum Member

  • .script developer
  • 10545 posts
  • Location:boot.wim
  • Interests:I'm just a quiet simple person with a very quiet simple life living one day at a time..
  •  
    European Union

Posted 27 July 2010 - 11:26 AM

Hello,

I've always been a fan of INI files and never felt much attraction for databases such as MySQL as they only seem to add dependencies and over-complicate what should be simple to start with.

I guess this has been seen in projects like winbuilder and ninja where customized INI files are used to pass information from one side to another.

A lot of data needed to be indexed and text files were becoming problematic for two reasons:
  • To save time I need to keep data in memory
  • To save memory I need to keep data on files
So, keeping data in memory will make the program RAM hungry while keeping data in files will make data intensive processing slow.

A database seemed the only way to go and I really hated the need to keep multiple programs depending on a single place where things could go wrong. (guess I learned the hard way after all the issues we've felt on this site while using the old server).

While looking around I've found SQLite.

It doesn't require to install a service on the host computer like MySQL does. The databases are static files that we can move around with the program, it can index millions of data records and retrieve them very fast while using little RAM - I'm a happy coder.

Over these past few months I've been learning more and more about it, guess I've become a fan and since there was no forum for SQLite, then why not making one?

And the result is here - http://sqliteforum.com

It is running on myBB software and guess what type of database it is using..

You're all welcome to visit and chat if you ever see interest in moving onto this type of DB. Very cool stuff.

:cheers:

#2 Mikorist

Mikorist

    ▂ ▃ █ ▅ ▆

  • Advanced user
  • 771 posts
  •  
    United Nations

Posted 28 July 2010 - 05:45 PM

Very good news indeed :unsure:

Unfortunately I do not have enough time to participate in all forums :dubbio:

but.... i will visit and chat in that forum :)

#3 Nuno Brito

Nuno Brito

    Platinum Member

  • .script developer
  • 10545 posts
  • Location:boot.wim
  • Interests:I'm just a quiet simple person with a very quiet simple life living one day at a time..
  •  
    European Union

Posted 28 July 2010 - 06:24 PM

Hi,

Thanks for visiting but don't worry. The forum is mostly intended for those who are interested in trying out sqlite on their codings and need some help with the first steps.. :dubbio:

So far I'm really liking it a lot.

The forum itself is a good example of simplicity. I don't need to worry about keeping mySQL running or being afraid that someone breaks/corrupts the DB. It is also easier to keep backups and move it around if we need to move onto another server.

Would be nice to also see Boot Land running on SQLite one day. This is possible if we move from using IPB software onto myBB and use convert the mySQL DB onto SQLite. It might be interesting to try out and see how it goes.

Cool stuff.

:)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users