Lazarus with Zeos components for Firebird tutorial

Tue, 02 Sep 2008 02:59:09 -0700

Here is the tutorial with screenshots in French , but from images you can follow the lazarus wizzards and it should be ok in any language

Firebird is faster than filesystem for blob storage!

Mon, 01 Sep 2008 23:58:40 -0700

To blob or not to blob… good question! I guess if you develop data intensive applications dealing with large files at some point, you’ve thought about it at least once: should I put my data files inside the database or should I write them directly to disk? Ok, so here’s my point: storing files in Firebird is faster [...]

Provider for Entity Framework for Firebird is back and ready for SP1 final

Fri, 29 Aug 2008 15:57:49 -0700

The final version of SP1 for VS2008 and .NET 3.5 is out for a while. And you may noticed, that there were some [more ...]

Fatal lock manager error: semaphores are exhausted

Thu, 28 Aug 2008 18:08:02 -0700

If you get this message in firebird.log Fatal lock manager error: semaphores are exhausted, errno: 1 It means that you sould try to increase semaphores count in firebird.conf.

Creating a Flamerobin/Firebird livecd with Ubuntu Hardy Heron 8.04.1

Thu, 28 Aug 2008 18:08:02 -0700

This is an howto create your own ubuntu live cd with firebird/ubuntu and custom applications ,in guide ubuntu variation used was Xubuntu (is smaller and can be customized easier ) but it works for any hardy release

Lazarus 0.9.26 release preparation

Thu, 28 Aug 2008 18:08:02 -0700

The list of open issues for Lazarus 0.9.26 is getting smaller by the day. Most are fixed. Some are re-targeted to 0.9.28, if we estimate it takes too long fix them now. Some are re-targeted to 1.0.0, if closer inspection turns out the bug is not a regression. Some issue are in the status feedback. [...]

FirebirdConfig 0.1.2.17 released

Wed, 13 Aug 2008 02:11:48 -0700

FirebirdConfig is free and provides you with a friendly user interface in order to configurate the firebird operation modifying the firebird.conf file with the most intuitive and functional graphic form

Store server generated values in Entity Framework in Firebird

Mon, 11 Aug 2008 09:13:35 -0700

Server generated values - not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.

Firebird on Rails encoding accent right

Mon, 11 Aug 2008 08:12:17 -0700

How to use a Rails App with Firebird DB 1.5 encoding: NONE and with accents

Forced-Writes and Firebird database corruption

Sat, 09 Aug 2008 12:10:30 -0700

If there were statistics on corrupted Firebird databases, I believe more than 80% of them would have something in common: they were running with forced-writes off. Since Firebird 2.1 forced-writes also work in linux. With that in mind I put together a comparison between the two modes. What are forced-writes and when to use them? I hope DBAs [...]

Setting up ColdFusion and Firebird

Wed, 30 Jul 2008 07:08:44 -0700

After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.

PostgreSQL - Firebird comparison - updated

Wed, 30 Jul 2008 07:08:44 -0700

Google led me to a comparison sheet about PostgreSQL and Firebird by AMSoftwareDesign, as it looks a bit outdated I decided to add some infos about the latest Firebird release, see it in action

Great Apps Using The CrunchBase API

Sun, 27 Jul 2008 16:48:16 -0700

Since launching the CrunchBase API less than two weeks ago we’ve seen a great response from developers, who have already developed a number of impressive plugins and applications. The CrunchBase API offers access to information from thousands of tech companies, VCs and startup entrepreneurs. It’s free to use, there are no accounts to sign up for and no request throttling. The API returns clean, pretty-printed JSON, and only basic attribution is required. Here are some of great applications already in the wild:

CrunchBase WordPress Plugins

Two plugins sprung up that make it easy to insert the CrunchBase widget into WordPress blog posts. The first, developed by Vaibhav Gadodia, queries the CrunchBase API to determine the CrunchBase URL for a company. Joost de Valk, the author of numerous WordPress plugins, also released a CrunchBase widget plugin that supports all of the CrunchBase entity types (companies, products, people, and financial organizations).

CrunchBase Social Graphs

Finnish readers Mikko Kivelä and Bemmu Sepponen have generated whopper social graphs using the full web of CrunchBase data. One of the graphs maps company connections in CrunchBase, while the other is concerned with the people involved. They also created a fun text file that counts the degrees of separation from any company to Google (TechCrunch is 2 away). We’d love to see a version of They Rule using financial organizations instead of board members.

Semantic CrunchBase

Quite possibly the most exciting use of the CrunchBase API is Semantic CrunchBase, a RDF/SPARQL mirror of CrunchBase that adheres to the principles of the Semantic Web. Semantic CrunchBase comes to us from active Semantic/RDF community developer Benjamin Nowack. A RDF/SPARQL interface enables queries to be run against the CrunchBase data. For example, you can query for all the companies that were funded during January 2008 (which you can already do via a web interface with our advanced search page). Semantic CrunchBase is a great add-on that will open up new doors with respect to the applications people can create with CrunchBase data.

If you are doing something cool with CrunchBase data we’d love to see it. Become a member and post on the CrunchBase Google Group. Follow us on Twitter. Subscribe to the CrunchBase Blog.

Crunch Network: CrunchGear drool over the sexiest new gadgets and hardware.

Another great new feature of Firebird 2.5

Wed, 23 Jul 2008 08:53:20 -0700

Other than CREATE USER something really valuable has been added, the ability to query other databases.

“Firebirdish” connection strings

Wed, 23 Jul 2008 02:53:38 -0700

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

Tue, 22 Jul 2008 07:55:22 -0700

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

Tue, 22 Jul 2008 07:55:21 -0700

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 [...]

Semantic Web takes big step forward " Travelling Through The Wire

Fri, 18 Jul 2008 10:56:57 -0700

Progress on the Entity Framework Provider for Firebird

Mon, 14 Jul 2008 02:53:49 -0700

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

Thu, 10 Jul 2008 22:49:30 -0700

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

Thu, 10 Jul 2008 08:53:43 -0700

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? [...]

Stanford goes with Zimbra over Microsoft and Google

Thu, 10 Jul 2008 08:50:05 -0700

It's that last bit that I particularly love. With Zimbra, no operating system is a second-class citizen. With more and more people switching to the Mac, this is particularly important.

Solaris and the 256 File Descriptor Problem

Wed, 02 Jul 2008 06:49:51 -0700

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 [...]

Firebird has some funny ways of handling passwords

Wed, 25 Jun 2008 03:03:52 -0700

Firebird has some funny ways of handling passwords. The maximum length of passwords that is evaluated is 8 characters. Every character after the 8th is silently ignored. That’s especially funny because the ‘default’ password for a Firebird-installation is ‘masterkey’, which has 9 characters. You can, however, successfully log in to freshly installed Firebird-servers providing the [...]

Don’t silently turn your outer joins into inner joins

Tue, 24 Jun 2008 00:01:21 -0700

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 …

Tue, 24 Jun 2008 00:01:21 -0700

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

Sun, 22 Jun 2008 07:00:04 -0700

A very useful Firebird driver for performing most CRUD database operations in PHP.

GridFox - enklere Grid-basert layout med Firefox plugin

Sun, 15 Jun 2008 22:18:07 -0700

GridFox er en plugin til Firefox som lar deg kontrollere om nettsiden din følger grid-et du har satt opp.

Firebird do you hear the cries of your PHP users?

Sun, 15 Jun 2008 04:17:49 -0700

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”

Sat, 14 Jun 2008 02:18:01 -0700

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. [...]

blogroll on SWiK

Lazarus with Zeos components for Firebird tutorial

Firebird is faster than filesystem for blob storage!

Provider for Entity Framework for Firebird is back and ready for SP1 final

Fatal lock manager error: semaphores are exhausted

Creating a Flamerobin/Firebird livecd with Ubuntu Hardy Heron 8.04.1

Lazarus 0.9.26 release preparation

FirebirdConfig 0.1.2.17 released

Store server generated values in Entity Framework in Firebird

Firebird on Rails encoding accent right

Forced-Writes and Firebird database corruption

Setting up ColdFusion and Firebird

PostgreSQL - Firebird comparison - updated

Great Apps Using The CrunchBase API

Another great new feature of Firebird 2.5

“Firebirdish” connection strings

Firebird SuperClassic - Another option

Recommended update - Firebird 2.1.1

Semantic Web takes big step forward " Travelling Through The Wire

Progress on the Entity Framework Provider for Firebird

Apache Serves Images Slowly - Testing with Firebird

Cooking code with the right ingredients

Stanford goes with Zimbra over Microsoft and Google

Solaris and the 256 File Descriptor Problem

Firebird has some funny ways of handling passwords

Don’t silently turn your outer joins into inner joins

The neglected driver …

PHP Firebird driver á la ActiveRecord

GridFox - enklere Grid-basert layout med Firefox plugin

Firebird do you hear the cries of your PHP users?

Jim Starkey: “Well, here we go again”