Re: [Lazarus] Embedded/small database

2015-02-20 Thread Rik van Kekem
leledumbo wrote: Not changing anything doesn't mean nothing supplied. You still have to distribute it. No, you don't *need* to distribute one. But that wasn't your original argument. Your original argument was that you needed to *specify* a config file and *set* some environment variable before

Re: [Lazarus] Embedded/small database

2015-02-19 Thread leledumbo
Interesting. I don't know how firebird works without its .conf file, perhaps it has default value for everything. -- View this message in context: http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-Embedded-small-database-tp4040516p4040697.html Sent from the Free Pascal - Lazarus ma

Re: [Lazarus] Embedded/small database

2015-02-19 Thread Graeme Geldenhuys
On 2015-02-18 09:28, patspiper wrote: > Is there any other free WinCE database engine? In a pinch: dBase (TDBF) or even XML files (via tiOPF - which encapsulates them as if they are a SQL database). NexusDB is also fully implemented in Delphi (not sure if they support FPC yet, but worth asking. If

Re: [Lazarus] Embedded/small database

2015-02-19 Thread Graeme Geldenhuys
On 2015-02-18 08:03, leledumbo wrote: > single dll/so (or nothing if you statically linked it). With firebird > embedded, you need to: > - supply a bunch of dll/so (firebird doesn't consist of just one) > - specify a config file > - set some environment variables before program start > easy, but ce

Re: [Lazarus] Embedded/small database

2015-02-19 Thread Graeme Geldenhuys
On 2015-02-17 19:50, Michael Van Canneyt wrote: > Any database that allows you to store a string in a field that is declared as > integer (as sqlite does), is out. It goes against the basic rules of the > RDBMs: ACID. Period. Then you should add MySQL (and it's forks) to that list too. Doesn't a

Re: [Lazarus] Embedded/small database

2015-02-18 Thread Rik van Kekem
FreeMan wrote: that configuration file is firebird.conf, on firebird root folder. small info in there too. this file system optimization, usage memory block etc. thats about indexes for examp. parameter's detail infos can found in firebird docs On 18.02.2015 10:52, Rik van Kekem wrote: I've ne

Re: [Lazarus] Embedded/small database

2015-02-18 Thread FreeMan
that configuration file is firebird.conf, on firebird root folder. small info in there too. this file system optimization, usage memory block etc. thats about indexes for examp. parameter's detail infos can found in firebird docs On 18.02.2015 10:52, Rik van Kekem wrote: I've never done thos

Re: [Lazarus] Embedded/small database

2015-02-18 Thread Sven Barth
Am 18.02.2015 11:12 schrieb "Bee" : > > I don't understand why FreePascal users need SQLite while we already have ZMSQL. Basically ZMSQL acts more or less like sqLite. But ZMSQL doesn't need external library. Check it out at: http://wiki.freepascal.org/ZMSQL Likely because it's not known as much ;

Re: [Lazarus] Embedded/small database

2015-02-18 Thread Bee
I don't understand why FreePascal users need SQLite while we already have ZMSQL. Basically ZMSQL acts more or less like sqLite. But ZMSQL doesn't need external library. Check it out at: http://wiki.freepascal.org/ZMSQL On Wed, Feb 18, 2015 at 4:28 PM, patspiper wrote: > On 17/02/15 21:50, Micha

Re: [Lazarus] Embedded/small database

2015-02-18 Thread patspiper
On 17/02/15 21:50, Michael Van Canneyt wrote: On Tue, 17 Feb 2015, Kostas Michalopoulos wrote: Sqlite can be very fast, but it needs the proper setup for that (which may not be relevant in all cases). Beyond that, Sqlite has a lot of high profile users (not to make a piss match, but i coul

Re: [Lazarus] Embedded/small database

2015-02-18 Thread Rik van Kekem
leledumbo wrote: I didn't say it's difficult, but certainly sqlite is much easier. You use sqlite just like any other libraries, no setup required, just supply a single dll/so (or nothing if you statically linked it). With firebird embedded, you need to: - supply a bunch of dll/so (firebird doesn

Re: [Lazarus] Embedded/small database

2015-02-18 Thread leledumbo
it doesn't need complicated setup like fopen, but it can be used (in terms of storing and retrieving data, from its users point of view) like an rdbms :) -- View this message in context: http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-Embedded-small-database-tp4040516p4040592.html Se

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Michael Van Canneyt
On Tue, 17 Feb 2015, Kostas Michalopoulos wrote: Sqlite can be very fast, but it needs the proper setup for that (which may not be relevant in all cases). Beyond that, Sqlite has a lot of high profile users (not to make a piss match, but i couldn't see any big users in Firebird's site and e

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Kostas Michalopoulos
Sqlite can be very fast, but it needs the proper setup for that (which may not be relevant in all cases). Beyond that, Sqlite has a lot of high profile users (not to make a piss match, but i couldn't see any big users in Firebird's site and even those didn't seem to mention if it was embedded or c

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Graeme Geldenhuys
On 2015-02-17 14:54, leledumbo wrote: > It has much easier setup, though. Even easier than embedded firebird. Firebird's setup is pretty easy. I've deployed Client/Server and Embedded firebird under Windows, Linux and FreeBSD. For embedded I simply shipped the DLL/SO files needed and it all worked

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Henry Vermaak
On Tue, Feb 17, 2015 at 07:54:00AM -0700, leledumbo wrote: > Tested, it can't even manage 50,000 rows efficiently. Searching a > string takes minutes, while it takes a fraction of second in real > dbms. Interesting. I've seen benchmarks where sqlite query times for a full-text search on 12+ r

Re: [Lazarus] Embedded/small database

2015-02-17 Thread zeljko
On 02/17/2015 03:21 PM, Michael Van Canneyt wrote: Sqlite is only good for storing preferences. Anyone using it for something else is playing with fire. Since I've already burned my fingers ... + 1 :)) zeljko -- ___ Lazarus mailing list Lazar

Re: [Lazarus] Embedded/small database

2015-02-17 Thread leledumbo
ier than embedded firebird. Choose wisely. -- View this message in context: http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-Embedded-small-database-tp4040516p4040573.html Sent from the Free Pascal - Lazarus mailing list archive at Na

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Michael Van Canneyt
On Tue, 17 Feb 2015, Kostas Michalopoulos wrote: Possibly, but if there is no need to be networked then this adds extra baggage (ie. bloat) for no reason at all. There is no baggage. Both systems work with a dll, which you must ship. Up to that point, it is the same. The difference is tha

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Marcos Douglas
On Tue, Feb 17, 2015 at 10:34 AM, Kostas Michalopoulos wrote: > Possibly, but if there is no need to be networked then this adds extra > baggage (ie. bloat) for no reason at all. Sqlite is a tiny db designed > specifically for local use, used in a ton of places (including Firefox and > almost ever

Re: [Lazarus] Embedded/small database

2015-02-17 Thread Kostas Michalopoulos
Possibly, but if there is no need to be networked then this adds extra baggage (ie. bloat) for no reason at all. Sqlite is a tiny db designed specifically for local use, used in a ton of places (including Firefox and almost everything made by Apple these days) and has some of the highest quality so

Re: [Lazarus] Embedded small database

2015-02-17 Thread Ebi F. Ere
20150216/3edfdb8b/attachment-0001.html> -- Message: 2 Date: Mon, 16 Feb 2015 16:50:04 +0100 From: Kostas Michalopoulos Subject: Re: [Lazarus] Embedded/small database To: Lazarus mailing list Message-ID: Content-Type: text/plain; charset="utf-8" Is this something th

Re: [Lazarus] Embedded/small database

2015-02-16 Thread Graeme Geldenhuys
On 2015-02-16 15:50, Kostas Michalopoulos wrote: > Is this something that will be networked or running locally? If it is a > local only program, i'd go with sqlite. Firebird RDBMS allows you to run both Embedded (local DB access only) or Client/Server (TCP/IP access). This means the application c

Re: [Lazarus] Embedded/small database

2015-02-16 Thread Kostas Michalopoulos
Is this something that will be networked or running locally? If it is a local only program, i'd go with sqlite. On Sun, Feb 15, 2015 at 7:16 PM, Graeme Geldenhuys < mailingli...@geldenhuys.co.uk> wrote: > On 2015-02-15 16:58, zeljko wrote: > > Maybe you should look at Firebird. > > +1 > > Regards

Re: [Lazarus] Embedded/small database

2015-02-15 Thread Graeme Geldenhuys
On 2015-02-15 16:58, zeljko wrote: > Maybe you should look at Firebird. +1 Regards, - Graeme - -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Re: [Lazarus] Embedded/small database

2015-02-15 Thread FreeMan
Yes, my vote firebird too. its support embeded and server. and win, linux, osx support too. For embeded, no need to install just copied files. where your application. On 15.02.2015 18:58, zeljko wrote: Maybe you should look at Firebird. -- ___ Laz

Re: [Lazarus] Embedded/small database

2015-02-15 Thread zeljko
On 02/15/2015 05:26 PM, Chavoux Luyt wrote: Hi guys, I asked advice a long time ago on a small/embedded database that could be used for a desktop application and distributed by CD as part of the application.I got a variety of answers including mySQL, sqlite and others. At the time I was very par

[Lazarus] Embedded/small database

2015-02-15 Thread Chavoux Luyt
Hi guys, I asked advice a long time ago on a small/embedded database that could be used for a desktop application and distributed by CD as part of the application.I got a variety of answers including mySQL, sqlite and others. At the time I was very partial to somehow using postgreSQL, because I ha