MySQL, PostgreSQL, Firebird , Oracle or some other more or less popular engine? Please vote, so that we all have better picture of the popularity of a particular database on Linux. It takes only a second, results available immediately!
How to find the procedures, trigger and views, that do not use an index in their operations?
How to find the procedures and triggers that have typical type casting problems?
How to know if your database servers garbage collection is working?
How to change the Character Set of all tables in a database?
How to compare the metadata of different databases and create a script that does all required changes?
How to activate a Version Control System for stored procedures and Triggers?
How to compare the current database object with an object in another database?
How to create a sql for a insert, update, delete or other statements automatically?
How to find all objects that have dependencies to the current object?
How to compare different hardware and database server concerning the speed?
See Solutions from the IBExpert Team below:
Read more
The Firebird 2 Quick Start Guide is now 100% ready, and available at this URL
http://www.firebirdsql.org/pdfmanual/Firebird-2.0-QuickStart.pdf
Hi all, A while back I asked if anyone know of any reasons as to why
Mediawiki, MythTV, Bugzilla etc etc could not run on Firebird. Read more
SQLLY Development team have started to publish a set of articles about Interbase/Firebird development and usage examples of IBStudio.
Here is the first three article headlines:
# Extreme database programming
What if your customer’s demands are changing rapidly ? Is there any reliable way to reflect these changes in your database structure ?
# “Active” Editor keeps your code safe
…the editor not only passively highlights keywords – but also checks the code for syntax rules compliance…
# Restoring a DB with deactivated indices
Sometimes you need to turn off indices to restore database. But how to get them back quickly ?
