firebird | Firebird server, client and tools | Database library

I have been a Delphi programmer for 25 years, but managed to avoid SQL until now. I was a dBase expert back in the day. I am using Firebird 3.0 SuperServer as a service on a Windows server 2012 box. I run a UDP listener service written in Delphi 2007 to receive status info from a software product we publish.

The FB database is fairly simple. I use the user's IP address as the primary key and record reports as they come in. I am currently getting about 150,000 reports a day and they are logged in a text file.

Rather than insert every report into a table, I would like to increment an integer value in a single record with a "running total" of reports received from each IP address. It would save a LOT of data.

The table has fields for IP address (Primary Key), LastSeen (timestamp), and Hits (integer). There are a few other fields but they aren't important.

I use UPDATE OR INSERT INTO when the report is received. If the IP address does not exist, a new row is inserted. If it does exist, then the record is updated.

I would like it to increment the "Hits" field by +1 every time I receive a report. In other words, if "Hits" already = 1, then I want to inc(Hits) on UPDATE to 2. And so on. Basically, the "Hits" field would be a running total of the number of times an IP address sends a report.

Adding 3 million rows a month just so I can get a COUNT for a specific IP address does not seem efficient at all!

Is there a way to do this?

...

I've been trying to install/compile the php-firebird driver for php7.4 on macos but so far wasn't successful.

There is an issue open in the driver repo, but not much going on in terms of help. https://github.com/FirebirdSQL/php-firebird/issues/6

So far I did this:

1. Installed https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdCS-2.5.9-27139-x86_64.pkg (also tried with firebird 3.x)
2. Cloned this repo to php-firebird
3. cd php-firebird
4. phpize
5. CPPFLAGS=-I/Library/Frameworks/Firebird.framework/Versions/Current/Headers LDFLAGS=-L/Library/Frameworks/Firebird.framework/Versions/Current/Libraries ./configure
6. make ... and that's where the errors begin

...

I am a newbie in data analysis. I wish to know how to boxplot multiple columns (x-axis = Points, Score, Weigh) in a single graph and make the y-axis as a standardized scale for comparison. I have tried and couldn't understand the code (Python+Pandas+Seaborn) for this. Help me out guys. The dataset for the same is as follows:

Cars Points Score Weigh 0 Mazda RX4 3.90 2.620 16.46 1 Mazda RX4 Wag 3.90 2.875 17.02 2 Datsun 710 3.85 2.320 18.61 3 Hornet 4 Drive 3.08 3.215 19.44 4 Hornet Sportabout 3.15 3.440 17.02 5 Valiant 2.76 3.460 20.22 6 Duster 360 3.21 3.570 15.84 7 Merc 240D 3.69 3.190 20.00 8 Merc 230 3.92 3.150 22.90 9 Merc 280 3.92 3.440 18.30 10 Merc 280C 3.92 3.440 18.90 11 Merc 450SE 3.07 4.070 17.40 12 Merc 450SL 3.07 3.730 17.60 13 Merc 450SLC 3.07 3.780 18.00 14 Cadillac Fleetwood 2.93 5.250 17.98 15 Lincoln Continental 3.00 5.424 17.82 16 Chrysler Imperial 3.23 5.345 17.42 17 Fiat 128 4.08 2.200 19.47 18 Honda Civic 4.93 1.615 18.52 19 Toyota Corolla 4.22 1.835 19.90 20 Toyota Corona 3.70 2.465 20.01 21 Dodge Challenger 2.76 3.520 16.87 22 AMC Javelin 3.15 3.435 17.30 23 Camaro Z28 3.73 3.840 15.41 24 Pontiac Firebird 3.08 3.845 17.05 25 Fiat X1-9 4.08 1.935 18.90 26 Porsche 914-2 4.43 2.140 16.70 27 Lotus Europa 3.77 1.513 16.90 28 Ford Pantera L 4.22 3.170 14.50 29 Ferrari Dino 3.62 2.770 15.50 30 Maserati Bora 3.54 3.570 14.60 31 Volvo 142E 4.11 2.780 18.60

My output should look something like: Output Boxplot Graph

...

I have a Ruby application that crashes sometimes with this error message:

Fb::Error: A transaction has already been started)

I'm now wondering what this message means. I searched a little bit and I read that Firebird is not supporting nested transactions. Could the message hint to this? If not, what else could this mean?

...

I know that polr does not give p-values because they are not very reliable. Nevertheless, I would like to add them to my modelsummary (Vignette) output. I know to get the values as follows:

...

I have two double joins (I believe that's what they would be considered) and it just seems awfully slow to do them separately. I know there are debates as to whether or not an individual query is quicker than multiple queries and vice versa but I am willing to try anything.

Here are my existing statements:

...

I'm new to Firebird and need your help. I know that Firebird's task isn't to do a nice print.

I have a stored procedure with following reduced output:

Drink Name Cola Marcus Cola Siegfried Fanta Jochen Beer Anna Beer Manuel

I want to add a new row and column before the first value of each group of Drink with the name of the Drink in it.

So the output should be:

Drink Drinks for print Name Cola Cola Cola Marcus Cola Siegfried Fanta Fanta Fanta Jochen Beer Beer Beer Anna Beer Manuel

I am using Firebird 2.5.8

...

I have SQL procedure which should return a bit different result if it is called from one specific procedure. Is it possible for the SQL procedure to detect that it is called from one particular other SQL procedure?

Maybe monitoring mon$... table data can give the answer?

Question applied to Firebird 2.1

E.g. there is mon$call_stack table, but for mostly mon$... tables are empty for Firebird 2.1, they fill up for later versions of Firebird.

...

I have created a reactive function in the server to get a list of elements. The idea is to show each element of the list as a individual choice in the ui, just like selectInput does in the ui.

I wrote an example with mtcars.

...