Firebird News

DATE Handling Functions – updated in wiki.firebirdsql.org

February 18, 2009 mariuz Leave a comment

Cut and paste date functions. See Ivan Prenosil’s site for some more deatil and additional useful functions.

(No Ratings Yet)

FLAP ( Firebird+Linux+Apache+PHPerl) is rather an operating platform than an application.

February 18, 2009 mariuz Leave a comment

Linux can be of any common Linux distributions, but I prefer CentOS 5, and Firebird RDBMS is FirebirdSS 2.1.1 for Linux.

Since there are too many applications, really too many, to run on FLAP, it is impossible to list them all, or even impossible to list most of
them here, I just list the most commonly used FLAP applications here. If you are running any other FLAP applications, it would be a great
honour for me if I could have them listed/linked here.

(No Ratings Yet)

Firebird Development Studio has been updated

February 18, 2009 Paul Leave a comment

New version of popular IDE for Firebird “InterBase/Firebird Development Studio” is available. More information can be found on the web site: www.sqlly.com

(No Ratings Yet)

New IBProvider allows comprehensive work in Unicode applications, enhanced work with NONE encoding, and supports charset markers.

February 17, 2009 Andrew Merkulov Leave a comment

New IBProvider v.3.0.0.6600 RC3

All the detected problems that prevented comprehensive work with Firebird and Interbase from UNICODE applications have been eliminated.
Supports charset markers in SQL queries.
Supports exclusions processing when working with Interbase and Firebird via ADODB.
Supports working with database object names containing national symbols for connections with NONE charset.
Enhanced work with metadata schemes when working with database via NONE charset.
Advanced testing allowed detection and elimination of errors.
ISO8859_15 charset support.

Please read details on the Firebird driver homepage.

(No Ratings Yet)

Firebird 2.0.5 is added to Debian Experimental

February 14, 2009 mariuz Leave a comment

So now if you use debian unstable and experimental this way Now you can test and use firebird 2.0.5 packages

We missed the Lenny release party but who knows maybe we release 2.5 until the next Debian release

Happy Valentine and Good Unix Timestamps

(No Ratings Yet)

Two simple Python scripts showing how to connect to Firebird using wxPython.

February 14, 2009 mariuz Leave a comment

Below are two simple Python scripts (not involving dabo) just showing how to connect to Firebird and do a simple task using wxPython.

http://dabodev.com/wiki/Firebird

(1) The first script lets the user go into the File menu and select a Firebird database, and then it displays (do-nothing) buttons in a wxPython Sizer object down the left side of the window, one for each table (and view) in the database.

(2) The second script is hard-coded to open a particular Firebird database and display a particular table in a grid. (Before running, you will need to go into this script and change the hard-coded sections so they are appropriate for your system. You’ll need to change the host and database parameters and the SQL statement – and maybe also the user and password parameters. Look for the lines preceded by a comment starting with ###.)

(No Ratings Yet)

stackoverflow.com – site of the day with firebird questions/answers

February 14, 2009 mariuz Leave a comment

Very well done site with good firebird questions / answers also flamerobin is mentioned several times. You can watch or respond to many of them

(No Ratings Yet)

People Around Firebird – John W Higgins

February 14, 2009 mariuz Leave a comment

I spotted his interesting projects or forks on github
ED:i saw that you forked fb ruby library could you tell me a few notes on how you use it in sequel orm i want to add an post on firebirdnews.org if you want so also an small intro would be nice

wishdev said :

I basically just wrote an adapter for Sequel which uses the Fb driver to work with Firebird. The fork was necessary mostly to fix an issue with using the RETURNING clause to get back sequence generated primary keys.

As for any intro with respect to myself – I’m the type that keeps his head down in the gopher hole for the most part. I didn’t do a huge amount of work because the Sequel ORM is so well written it was easy to build a Firebird driver.

If you need/want any more info please feel free to ask 🙂

John W Higgins

(No Ratings Yet)

People Around Firebird – Daniel Albuschat

February 14, 2009 mariuz 3 comments

Today i have discovered this little gem on github , It’s an Asynchronous database-access for Qt and Firebird

So in this post i open an series of interviews or introductions with people around firebird

[See remaining text…]

Hi Marius,

Firebirdnews.org is a great site! Added it to my RSS feeds, but I
wonder why I haven’t heard of it before. You need to do more
advertising! 🙂 Do you happen to know how many readers you are
reaching?

ED:Maybe we should promote better the website , seems that now from alexa.com

stats we have a lot of hits from Italy, so we have to tune up to reach more markets 🙂

I’m glad that you included my translation of the Firebird Security
documentation, too, but I was a bit surprised to find it there without
being notified of it.

Regarding the TsSqlDatabase stuff: It’s something I’m doing for the
company I’m working at (Germany based Treesoft, see www.treesoft.de)
and it’s currently being extended by another employee. Which problems
I wanted to solve and the basic technique that I’m using to solve it
are described here:
http://daniel-albuschat.blogspot.com/2007/11/high-performance-high-usability-sql.html

The project is currently in a semi-working state. My co-worker is
working with Qt to create a searchable list-view that can handle HUGE
amounts of data with astounding user experience and without the quirks
that most SQL list implementations have.
I’m going to write up a new article on this topic with more details
maybe this weekend or next week, so stay tuned. I’ll contact you when
it is finished so you can put it up on firebirdnews.org.

This blog-post may also be an interesting read to you:
http://daniel-albuschat.blogspot.com/2007/10/clean-sql-server-client-api.html

ED:also i love arora and i started to like qt , I’m not an c++ lover
but with qt I started to like it

C++ is just one of the most cleanest languages that are around
(although it has many quirks and is not what I would really call
“clean”, but it’s still “one of the cleanest”). It’s the only language
that solved the resource allocation/deallocation problem in the best
possible manner. See RAII vs. Garbage collection here:
http://daniel-albuschat.blogspot.com/2007/11/raii-as-alternative-to-garbage.html

On an unrelated side note, have you ever used Sinática Monitor
yourself? It sounds like a cool product, but I’m wondering how it
works. I have a similar project in mind that would work as a
Firebird-“Proxy” and sniff the communication between the client
application and Firebird. But Sinática even has info on server and I/O
loads, that really cool.

ED: I will try it on my ubuntu box if possible with wine

Thanks for your mail,

Daniel Albuschat

« Hide it

(No Ratings Yet)

German translation of Firebird security article

February 13, 2009 mariuz Leave a comment

There’s an article on the Firebird Documentation web-page about Firebird File and Metadata Security. Since this is an interesting topic to our customers, I took the time to translate it to German.

The article describes the fundamental problems in securing network connections. One of the biggest problem is key management. Since the Firebird server is usually controlled by and installed at the client’s site, you don’t have any control over it. So, theoretically, someone could always build his own Firebird server to spy on the password. But that’s only one of the problems discussed.

Many thanks to Geoff Worboys, the author of the original article, and Paul Vinkenoog for publishing it on the official web-site.

(No Ratings Yet)

« 1 … 303 304 305 306 307 … 491 »