Arsen, In addition to the already-mentioned Firebird SQL RDBMS, you might think of the commercial Oracle database, which is available free for developers (but it is not free if you release anything). Some advantages of Firebird: o Very small footprint: only a few megabytes for client and server installation, a breeze to install o Single database file, making it easy to back up or transmit data o Free and open-source, though tools and visual component library might cost a bit, unless you use native Delphi Interbase VCL o Very flexible: easy to extend with user-defined functions written in you preferred language o Unix and Windows servers are available Only disadvantage I've experienced is that it has fewer monitoring and maintenance tools than some commercial RDBMS.
As others also mentioned, avoid Access if more than one user is contemplated, and P'dox is not well supported (you wouldn't want to install old BDE, if you could avoid it). So why suggest Oracle, then? It is a well known product, and experience with it can carry over to employment opportunities. It is also capable of handling huge amounts of data and has every bell and whistle you might want. Installation packages run to a gigabyte, or so (do not try downloading it over a 56 kb/s modem :-). Bart ----- Original Message ---- From: "[email protected]" <[email protected]> To: [email protected] Sent: Wednesday, February 20, 2008 5:30:49 AM Subject: [delphi-en] Digest Number 2283 DB type advice Posted by: "Arsen Khachatryan" [EMAIL PROTECTED] cragrer Tue Feb 19, 2008 8:22 am (PST) Hello world, Im going to create a DB which have a many tables and records (more about 100 000)what kind of DB file you can advice?mdb, paradox or ??? Thanks Arsen Khachatryan ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
