Generate Custom Insert SQL statements from a csv file
Question of the day : I need to import a csv file into Firebird and I’ve spent a couple of hours trying out some tools and none fit my needs.
Question of the day : I need to import a csv file into Firebird and I’ve spent a couple of hours trying out some tools and none fit my needs.
Under Fedora and derivative (including Centos and RHEL) :
yum install php-interbase
under Mageia and Mandriva
urpmi php-pdo_firebird
that’s all
see :
http://sophie.zarb.org/search?search=pdo_firebird.so&distribution=&type=byfile&d\
eptype=P
Here is the guide updated to current ubuntu releases also one thing to notice is php pdo is now core module and should not be installed from pecl repository
This fix corrects the error caused when reading an ftMemo field twice using the Firebird dbExpress driver.
Interesting issues and fixes with odbc and openoffice (usually you can use jdbc but that is another path to use firebird from OpenOffice/LibreOffice):
My name is Ocke Janssen, I’m the project lead of the dba.openoffice.org
project and I got a problem 😉
While trying to fetch bookmarks I crash inside the newest ODBC version
of Firebird.
DA-SOFT Technologies announces the availability of AnyDAC for Delphi Spring 2011 release v 4.0.7.1719 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, 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 v4.0.7 and what is AnyDAC ?
SQL Maestro Group is pleased to announce the release of Firebird Maestro v. 11.2, a powerful Windows GUI solution for Firebird administration and database development. |
New version features support for a lot of Firebird 2.5 and Firebird 2.1 new features, tools to generate CRUD stored procedures and updatable views, enhanced Dependency Tracker, and other useful things. Read full press-release.
You get an approximate value by running gstat and then check out the
Data pages value for the table. Multiply that value with your database page size. This is the allocated space on disk.
From Milan Babuskov blog:
I decided to automate conversion of MySQL database to Firebird. I got tired of manual find&replace process, and created a small parser that changes from MySQL to Firebird syntax. Currently it only supports database structure dump (no data, only structure) from PHPMyAdmin. Not all datatypes are supported, but feel free to “fix” it. It’s written in PHP and it’s open source. It would be great if you would send back any modifications you make. Download it here (source code included).
In this tutorial I will show you how to install multiple separate Firebird 2.1 servers on a single Host