-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 25/01/12 20:32, Ryan Macy wrote: > Simple is exactly what I'm trying to accomplish Nico. It's a pet > project to increase my knowledge, yet the high cost of most database > options on PaaS providers like Heroku leads me to believe that the > users would welcome a [very] low cost simple DBaaS implementation. > SQLite also hasn't been in the DBaaS space as far as I can tell, I want > a first :-)
You won't get very far trying to provide SQLite as a service for others since there will be so much to invent. The cost at providers includes things like multiple servers running so no single system failure causes problems, backups, replication, system administration, audit trails, response times, people and machines. In your case you also want to convince developers to use a new API, provide new debugging tools, implement a new identity, authentication and authorization mechanism and provide controls against malicious code or bugs. Additionally this has to be very low cost and presumably the data doesn't matter that much (cost, only one server at a time etc). I'd be delighted if you proved my scepticism wrong (progress depends on people being unreasonable!) but I'm sure we'll encounter flying bacon first. However there is another way of meeting similar goals. Have a look at Fossil (also by the author of SQLite). http://fossil-scm.org/index.html/doc/trunk/www/index.wiki Of note it is a single binary that has an embedded copy of SQLite, a web server, and the function is to provide source code control management. All in a single binary. When linked statically that binary will run virtually anywhere (low cost enough for you?) It doesn't need to provide a lot of the heavyweight identity, auth & auth and similar things because people just run a copy for themselves. It also has replication builtin so that addresses the need for backups and communicating data with others. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8g3FQACgkQmOOfHg372QQicwCfdsgijdzjePnqAI3CD7Tz5Joq utIAoKAspR1RA0W/augCra4irvae7OUN =P5SE -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users