sorted by: recent | see :
popular
Content Tagged with Firebird + blogroll
Another great new feature of Firebird 2.5
Other than CREATE USER something really valuable has been added, the ability to query other databases.
“Firebirdish” connection strings
Did you know, that you can use in Firebird .NET Data Provider more “firebirdish” connection strings?
Read more on “Firebirdish” connection strings.
Firebird SuperClassic - Another option
Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.
Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.
Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for [...]
Recommended update - Firebird 2.1.1
The recent release of Firebird version 2.1.1 is very welcome.
Here are a few of the fixes I consider important for 2.1 production servers and so recommend the update:
Stability fixes for the monitoring tables
Fixed possible corruption of the users database, security2.fdb.
Fixed nBackup, which did not work in version 2.1.
Fixed a memory leak on DDL statements.
The complete [...]
Progress on the Entity Framework Provider for Firebird
Today, after some days/weeks, I finally created some noticable (= not only internals) progress with Entity Framework provider for Firebird.
Now, the provider is able to use, map, call, … stored procedures (and functions [very experimental]). You can select stored procedures from database, map these to some operations in EF, create “function imports” etc. You can [...]
Apache Serves Images Slowly - Testing with Firebird
The application was a test-bed app that uses the FireBird SQL database to handle sessions and dynamic data, all on the same machine. [Performance Tip :Seems that you need to put KeepAlive Off on apache to server many images and too many clients :If you have more clients than available apache children, KeepAlive settings will [...]
Cooking code with the right ingredients
My previous post caused some very interesting discussions on the decisions that I am facing when starting on a new project. The suggestions were as varied as the choices in front of me. It seems that any of the alternatives can do the job, so why don’t I just make a decision and move on? [...]
Solaris and the 256 File Descriptor Problem
Some of you reading this may remember that back when InterBase 6.0 was released on Solaris we ran into a fundamental problem on Solaris. It seems that since 1992 there has been an open bug documenting Solaris’ file descriptor problem: “32-bit stdio routines should support file descriptors >255.”
When this issue was discovered, we chose to [...]
Don’t silently turn your outer joins into inner joins
Surprised by outer joins not returning the expected results? Looks like they behave like an inner join?
You are probably messing with the join and the where clause
The neglected driver …
Looks like the Firebird team is going to put some effort on the ODBC driver, which has been lying there abandoned for a few years (last activity report is of 2006) despite it’s usefulness in windows desktop apps (at least for me ;))
PHP Firebird driver á la ActiveRecord
A very useful Firebird driver for performing most CRUD database operations in PHP.
Firebird do you hear the cries of your PHP users?
Do they exist? Do they make you money (or in the case of Firebird meaningfully extend your community)? Would you be unhappy if support would be dropped in PHP 5.3, in PHP 6.0? Do you have ressources to prevent this from happening, by taking ownership of the code in question?
http://pooteeweet.org/blog/0/1176
Jim Starkey: “Well, here we go again”
For those of you who didn’t hear, today is my last day at MySQL, and
Monday will be my first day as Chief cook, CEO, and bottle washer of
NimbusDB, Inc., a software start up so young it doesn’t exist yet.
Nimbus, as the name hopefully suggests, is a relational / semantic
database system designed to run on clouds. [...]
Firebird with Real Basic
If you try to connect with Real Basic here is the How To
Ruby on Rails, Django or TurboGears?
I have a decent desktop accounting type application written in Delphi against a Firebird database that should have a piece exposed on the web. Maybe, in time, there should even be a web based version of the entire program on the web.
FB 2.1 Week of Year Feature
With new functions in FB 2.1 extracting week of year is supported (based on ISO-8601). So this past article is more simple to do with the new syntax :
extract(week from some_date_field)
Advangage/Disadvantage about embedded database engines
I want to implement software which needs a embedded database engine. I search this forum so many times. The language I must use C++. Then I have two methods to choice
LAMP SCHMAMP
PLEASE let the LAMP acronym die already! There are so many alternatives in Free Software land.
L: Linux, FreeBSD, OpenBSD, NetBSD, OpenSolaris, several more.
A: Apache, Nginx, Lighttpd, dozens more.
M: MySQL, PostgreSQL, FirebirdSQL, SQLite, and more…
P: PHP, Ruby, Python, Perl, Groovy, Scala, Tcl, Smalltalk, Lisp, the list can go on forever.
original post was on lwn.net
Firebird - unique index vs. unique constraint
From time to time I got a question about the difference between unique key and unique constraint.
Editline, Curses and Solaris AMD64
We finally solved the last major problem in the Firebird 2.0x build for Solaris 10 AMD 64bit. Whenever we tried to include editline in the build isql_static would coredump. We tracked the problem down
The fastest way to insert 100K records
I’m doing some performance tests today with our three different database backends: MySql, Firebird and SQL Server.
Python backup script for firebird
Here is an cron backup script written in python
connecting with oOo 2.4 to firebird
here are the screenshots and connection string used for openoffice.org 2.4
xampp and firebird
How to enable firebird support in xampp
http://www.llodra.es/archives/93
Exceptions, gcc and Solaris 10 AMD 64bit
Blog post by Paul Beach.For a little while now Alex and I have been battling a problem on Solaris 10 64bit AMD. We have been trying to port Firebird 2.0x to 64bit Solaris. However after fixing a few issues, e.g. defining the platform etc, we found that isql_static would core dump on trying to create [...]
Comparing databases firebird vs postgresql
A review for an old article
Beware of Firebird 2.0 Debian package and UDF
when you upgrade in debian from firebird 1.5.x to 2.0.x beware of some UDF issues
LIMIT in SELECT statements in Firebird
The question is, is there a MySQL/PostgreSQL equivalent of LIMIT clause in Firebird?
2007 LinuxQuestions.org Members Choice Awards
you can see the final vote results , this year there was some good pr campaign from postgres and we didn’t voted so much like in previous years
but we took an honorable 3rd place
http://www.linuxquestions.org/questions/2007-linuxquestions.org-members-choice-awards-79/database-of-the-year-610185/
It’s weird that sqlite is not on the first row it’s used in firefox/google gears … and disabled in php.ini [...]
Embedded Firebird, error trying to write to file
This error has been really annoying me tonight!
I have an app that uses Embedded Firebird for its DB so that I don’t need to
install a DB server. On Vista my app throws an exception “Error trying to
write to file (the correct path here)”.
Python, kinterbasdb and 64bit MacOSX 10.5
Now we have 64bit builds of Firebird 2.1 for MacOSX 10.5, we have issues trying to test them properly using the Firebird QMTest QA suite. This QA suite relies on Python and kinterbasdb. Currently Philippe Makowski has been able to run the tests from a 64bit Linux client. But is unable to run the tests [...]
Firebird .NET provider and calling sp with parameters
Firebird .NET provider has ability to create parameterized queries. Both named and unnamed parameters are supported. Everything works as you expect with select, insert, delete or update commands. The tricky part comes with stored procedures. Unlike MS SQL, that has direct support for named parameters, in provider, we’re parsing parameter names and we’re sending it [...]
Exporting from firebird
A how-to style article about FBExport (in spanish).
pdo2 in php - Who needs it?
Following the discussion around PDO2 and CLAs in the PHP world, I read this email (from Derick) today:
Why not just do the “right thing” ™:
[See remaining text…]
- Have PDO2 in core, including all the drivers [...]
Firebird installation, easy way?
What would be the easiest way to redistribute FireBird server?
lazarus+macosx+firebird blog of the day
Here are some steps needed for developing on that platform
Page 1 | Next >>