I know this might be unappealing to web programmers as this isnt a popular choice buh I intend to use sqlite in a production environment for a change on a site Im developing with python-django. I understand sqlite has issues with concurrency buh the site wouldnt require people writing to its db, I'd only need to fetch data to visitors based on request... Just want to know if anyone here has used this db for a "live" site and is there anything I should watch out for?


Thanks.py

I wont advice you to use it, even in the django website, it was mention their. you know how file databases work. when you open a file to read from it, no other can read from it untill you close it. so the concurrency is not just when you are writing to it. it is also their when you are reading from it. Most web servers are multithreaded in nature

Sqlite is mostly used for mobile/Android and desktop apps.

For web look further.

Chimanet: I wont advice you to use it, even in the django website, it was mention their. you know how file databases work. when you open a file to read from it, no other can read from it untill you close it. so the concurrency is not just when you are writing to it. it is also their when you are reading from it. Most web servers are multithreaded in nature

Uhm, thanks... I didnt come across the bolded as a challenge facing sqlite when I went thro' their website. Infact the creator boasted that the db can withstand more than 100k visits at a time. My desire to use it was cuz the app Im developing wont require any form of user interaction and the admin page would be administered by a User
I'd look into ur other points as well. Up until nau, Im a MySQL'er and maybe thats why I know not of all these issues and limitations buh using it for the project nau looks like an overkill

umaryusuf: Sqlite is mostly used for mobile/Android and desktop apps.

For web look further.

Yep true, Ive used it once for a gui app... Buh we cant rule out the fact that it can support our web needs in rare case admittedly