Author: mariuz

http://wiki.ubuntu.com/Mariuz

Timeout records – Feature request

Leave a comment

For several years now, I’m yearning for a feature that I think that all SQL based databases that I know are missing, and throw it back to the program side.

The feature I wish to have is a way to set a specific record to be valid for only a known period of time, and when the time is up, I’ll be able to do something.

In this post I’ll try to create some sort of general specification for such feature, and I hope that there will be many comments on this that will benefit everyone, and I hopeful, that they will make the idea better.

Firebird: choosing an owner for database deployment

Leave a comment

Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.

It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer’s computer.

Read the rest on Accounting++ blog

New IBExpert Version 2012.02.21 available

Leave a comment

News from ibexpert page
New Data import, Extract metadata and Search metadata features, new IBEBlock functions, and more

New features include:

  1. Data import: now you can convert Boolean values to smallint values when importing data into a new table. You can also now automatically generate simple column names for the target table.
  2. To-Do list: now you can duplicate To-Do items.
  3. Extract metadata: New Always include COLLATE option.
  4. Search metadata: New Do not search in comments option.
  5. New IBEBlock functions and features.
  6. Many small bug fixes and minor improvements.

Since version 2011.12.01 IBExpert now uses the Firebird database and Firebird Embedded 2.5 to store all IBExpert data (registered databases, query histories etc.) by default. In previous versions by default IBExpert stored this data in the IBExpert.stg file and the user was able to change this manually in Options / Environment Options / User Database. Working with IBExpert.stg is still possible (for example, if you disable the User Database manually), but you will get a warning every time you start IBExpert, and we will not support this method in the future.

  • The Customer version (setup_customer.exe) can be downloaded here (for customers with valid license keys). You can also download the customer version in theIBExpert KG Download Center. If you can not see it there, you might have used a different e-mail in the customer registration process or your account has already expired.
  • The Trial version (setup_trial.exe) can be downloaded here (45 day test version) or from the IBExpert KG Download Center.
  • The free Personal version (setup_personal.exe) can be downloaded here (version with limited features free of charge).

We are currently preparing to release Firebird 2.0.7

Leave a comment

From Paul Beach’s Blog:
We are currently preparing to release Firebird 2.0.7, since I take responsinility for the Mac builds, I did a 2.0.7 build on MacOSX 10.7 using the development tools installed by XCode 4.1 (gcc 4.2.1 etc). I set up the relevant environment variables for this older 32bit only build CFLAGS, CXXFLAGS, LD_FLAGS and also set the MACOSX_DEPLOYMENT_TARGET=10.4. The builds completed without any problems, some simple tests on MacOSX 10.7 showed no problems.

Now – Imagine my surprise when Philippe told me that when he tried to QA the builds on MacOSX 10.5 we got this error on SuperServer startup.

Kitto – A framework for creating data-driven web applications with Delphi and ExtJS

Leave a comment

Kitto allows to create Rich Internet Applications based on a data model that can be mapped onto any database. The client-side part uses ExtJS (through the ExtPascal library) to create a fully AJAX application, allowing you to build standard and advanced data-manipulating forms in a fraction of the time.

Kitto is aimed at Delphi developers that need to create web application without delving into the intricacies of HTML, CSS, Javascript or learning to use a particular library such as ExtJS, yet it allows access to the bare metal if required.

Kitto includes a database-agnostic data-access layer, allowing to create applications that work on any database engine and port applications between database engines.

A Kitto application is described in a set of easily maintained YAML files, keeping definitions abstract and declarative and allowing for future extensions. Business rules are enforced either declaratively or through small javascript fragments on the client, or in Delphi code on the server.

Kitto was designed by Nando Dessena and its development is sponsored by Ethea, which uses Kitto for internal development projects and client work and provides Kitto-related tools, support and development services.

Start here for further information.

The getting started guide can be tested with Firebird and Delphi

 

The Document Foundation Announces LibreOffice 3.5: The Best Free and Libre Office Suite Ever

Leave a comment

The Document Foundation announces LibreOffice 3.5, the third major release of “the best free office suite ever”, which shows to end users the improvements derived from the development strategy adopted since September 2010.

LibreOffice 3.5 derives from the combined effort of full time hackers – the largest group of experienced OOo code developers –and volunteer hackers, coordinated by the Engineering Steering Committee.
Related to Firebird there is the ODBC linux 64 bug killed .
Also the db with no bool support (Firebird 2.5) issue is done

Firebird Embedded and LibreOffice is the killer combination to scale from a single file application to a client/server approach

Leave a comment

Quote of the day is via this thread on Firebird Java Group :

It would be good if Jaybird 2.3 could be used with embedded and
LibreOffice because the feature set in Firebird is obviously much, much greater
than HSQL or the proposed SQLite replacement.

The ability to create a zeroconf, transportable data file is of interest to me
(along with using iReport to generate printouts from that file).

OT: Personally I think that Jaybird / Firebird / Firebird embedded is the way to
go for LibreOffice instead of the very limited SQLite. The ability to upscale
from a single file application to a client/server one is a killer.

Update:Firebird Driver and Embedded version merged into LibreOffice git master

1 … 110 111 112 113 114 … 294