Playing with Django and Firebird

I’ve been messing around with Django for a while now and having fun. It reminded me of why and how I got started in this field.

[ED:There is an nice firebird mention ]

Using Apache, Webware and Firebird as the database I set out to build something.

Firebird? Yes anything to avoid the MySQL bandwagon. I couldn’t say for sure now, but at the time Firebird was far superior to MySQL. The Firebird team didn’t think that ACID properties, foreign key constraints, stored procedures etc. were just some esoteric optional extras for something with pretensions to being an RDBMS.

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 to server “in right order”, so developer doesn’t need to know, that internally parameters were send unnamed.

1 58 59 60 61 62 84