I have come to the conclusion that for my purpose I would be better off using sqlite from www.sqlite.org or firebird from www.phoenix.com.
Although mysql provides client APIs & server APIs and is stable. But there seems to be doubt whether mysql is actually free if I wish to use it as an embedded database. It has been suggested that I would have to pay $10,000 one off licence fee if I include mysql in my app. Another person suggested that mysql is free to include in my app, so I am simply not sure over the licence costs of mysql. --- Dustin Sallings <[EMAIL PROTECTED]> wrote: > > On Nov 14, 2003, at 14:13, jini us wrote: > > > I would class your solution as a work around > > rather than a "natural solution". > > It really seemed like the obvious way to do it (I'm > sure I'm not the > only person who thought of that, but didn't post > it). > > > Anyway I am using MS windows and to implement > > postgres as embedded, using your approach, would > > probably become complicated. > > .It would probably introduce unwanted bugs in my > > software. > > I believe it would be you introducing those bugs if > you do not > initialize the DB correctly, regardless of the > mechanism. > > Now, how many bugs do you think it would create in > postgres if the > entire interface model were changed from > postmaster/postgres processes > to having multiple threads in a single application > trying to issue > queries in the in-process DB. What happens to the > DB when your app > segfaults? Are there any signal handlers postgres > uses that you would > want to use in your app? Do you really need to > redesign the way > postgres works just because you don't want to manage > the resource as a > process rather than a different type of API? > > -- > Dustin Sallings > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose > an index scan if your > joining column's datatypes do not match ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
