Posted by Martijn Tonies on 30 Dec 2011 6:47 am. Filed under Tools & Products releases
The December Discount promotion is nearly finished, there are just a few days left to get a 40% discount on all products from Upscene Productions.
We offer tools for:
- Microsoft SQL Server
- Sybase SQL Anywhere
- Advantage Database Server
These tools include the multi DBMS development IDE “Database Workbench Pro”, also available in FREE Lite Editions for Firebird, InterBase and MySQL.
Auditing tools for InterBase, Firebird, Microsoft SQL Server, NexusDB and Advantage Database Server.
Our “Fb TraceManager” tool makes using the Firebird Trace API easy and allows continues monitoring of your Firebird server.
During development, you can use the “Advanced Data Generator” to create test data for your application, creating decent volumes of data for proper testing.
Get these tools now, with a 40% discount!
Posted by mariuz on 28 Dec 2011 11:17 am. Filed under General news
Ricardo Obregón published the php pdo driver in Arch Linux Repository
Posted by mariuz on 27 Dec 2011 8:15 am. Filed under General news
If you have read the previous article about Firebird pdo status then you might now that almost all worked except binding parameters by name (see bug #48877).
But as a gift bug #48877 is fixed in svn , and is already in the php snapshots for 5.4.x,5.3.x and trunk 5.5.x
So it should all work from the mentioned article , There are still some bugs left but it will be fixed until the end of the year : Bugs #47415 and #53280 are already done from my todo list
Posted by darefiev on 25 Dec 2011 6:58 am. Filed under Developer News
, Tools & Products releases
||DA-SOFT Technologies announces the availability of AnyDAC for Delphi Winter 2012 release v 220.127.116.113 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.
AnyDAC for Delphi can be immediately downloaded from the download page.
What is new in v5.0.5 and what is AnyDAC ?
AnyDAC v 5.0.5 Highlights
- major TADTable and Live Data Window mode optimization;
- Firebird v 3 support (packaged procedures, PSQL functions, identity columns, BOOLEAN data type);
- Firebird COMPUTED BY support;
- PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
- Interbase v 6, 7 support;
- Advantage v 8, 9 support;
- SQL Anywhere v 12 support;
- SQLite v 3.7.9 support;
- ElevateDB ODBC support;
- ReportBuilder DADE;
- Multiple enahncements to the help system.
AnyDAC for Delphi
AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check:
AnyDAC Core Features
- Native access to Firebird, MySQL, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
- Generic access to any database supported through dbExpress or ODBC data sources.
- Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
- Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
- Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
- First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
- Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
- Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
- Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.
AnyDAC Natively Supported Databases
- Enterprise – Oracle, SQL Server, IBM DB2, Informix.
- Workgroup – Firebird, Interbase, MySQL, PostgreSQL, SQL Anywhere, Advantage DB.
- Database in clouds – Microsoft SQL Azure.
- Desktop – SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
- Embedded – SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
- Bridges – dbExpress, ODBC.
With best regards,
DA-SOFT Technologies Team
« Hide it
Posted by Cantu on 23 Dec 2011 11:19 am. Filed under General news
, Technical Articles
, Worth Reading
The parameter TcpRemoteBufferSize found in firebird.conf is supposed to set the maximum size of a packet being transfered. The default value for Firebird is 8K, and the maximum accepted is 32767. Theoretically, bigger packets should make the transfer of large resultsets faster (mostly noticed when connection is high latency networks, aka internet).
Recently, I did some tests with this parameter, but wasn’t able to find any differences in the time of a fetchall with a select first 2000 * from some_table_with_no_blobs_and_lots_of_records. A similar test that I did last year, with different FB version and O.S. showed a speed increase of almost 3x in the fetchall time when the packet size was set to 32K, but seems that I cannot reproduce this with my current environment anymore.
If you have some time, please do some tests with this parameter, and publish the results in the comments of this post. Remember to test changing the value at client, at server, and at both, and to mention what Firebird version was used (at server, and client library too, if different). Also, I recommend to run the first select/fetchall at last one time before getting the results, to fill Firebird and O.S. cache and get more accurate results.
If you are a “hardcore” user, you may also want to install Wireshark and have an inside view of the communication process.
Posted by mariuz on 22 Dec 2011 6:27 am. Filed under General news
Pavel Cisar announced on Python Firebird list
I forgot to mention that you can use our JIRA tracker:
to submit bug reports and feature requests for FDB.
And you can check already the TODO list of fixes for the next release
Posted by mariuz on 22 Dec 2011 5:09 am. Filed under General news
wrote on google plus about the new PowerConsole:
i.e. I’ve just imported fdb
as kdb and skipped the kinterbasdb initialization. Surprise, surprise,
it works! All issues I was able to find so far were few small bugs in
pwcfb module itself
So, I released an update to pwcfb that should fix all issues and sets the dependency to FDB.
To install it simply use `easy_install pwcfb` and it should bootstrap it with all necessary dependencies.
Extensive package that enables PowerConsole to work with Firebird databases.
Posted by mariuz on 21 Dec 2011 10:56 am. Filed under General news
, Tools & Products releases
As promised, FDB initial release (0.7.0) is out: http://pypi.python.org/pypi/fdb/0.7.0
It’s almost feature-complete (ready for 95% of users), but it could be
still buggy (it’s beta!), and the code wasn’t optimized for size and
speed. In all other ways it’s ready for wide testing.
- Distributed transactions
- ARRAY support
- EVENTs support
- Stream BLOBs
- TRACE service
- Documentation (but you can use KInterbasDB one as FDB is as close to
it as possible).
- Python 3.x support (haven’t had time to test it, but it shouldn’t be
hard to make it work there)
What’s new since my last post here:
- Support for stored procedures (proper one according to Python DB API,
behaviour is the same as in KInterbasDB)
- Prepared Statements. It works in exactly the same way as in
KInterbasDB, i.e. you can use explicit PS via cursor.prep(), or use the
internal PS cached for all statements executed via cursor.execute() – it
will detect previously executed command and re-use prepared statement
(cached per cursor instance!).
- Fully implemented cursor.description attribute, i.e. including
precision for DECIMAL/NUMERIC fields. Should now return the same results
- trans_info/transaction_info and db_info/database_info calls like in
- Better object dependency and lifetime management, so Python memory GC
should be much happier now. I modelled it as much as KDB does it as
Source code is also in Firebird Project’s Subversion repository:
(KInterbasDB source moved)
Sorry for GIT/Mercurial etc. fans, but Firebird project uses only SVN
for all its code (except old obsolete ones that are still in CVS) and it
would be pointless to create another type of repository for such a small
project. However, you’re free to set up mirrors or local repositories on
GIT or whatever
Merry Christmas to all
[ED: if you want to know how easy is to use , or how compatible it is related to kinterbasdb , read this post ]
Posted by Jiri Cincura on 19 Dec 2011 6:30 am. Filed under Blogroll
, Developer News
, Tools & Products releases
I’m happy to bring you early Christmas gift packed as ADO.NET provider for Firebird version 2.7. More info…
Posted by Paul on 19 Dec 2011 3:12 am. Filed under Tools & Products releases
SQLLY Development team is proud to announce the next major version of Firebird Development Studio.
As usual you will get simple and clear user interface equipped with unique features like SQL code refactoring, intelligent code completion and real-time errors highlighting. Database Comparer, SQL debugger, Code Formatter and ER Diagrams designer are also at your service.
Please visit http://www.sqlly.com for more information. Do not miss our special christmas offer!
Next Page »