Database delphi program

This makes the database slower Other bug is with Elevate software is autoinc fields. There is no way to reset it. Therefore I have not chosen the Elevat software even it is the fastest database. They say many good functions but how many of them we use it in fact. They just left the most important functions not supported but fixed many many unnecessary functions. FireBird offers the opportunity to scale up to multi-users sometime down the line, or if you need concurrency if your application goes multi-threaded.

SQLite is quite unrivaled if you only need single-user access, no other database comes close to it on any aspect, be it performance, convenience, SQL support or stability. I have tried intensly all mentioned databases and found only one that actually functions the way it should. And that is Accuracer. The only pity with accuracer is that its a three man band and chronic lack of proper support. It also is mainly static in development as we have seen no real features in years.

Not surprising since only one person actually develops it. It seems they are living on old fame. Users praise reflect that usually 10 years old comments. For a single user experience I would recommend Absolute Database. Oracle has become a bloatware and is slowly dying out. It locks only current record if its in use while the rest functions normally.

Nice database. Pity only it is stagnant. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Which embedded database to use in a Delphi application? Ask Question. Asked 13 years, 2 months ago. Active 5 years, 3 months ago. Viewed 32k times. Improve this question. JeffV Darrel Darrel 1 1 gold badge 5 5 silver badges 9 9 bronze badges. Add a comment. Active Oldest Votes. Improve this answer.

So I now agree with Gabr that this seems like the way to go — lkessler. Starting with Firebird 2. Multiple applications can access a local database at the same time. Lou Franco Lou Franco Nick Bradbury Nick Bradbury 1, 13 13 silver badges 13 13 bronze badges. See stackoverflow. I've used SQLite3 database using more than 4 GB of data, without any performance issue if some indexs are properly created, of course. That says it all.

Solid product. Good documentation and support. Rock solid product, no trouble. It is so good that I am using it as a webserver option instead of others sql options. Let's see, quick comparison: SQLite: dynamic typing in the database cross-platform files runs on Windows, Linux, Mac, etc. Myles Wakeham Myles Wakeham. My preference would be for FB for embedded apps. Jeremy Mullin Jeremy Mullin 4, 4 4 gold badges 34 34 silver badges 53 53 bronze badges.

As for size, nothing beats SQLite. Javier Javier Yes, you are correct. The docs for SQLite are very good. Take a look at NexusDB.

Have used very successfully in the past. Craig Craig Thomas Mueller Thomas Mueller. A database file in a network drive is nonsense. We are talking about an embedded database here, so a server doesn't make sense at all. But putting the database on a network drive while still accessing it only from one application does. Jamo Jamo 3, 6 6 gold badges 39 39 silver badges 65 65 bronze badges.

Daniel K. Johnson Daniel K. Johnson 29 1 1 bronze badge. Link looks to be dead. Found what looks to be the same content here: delphi. Link: componentace.

Tom Tom 1, 3 3 gold badges 15 15 silver badges 26 26 bronze badges. Not exactly embedded, since the database requires DLL's to be registered into the registry.

Still it is a good solution and one that I also use as it also scales easily to enterprise level SQL Server. I had to downvote, not because I don't agree, but because this question is referring to an embedded database server, and SQL is far from embedded. Runs in memory, fast, multi-threadding. Used to be free. Matthias Hryniszak Matthias Hryniszak 3, 3 3 gold badges 34 34 silver badges 50 50 bronze badges.

I have been looking for an active open source connection solution, and this looks great. If you want to see with your own eye pls just try and see.. I am thinking between two now absolute DB or DBisam4. Rohit Gupta 2, 11 11 gold badges 21 21 silver badges 36 36 bronze badges.

Eddie Eddie Use Sql Server Management Studio and one of the Sqlite managing utilities there is one which is an add-on for Firefox. Firebird all the way. Does pretty well everything and so far version 2. Mitch Mitch.

Eric Grange Eric Grange 5, 1 1 gold badge 35 35 silver badges 56 56 bronze badges. SQLite: There seem to be problems with concurrent access from multiple threads, though - see stackoverflow. Alister Alister 6, 4 4 gold badges 42 42 silver badges 64 64 bronze badges. Nobody recommended the BDE because it is not an embedded database.

Of course there is the added problem that it is no longer maintained. Tipe field ini menentukan tipe data yang dapat ditampung dalam field.

Untuk menampilkan daftar field yang tersedia, tekan tombol spasi atau klik kanan. Tipe field yang sering dipakai adalah seperti berikut ini. Tentukan lebar field pada kolom Size jika diperlukan.

Lengkapi struktur tabel. Klik tombol Save As sampai muncul kotak dialog Save Table , dan simpan nama tabel berikut nama file databasenya.

Klik tombol Save. Untuk keluar dari Database Desktop, pilih menu File lalu Exit. Memodifikasi Database. Cara memodifikasi file database hampir sama dengan membuatnya, tinggal membuka databasenya open table , lalu pilih Restructure untuk merubah field yang diinginkan tambah field, ubah urutan field, ubah nama field dan hapus field.

Lalu menyimpan Save atau mengganti menjadi nama lain save as file databasenya. Setelah selesai maka keluar dari program tersebut. Mengolah Database. Delphi menyediakan cukup banyak object dengan berbagai variasi untuk mengolah file database yang sudah Anda buat.

Kumpulan object untuk mengolah file database terdapat pada page Data Controls. Sebelum dapat mengolah sutu file database menggunakan object yang terdapat dalam page Data Controls, Anda harus mengaitkan database tersebut ke dalam form. Ada beberapa cara untuk mengaitkan file database ke dalam form, antara lain menggunakan object — object yang ada dalam page Data Access, page Ado, page InterBase atau page BDE Borland Database Engine tergantung dengan sistem database yang dirancang.

Pada bagian ini, kita akan membahas fasilitas — fasilitas dan tehnik pengolahan file database menggunakan page Data Access, page Data Controls dan page BDE.

Mengaitkan File Database ke dalam Form. Langkah pertama untuk mengolah suatu file database adalah mengaitkan file database tersebut ke dalam form. Untuk mempelajari cara tersebut lakukanlah langkah — langkah berikut ini. Buka aplikasi Project baru dengan menu File lalu New Application. Klik ganda pada icon Table yang terdapat dalam page BDE , atur letaknya, perlu diperhatikan bahwa object Table ini tidak dapat diubah ukurannya, karena pada waktu program dijalankan, object ini tidak akan ditampilkan.

Object Table ini menentukan file database mana yang akan dipakai. Perlu diingat bahwa dalam satu form, Anda dapat menggunakan beberapa tabel data sekalugus. Satu tabel data diwakili oleh satu object Table. Klik ganda icon DataSource yang terdapat dalam page DataAccess , kemudian atur letaknya.

Ubahlah setting nama propertynya menjadi dsBarang dan property DataSet — nya menjadi tbBarang. Object DataSource ini akan dipakai oleh object — object lain sebagai sumber data, sedangkan satu object DataSource akan mengacu pada satu object Table.

Dalam satu form dapat dibuat lebih dari satu object DataSource. Sampai disini, berarti file database Barang. Penjelasan icon yang dipakai. Mengaitkan tabel database ke dalam form. Mengambil data dari object dan menyediakan diri sebagai sumber data bagi object lain. Setelah Program dijalankan :. Menampilkan Data dalam Bentuk Tabel. Object DBGrid dapat dipakai untuk menampilkan database dalam bentuk tabel. Tampilan dalam bentuk tabel sangat bermanfaat karena dapat menampilkan beberapa record sekaligus dan lebih terlihat keterkaitan antar data.