vidsgaq.blogg.se - Install interbase client only

If used as an embedded database, it offers a richer SQL support than SQLite as well as seamless migration to a client-server database, although SQLite is a quite capable embedded database itself. It can grow to terabyte scale given proper tuning, although PostgreSQL may be a better choice for such large environments.įirebird offers both embedded (file-based) and client-server database - usable without having to change a single line of code in FPC/Lazarus. The database requires very little manual DBA work once it is set up, making it ideal for small business use or embedded use. You can write compiled UDFs (User-Defined Functions) libraries for the server in FreePascal if you want to extend the already extensive function list of Firebird. INSERT.RETURNING), stored procedures, triggers, etc.

It includes rich support for SQL statements (e.g.

9.4 INSERT INTO.RETURNING problems/Cursor is not open =įirebird is an open source, free database server that has been in use and developed for decades (it developed out of the Interbase 6 database that was open sourced by Borland).

9.1 Attempted update of read-only column / COMPUTED BY fields.

5 Troubleshooting client/server access issues.

3 Client/server and embedded installation.