Blog

In this August Embarcadero announces the new version of the well-known Interbase report database: Interbase 2019.

Interbase is widely used by Delphi developers since in the multi-platform environment (iOS, Android, Windows, Mac OSX, Linux) I believe it is the only relational database that can be distributed even on iOS / Android platforms, the inter-base versions for mobile distribution. are IBLite and IBTogo.

This new version compared to the previous one (Interbase 2017) introduces support for new hardware platforms (Android 64Bit and Mac OS 64Bit, first supported exclusively the 32Bit versions for the two environments), but the most important innovation is the introduction of TableSpaces technology (something very consolidated in the Oracle world).

The introduction of TableSpaces offers great advantages in the field of very large databases (being able to divide the tables of a single database into different table spaces on different disks) and at the level of performance (considering being able to read tables different from different disks)

Nearly a year ahead of release forecasts, the Raspberry PI4 is available !!
It seems to be a revolution on the single-board computer, compared to the previous ones it seems to have something extra !!!

Major improvements :

• Dual mini-HDMI interface for dual-monitor up to 4K reslution and 60Hz refresh
• Versions with 1GB to 4GB RAM
• LAN GB Eth vera USB 3.0 Support and so on

With pfSense there are many “package” tools available that facilitate the configuration and maintenance of the system.

These include “Cron” which allows you to change the configuration of the operating system crontab (BSD) via the web interface.

To install a package, just select from the menu “System / Package Manager / Available Package /” write the desired package in the search field and install it, in this case “cron”.

One of the most common applications to schedule is the periodic reboot of the system.

Once “cron” is installed, if we wanted to reboot the system every night, it would be sufficient to create a new cron job via the “service / cron” menu

Click on “+Add” to configure the job ad ex:

where I reboot the firewall to the office every morning at 05.30.

Creating more complex scripts could also make the reboot conditional, for example we could only execute it if we do not get a reply by pinging google.com.

During the conference we talked about:

• The future of Firebird and the new features that will be introduced in version 4.x
• How to optimize firebird performance simply at the SQL level by evaluating its impacts on the execution algorithm.
• Visions on the live-replication system that allows you to create live replicas of your database

Seizing the opportunity we have pututo to visit a really beautiful city (Prague).

mde

dav

dav

SmartFB is a free SQL client for Interbase and Firebird made for internal / educational use.
As we think it will be useful we decided to make it available for download.

It is in “beta” version, but I think it could be useful, so you can download it from the following links:

– Download Windows 32bit Installer
– Download portable version