-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 22 Feb 2012 17:10:39 -0800 Roger Binns <rogerb-jfdgoz7s+bwwqnjq7v0...@public.gmane.org> wrote:
> Just start using SQLite and see what happens. Good one. We'll try to (artificially) populate our sqlite database and then play with it. > You don't have to use an ORM. And if you don't use one, you'll > eventually see if you need one and what functionality it needs. After reading The Vietnam of Computer Science it definitely looks to me that using OOP costs too much for not much gain and we'll try to produce more FP-oriented code. > I do have two other recommendations. The first is to ensure you have > a sensible way of testing. A layer between your code and the > database may make that easier or harder - validate up front that it > will be the former. I believe one layer less is better in our case. :-) > The second is to ensure you have an undo mechanism, as this will > affect your schema and triggers. One thing I worked on didn't even > have a 'save' menu item. Every action you did resulted in a database > change. You could easily undo these. You could also see of the > objects as they were at any prior point in time, being able to undo > or redo any change. That sounds great, although atm I'm not sure how to tackle it, although it seems that Richard is giving some nice advice in regard. Sincerely, Gour - -- What is night for all beings is the time of awakening for the self-controlled; and the time of awakening for all beings is night for the introspective sage. http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJPRh/jAAoJELhxXPVStcgQKGsP/A0Zqn9bU+AK8mr09YF3jCKf bkAvsiyl2cZt28Lr8oDuuowwdF3w561+RsV8pUAZ9dg4Y0zBtVF/vz5ZeVlh3CRD KpD2T94iR6jyuTgrGV4t/JPH+F+e3BQ3G62T/r7WElbPClZqHUkqsXaS/2jbnB0T UaoYqd2az24vIRCgQXpXwTOtF71zMItcb6NN2kGtyRdS7uVROHHqk4hxbcN2BP6Y ObqHjplq5t2q18APaoQuTWmpVxv3C1XK/FIwBDpsmBRjwPR2wY+z+yPXXo9ekD13 18qc4rbw9rGLTtVl0gV73dapiZ9d7goN/V/gt+oUTcc7G7/dj+p3xfYJvMNewheh YrnUUVShA7d/OoTT4dQin9Cka+RTBnJuSQP8BCARFtgpWPTcDZ/l43sEWTQXDBES UDRq5Mr7r2x28NmZQtR4X7kOPjARbAz73v1Bf35EWsT4Sf1QDWY+HHj0wTY8SNfz tpVd6Gn3jyac2AqZ/N/JDRYsxg3CqLtSIBxQWST/0s6tWtOtx7DYAFM4o72d/GQe cUQOT59g5Ltf/qGJ2WJywB0DZ33w32ZkvIyXJNSZ7Fvy+r068hoC4iR5SQ846N7J f1WK4JGa+u3tCnFCMwp2RHitrYmALevQE5Wc+X0VwFrAUaV247STnMhqU9t6Hte5 ipQVBxtBSz8AXa/d9HIF =W+90 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users