Re: [sqlite] Web application with SQLite

To add to other answers: SQLite is a great DB back-end - I believe the Website at www.sqlite.org and Fossil repositories hosting the code there are all running on SQLite (if you fancy browsing an SQLite site to compare). PHP natively supports SQLite, MySQL, Postgres and MSSQL, which means the

Re: [sqlite] Web application with SQLite

On 27 Dec 2013, at 9:14pm, Igor Korot wrote: > Does people use SQLite for Web development? Or web apps are written > only with mySQL/MS SQL? I use SQLite databases to run about 10 web-facing applications for my department. The applications are written in JavaScript, but

Re: [sqlite] Web application with SQLite

Igor Suggest you look at http://www.sqlite.org/whentouse.html Your questions are very broad and don’t really have a right or wrong answer. You might as well start a flame war by asking the best language for software development. Everybody has their own version of the truth, mine happens to

[sqlite] Web application with SQLite

Hi ALL, Does people use SQLite for Web development? Or web apps are written only with mySQL/MS SQL? What are pros/cons of usinf SQLite for Web app? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] "Common Table Expression"

RSmith - I said "often", not "entirely". :) Discussion about how to better use SQLite for an already working implementation or for a proposed implementation is a great and proper use of the list. Coming onto the list and asking how to store a simple branch-and-leaf tree structure in SQL is

Re: [sqlite] "Common Table Expression"

Hi again, I know the focus of SQLite people on "size", and "testing". Wouldn't a basic implementation of CTE in fact : - help the "size" of the global embedded system to be smaller ? - without impacting the "testing" ? Indeed, a "simple" implementation of CTE : * could rely only on SQLite

Re: [sqlite] "Common Table Expression"

Sorry, this struck a bit of a sore spot with me, so I apologize for the small rant... Feel free to completely ignore it. You have every right challenging the views of anyone - It is welcome even (I think - cannot speak for everyone else though, but I appreciate it). A rant however is