Michael Van Canneyt wrote:
Plus, and this is really what killed it for me: it does no type
checking.
You can perfectly store a string in an integer field in sqlite;
making it
impossible to use properly with TDataset.
It can be done, but you can get weird errors because
MyIntField.AsInteger w
On Tue, 12 Sep 2006, Luiz Americo Pereira Camara wrote:
Michael Van Canneyt wrote:
Yes, they are. And there sqlite fails miserably. I wrote a series of
articles, comparing several embeddable databases:
sqlite
mysql
firebird
advantage
nexusdb
And while sqlite had very good insert and s
At 09:14 11/09/2006, you wrote:
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
are biased)
http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'real-world' is importing 300 thousand records ? Aren't com
Michael Van Canneyt wrote:
On Tue, 12 Sep 2006, Luiz Americo Pereira Camara wrote:
Michael Van Canneyt wrote:
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so
"perhaps"
are biased)
http://sqlite.phxsoftware.com/foru
On Tue, 12 Sep 2006, Eduardo wrote:
At 09:14 11/09/2006, you wrote:
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
are biased)
http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'real-world' is imp
At 09:14 11/09/2006, you wrote:
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
are biased)
http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'real-world' is importing 300 thousand records ? Aren't com
On Tue, 12 Sep 2006, Luiz Americo Pereira Camara wrote:
Michael Van Canneyt wrote:
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
are biased)
http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'rea
Michael Van Canneyt wrote:
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
are biased)
http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'real-world' is importing 300 thousand records ? Aren't complex
On 9/11/06, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
>> 1024 simultaneous connections is hard coded in Firebird engine (1.5.x
>> at least)
>
>
> My larger clients better fire some staff then... :-)
> I will have to look into that, thanks.
Connection pooling can solve this, or a simple re
On Mon, 11 Sep 2006, Graeme Geldenhuys wrote:
On 9/11/06, Bogusaw Brandys <[EMAIL PROTECTED]> wrote:
> Yup! With our Delphi apps, we have done 100's but not yet 1000's. We
> don't have big enough clients to test 1000+ connections in our app.
>
> Regards,
> - Graeme -
>
1024 simultaneous c
On 9/11/06, Bogusław Brandys <[EMAIL PROTECTED]> wrote:
> Yup! With our Delphi apps, we have done 100's but not yet 1000's. We
> don't have big enough clients to test 1000+ connections in our app.
>
> Regards,
> - Graeme -
>
1024 simultaneous connections is hard coded in Firebird engine (1.5
Graeme Geldenhuys wrote:
On 9/6/06, Micha Nelissen <[EMAIL PROTECTED]> wrote:
Does Firebird support 100s to 1000s of clients ?
Yup! With our Delphi apps, we have done 100's but not yet 1000's. We
don't have big enough clients to test 1000+ connections in our app.
Regards,
- Graeme -
102
On Fri, 8 Sep 2006, Micha Nelissen wrote:
Eduardo wrote:
Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
are biased)
http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'real-world' is importing 300 thousand records ? Aren't complex
select queries *much* more i
Eduardo wrote:
> Here you have some benchmarks (posted in sqlite mail list, so "perhaps"
> are biased)
>
> http://sqlite.phxsoftware.com/forums/thread/622.aspx
How 'real-world' is importing 300 thousand records ? Aren't complex
select queries *much* more important ?
Micha
__
On Fri, 2006-09-08 at 08:01 +0200, Burkhard Carstens wrote:
> Am Freitag, 8. September 2006 01:18 schrieb Adrian Maier:
> > On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
> > > On that note I'd LOVE to see a series of Lazarus frameworks for
> > > implementing an Ajax application... That stuff is
On 9/8/06, Adrian Maier <[EMAIL PROTECTED]> wrote:
On 9/8/06, Cesar Romero <[EMAIL PROTECTED]> wrote:
> Burkhard Carstens escreveu:
> > Am Freitag, 8. September 2006 01:18 schrieb Adrian Maier:
> >> On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
> >>
> >>> On that note I'd LOVE to see a series o
On 9/8/06, Cesar Romero <[EMAIL PROTECTED]> wrote:
Burkhard Carstens escreveu:
> Am Freitag, 8. September 2006 01:18 schrieb Adrian Maier:
>> On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
>>
>>> On that note I'd LOVE to see a series of Lazarus frameworks for
>>> implementing an Ajax application
Burkhard Carstens escreveu:
Am Freitag, 8. September 2006 01:18 schrieb Adrian Maier:
On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
On that note I'd LOVE to see a series of Lazarus frameworks for
implementing an Ajax application... That stuff is hard to code!
An interesting d
Am Freitag, 8. September 2006 01:18 schrieb Adrian Maier:
> On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
> > On that note I'd LOVE to see a series of Lazarus frameworks for
> > implementing an Ajax application... That stuff is hard to code!
>
> An interesting dream indeed: to choose an 'ajax'
On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
On that note I'd LOVE to see a series of Lazarus frameworks for implementing
an Ajax application... That stuff is hard to code!
An interesting dream indeed: to choose an 'ajax' library instead of
gtk/qt/etc ,
then rebuild the lazarus applicati
I must state I've never used sqllite or embedded firebird. My issue
with firebird is the additional libraries you must install - which
isn't a big deal in Windows, but due to dependency hell I stay away
from anything requiring extra's. Does sqllite require extra
libraries? One of my key
Its a question of the right tool for the job, not a question of is a
screwdriver superior to the hammer. Each tool fits a different use
I'd use TDbf for a networked 5 user LAN environment, but if you want
something that works under more latency, for instance over the
Internet, or if you have
On Thu, 2006-09-07 at 17:16 -0400, Adrian Maier wrote:
For example, joining manually 4 tables with sums and 'group by' is not fun at
all, compared to executing a simple sql query . It would have been a huge
pain to generate the reports in my applications without a SQL engine !
Absolutel
On 9/7/06, Tony Maro <[EMAIL PROTECTED]> wrote:
On Wed, 2006-09-06 at 23:55 -0700, Adrian Maier wrote:
> If you start a new application, I see no reason not to use something
> better - that supports goodies like transactions and SQL . For a
> new stand-alone application I'd choose embedded-fir
On Thursday 07 September 2006 00:23, Michael Van Canneyt wrote:
> On Wed, 6 Sep 2006, Micha Nelissen wrote:
> > Michael Van Canneyt wrote:
> >>> Not scalable ? In what way ?
> >>
> >> It's not multi-user and network-capable.
> >
> > This is also simply not true. It is multi-user capable, and can us
On Thu, 2006-09-07 at 09:23 +0200, Michael Van Canneyt wrote:
I will invite you to pay some visits to schools where they use a administration
system, based on DBAse files on a network share. The first rule is: only 1 user
can edit a given table at a certain time. Failure to comply with thi
On Wed, 2006-09-06 at 23:55 -0700, Adrian Maier wrote:
If you start a new application, I see no reason not to use something
better - that supports goodies like transactions and SQL . For a
new stand-alone application I'd choose embedded-firebird with no
hesitations. If later it is decid
On Thu, 7 Sep 2006, Bisma Jayadi wrote:
I tested on 1.5.1 firebird, and it inserts 610.000 records in less than 1
minute in 1 transaction.
Wow... this is very impresive indeed! I tested on 1.5.3, inserting about
300.000 records in a single transaction, took about 9 minutes!
I think it's a
I tested on 1.5.1 firebird, and it inserts 610.000 records in less than
1 minute in 1 transaction.
Wow... this is very impresive indeed! I tested on 1.5.3, inserting about
300.000 records in a single transaction, took about 9 minutes!
I think it's about the table design, my table has 12 field
On 9/7/06, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
I tested on 1.5.1 firebird, and it inserts 610.000 records in less than 1
minute.
in 1 transaction.
Michael.
That's what I like to hear!! ;-)
Graeme.
_
To unsubscri
On Thu, 7 Sep 2006, Graeme Geldenhuys wrote:
On 9/7/06, Marco van de Voort <[EMAIL PROTECTED]> wrote:
Interbase (and the older firebirds, dunno the newer ones) had problems with
inserting several tenthousand records in one table in one transaction.
I tested on 1.5.1 firebird, and it inserts
On 9/7/06, Marco van de Voort <[EMAIL PROTECTED]> wrote:
Interbase (and the older firebirds, dunno the newer ones) had problems with
inserting several tenthousand records in one table in one transaction.
I guess I will be finding out shortly We have to import a couple
hundred thousand recor
On Thu, Sep 07, 2006 at 09:23:49AM +0200, Michael Van Canneyt wrote:
>
> I will invite you to pay some visits to schools where they use a
> administration system, based on DBAse files on a network share. The first
> rule is: only 1 user can edit a given table at a certain time. Failure to
> com
On Wed, Sep 06, 2006 at 10:48:12PM +0200, Graeme Geldenhuys wrote:
> >If everybody is writing the same record
> >all the time it may get nasty,
>
> I think for any system this is nasty! ;-)
IMHO every non trivial app where multiple processes access the db is nasty.
_
On Tue, Sep 05, 2006 at 09:31:58AM +0200, Michael Van Canneyt wrote:
> >I have no experience of using the database components in lazarus/Delphi,
> >so would appreciate some guidance with this. I feel the project is too
> >small to warrant using a stand alone database such as Firebird and the
> >
This is funny: in this thread i become an advocate of firebird although
in fact i mostly use PostgreSQL . :-)
We don't always use something we're advocating. I myself in fact mostly use
DB2 and -of course- mySQL for my official projects. But for personal projects,
I prefer Firebird. For devel
On 9/6/06, bouquinique <[EMAIL PROTECTED]> wrote:
One of the advantage off TDBF ( I 'm an user of it ): It dont't need
other than himself. For me this pont is very important, firebird or SQL
engines are not installed on all the computers. Créate fonctions to
export dbf files in other formats like
On Wed, 6 Sep 2006, Micha Nelissen wrote:
Michael Van Canneyt wrote:
Not scalable ? In what way ?
It's not multi-user and network-capable.
This is also simply not true. It is multi-user capable, and can use
files from a network share, but it's all done in the client, using file
locking.
On 9/6/06, Micha Nelissen <[EMAIL PROTECTED]> wrote:
Michael Van Canneyt wrote:
>> Not scalable ? In what way ?
>
> It's not multi-user and network-capable.
This is also simply not true. It is multi-user capable, and can use
files from a network share, but it's all done in the client, using file
On 9/6/06, Micha Nelissen <[EMAIL PROTECTED]> wrote:
Nice!
:-)
If everybody is writing the same record
all the time it may get nasty,
I think for any system this is nasty! ;-)
Graeme.
_
To unsubscribe: mail [EMAIL PROTEC
One of the advantage off TDBF ( I 'm an user of it ): It dont't need
other than himself. For me this pont is very important, firebird or SQL
engines are not installed on all the computers. Créate fonctions to
export dbf files in other formats like SQL, CSV, Or Firebird is not much
difficult.
O
Graeme Geldenhuys wrote:
> On 9/6/06, Micha Nelissen <[EMAIL PROTECTED]> wrote:
>> Does Firebird support 100s to 1000s of clients ?
>
> Yup! With our Delphi apps, we have done 100's but not yet 1000's. We
> don't have big enough clients to test 1000+ connections in our app.
Nice! With TDbf it's
On 9/6/06, Micha Nelissen <[EMAIL PROTECTED]> wrote:
Does Firebird support 100s to 1000s of clients ?
Yup! With our Delphi apps, we have done 100's but not yet 1000's. We
don't have big enough clients to test 1000+ connections in our app.
Regards,
- Graeme -
___
On 9/5/06, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
Nevertheless, it would be better to use an engine such as Firebird, because
it is scalable. Projects using DBase files or so are not scalable.
SQLite ?
http://www.sqlite.org/
Michael.
Tony
Graeme Geldenhuys wrote:
> This means a 1000 clients connecting and working on the same database
> is going to wreck havoc. I think this is what is meant by it doesn't
> scale. 10 clients might work fine, 30 might still work, but 100's or
> 1000's on client connections in not going to cope.
Does
On 9/6/06, Micha Nelissen <[EMAIL PROTECTED]> wrote:
Michael Van Canneyt wrote:
>> Not scalable ? In what way ?
>
> It's not multi-user and network-capable.
This is also simply not true. It is multi-user capable, and can use
files from a network share,
Network share is more of a hack than 'net
Michael Van Canneyt wrote:
>> Not scalable ? In what way ?
>
> It's not multi-user and network-capable.
This is also simply not true. It is multi-user capable, and can use
files from a network share, but it's all done in the client, using file
locking.
It does not support transactions, true; but
At 01:08 05/09/2006, you wrote:
Hello ,
I would like some advice on which type of database to
use for a small database type of program which includes the
database as part of the program. There would only be about 10 to 15
tables and most would only have about 50 records with a coupl
On Tue, 5 Sep 2006, Micha Nelissen wrote:
Michael Van Canneyt wrote:
Nevertheless, it would be better to use an engine such as Firebird, because
it is scalable. Projects using DBase files or so are not scalable.
Not scalable ? In what way ?
It's not multi-user and network-capable.
Michae
On 9/5/06, Borut Maricic <[EMAIL PROTECTED]> wrote:
Is fblib active, i.e. do you think it will support FB2.0 and
beyond?
Can't remember where I read it, but FB2.0 will be supported.
Regards,
- Graeme -
_
To unsubscribe: mail
> A very good set of components for Firebird is fblib
> (http://fblib.altervista.org/). Totally cross platform and stable - we
> have used it in commercial apps for almost a year now. It also has
> the Administration API implemented as well. Something still missing in
> the SqlDB units.
Is fblib
On Tue, 2006-09-05 at 22:32 +0200, Micha Nelissen wrote:
Michael Van Canneyt wrote:
> Nevertheless, it would be better to use an engine such as Firebird, because
> it is scalable. Projects using DBase files or so are not scalable.
Not scalable ? In what way ?
TDbf rulezzz ;-)
Says the au
A very good set of components for Firebird is fblib
(http://fblib.altervista.org/). Totally cross platform and stable - we
have used it in commercial apps for almost a year now. It also has
the Administration API implemented as well. Something still missing in
the SqlDB units.
Regards,
- Graeme
Michael Van Canneyt wrote:
> Nevertheless, it would be better to use an engine such as Firebird, because
> it is scalable. Projects using DBase files or so are not scalable.
Not scalable ? In what way ?
TDbf rulezzz ;-)
Micha
_
Hello Michael,Bismay and Graeme,
Thanks for your recommendation, I will use Firebird as you suggest.
Best regards,
=== At 2006-09-05, 19:31:58 you wrote: ===
>
>
>On Tue, 5 Sep 2006, Paul Parkyn wrote:
>
>> Hello ,
>> I would like some advice on which type of database to u
I agree both with Michael and Bisma. Firebird has a small footprint,
is scalable and hardly needs any administration. Not to mention you
could always use the Embedded version to make deployment even easier.
Regards,
- Graeme -
On 9/5/06, Paul Parkyn <[EMAIL PROTECTED]> wrote:
Hello ,
I feel the project is too small to warrant using a stand alone database
such as Firebird and the like.
Firebird is so small so I think it fits on your need. I suggest you to use the
embedded one. :)
-Bee-
has Bee.ography at:
http://beeography.wordpress.com
__
On Tue, 5 Sep 2006, Paul Parkyn wrote:
Hello ,
I would like some advice on which type of database to use for a small
database type of program which includes the database as part of the program.
There would only be about 10 to 15 tables and most would only have about 50
records wit
Hello ,
I would like some advice on which type of database to use for a
small database type of program which includes the database as part of the
program. There would only be about 10 to 15 tables and most would only have
about 50 records with a couple of tables having about 500 recor
59 matches
Mail list logo
