I'm building a major product using Lazarus 1.8.4, FPC 3.0.4, IBX 2.3.3 and
Firebird RDBMS 3x. I have a query that runs in the range of 1 to 3
milliseconds without the ORDER BY clause. But once I add the ORDER BY clause,
the query takes > 1.5 seconds. Be advised that there is an index on the
I'm a long time FlameRobin user and Firebird lover. After a server upgrade, I
found that FlameRobin doesn't run on Windows Server 2016.
Here's the cure:
New Firebird admin tool called FireBolt. Replaces FlameRobin.
Get your copy here: https://www.jetlyt.ca/
Learn more here:
I'm building a Firebird DB Admin tool, like FlameRobin (bc FlameRobin doesn't
work on Windows Server 2016 Essentials)
I'm 80% done and have everything working except I'm struggling with something
that shd be quite simple. I've searched the Internet and found nothing to help
me except the
Background:
I'm trying to use ScriptCase to build a PHP front end for an existing Firebird
2.5 DB project. Mission critical change tracking in this project is years old,
is self contained, and relies on CURRENT_USER.
Precursor to Problem:
In ScriptCase, the entire project logs in
Hi Dmitry, thank you for your answer. For may DB connection to FB, I'm using
TIBCConnection (IBDAC) (Specifically for Firebird) by DevArt. In the
documentation, it talks about connection pooling, and says that a connection
will only be re-used if all the parameters are the same between a
There seems to be contradictory information about maximum number of
simultaneous distinct user connections to Firebird. This document:
How many users can connect to Firebird simultaneously?
http://www.firebirdfaq.org/faq292/ says there is not limit, except for the
TCP/IP in the OS.
How
Does anyone do this? Are there any problems?
In a table called Steps, I have the following fields:
ID, B4Me, Dsc,
-ID field contains a unique ID for each record
-B4Me contains the ID of some other record in the table that MUST appear in a
result set, BEFORE this record. B4Me may be null. This is called the B4Me
order.
-Records
I've been designing FB DBs for years just using FlameRobin. It works great for
what I need to do, and I can use Delphi's modeler to show an ERD to fellow
developers when necessary. However, to explain how the DB relationships work to
a customer is still a challenge. Customers need a more