#pyrit adds support for #sqlalchemy

Pyrit’s storage code was abstracted and refactored which makes it possible to use relational databases like firebird

The benefit: Create a central mysql/pgsql/mssql/oracle/firebird/sqlite-server somewhere on your network and let multiple Pyrit-clients access and work on the central server for good; enjoy the blessings of ACID, partitioning, automatic backup, replication and fine-grained user authentication.

Firebird(Client) with Silverlight

I tried build FirebirdClient in Silverlight environment and I failed. I expected to fail after some attempts with modifications and using only subset of features like i.e for Compact Framework, but this was really fast. Silverlight is only subset of .NET Framework. And one crucial part is not there, it’s System.Data stuff and without it you can drop major part of any ADO.NET provider’s code.

HowTo Show time after execution in isql after a query

Claudio answered to a “new feature” request

This command exists in all Firebird versions:
SQL> set stats on;
SQL> select 1 from rdb$database;

CONSTANT
============
1

Current memory = 10135512
Delta memory = 164708
Max memory = 10263380
Elapsed time= 0.11 sec
Buffers = 2048
Reads = 12
Writes 0
Fetches = 157
SQL>

Elapsed time is the time the query needed to complete. Run it a second time and the elapsed time is only 0.02 seconds because metadata is already loaded.

1 160 161 162 163 164 294