Very interesting. I've looked a little into postgreSQL, not that much.
I think we've pretty much decided to stick with mySQL for now, it should
work for our purpose, but you've peaked my interest in postgreSQL.
Many thanks for your input on this Richard!
On 4/6/2016 3:13 PM, Dr. Hawkins wrote:
On Wed, Apr 6, 2016 at 10:38 AM, Ray <r...@linkit.com> wrote:
So Richard, what did you end up going with when neither sqLite nor mySQL
worked out for you?
postgreSQL
It's more mature in some ways than mySQL, but more importantly, I can give
compound transaction (there's a 500+ statement query on client opening).
It also has more advanced "replication" across multiple installations,
although I haven't gotten near implementing that yet.
It's also a free database, and is MIT license instead of GPL. It's used
within OS X, but I installed it separately after misadventure with OS X
server--apple changed major release of OS X on a minor release of server,
leaving things tea din the water and requiring reinstallation of an older
version just to export the db . . .
I think that postgres is also the only one of the three being discussed
that has a true boolean type, but that doesn't matter for most applications.
Also, if you find yourself crossing back and forth, you need to keep track
of things like each db representing true and false differently, and such
things. I use an in-memory SQLite for the client, but postgres for the
server. After some experimenting, I stopped storing the data fields on the
server, instead having fields for datetime, key, type (I have multiple
tables in memory), and just storing INSERT commands in it (all the
processing is actually done on he client. I *could* use an array [and at
one point did], but "SELECT . . . WHERE" is *so* much easier to write than
looping through arrays . . .)
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
