Profile

Cover photo
566 followers|63,457 views
AboutPostsPhotosVideos

Stream

Firebird

Shared publicly  - 
 
Quote from firebird groups memory lane :

"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K. + Helen)

#Firebird   #SQL   #opensource  
1
Add a comment...

Firebird

Shared publicly  - 
 
Jaybird 2.2.5-SNAPSHOT available for testing 

Mark Rotteveel : wrote on Firebird-java group:
I just published a snapshot of Jaybird 2.2.5 for testing.
Notable changes in this version:
* Fixed: getCrossReference broken by changes of JDBC-331 (JDBC-335)

* Added: basic support for Java 8 java.time in 
PreparedStatement.setObject() and ResultSet.updateObject() (JDBC-339)
As part of this change the supported sub-second precision for 
java.sql.Timestamp has been increased from 1 millisecond to the maximum 
Firebird precision of 100 microseconds (or 0.1 millisecond).

* Fixed: Deadlocks and other thread safety issues with classes in 
org.firebirdsql.pool (JDBC-341)

I'd appreciate it if people are willing to test the changes of JDBC-341 
(with org.firebirdsql.pool.FBWrappingDataSource) as I have made some 
serious changes to that class and underlying connection pool classes to 
fix a number of concurrency issues.

Download from sourceforge at:
https://sourceforge.net/projects/firebird/files/firebird-jca-jdbc-driver/2.2.5-SNAPSHOT/

And on Maven from the Sonatype Snapshot respository:
https://oss.sonatype.org/content/repositories/snapshots/

groupId: org.firebirdsql.jdbc
artifactId: jaybird-jdkxx (where xx is Java version: 15, 16, 17 or 18)
version: 2.2.5-SNAPSHOT

I plan to release the final version of Jaybird 2.2.5 within two weeks.


https://groups.yahoo.com/neo/groups/Firebird-Java/conversations/messages/11031

#Firebird   #Java   #JDBC #SQL
2
Add a comment...

Firebird

Shared publicly  - 
 
#Firebird #SQL   2.5.2 updated in #Ubuntu ppa includes icu fix from #Debian

http://www.firebirdnews.org/?p=9201

ps:
The icu loading issue is fixed in Ubuntu Trusty Tahr 14.04 Firebird 2.5 package
1
Add a comment...

Firebird

Shared publicly  - 
 
Firebird and Unicode databases

The first encounter with unicode databases and collations on Firebird may be confusing, as it was for me and it may take some time to grasp the concepts and settings. This article describes the principles and catches and gives the examples how to set up a #UTF-8 database in #Firebird #SQL server 2.5, how to setup #ICU libraries and how to use national collations (eg. #czech).



http://rovanicek.blogspot.ro/2012/02/firebird-and-unicode-databases.html
The first encounter with unicode databases and collations on Firebird may be confusing, as it was for me and it may take some time to grasp the concepts and settings. This article describes the principles and catches and give...
1
Add a comment...

Firebird

Shared publicly  - 
 
Сhecking Firebird source code errors using PVS-Studio

Here you can find result of checking Firebird with PVS-Studio (in russian).
http://habrahabr.ru/company/pvs-studio/blog/213423/

via linkedin firebird group

ps:PVS-Studio is a static analyzer that detects errors in source code of C/C++/C++11 applications

#Firebird  #C++
2
Add a comment...
In their circles
305 people
Have them in circles
566 people
Arda Tunccekic's profile photo
Jiří Novotňák's profile photo
Ivan Zuniga Perez's profile photo

View all

Firebird

Shared publicly  - 
 
Firebird license explained and what it grants you 

The Firebird license is explained quite well in easy terms in the Getting started guide http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg25-firebird-licenses.html

And IDPL 1.0 is derived from MPL 1.1 with a few changes 

MPL 1.1 is quite well explained in this article on what rights it grants you 
http://oss-watch.ac.uk/resources/mpl#main-features-of-the-mpl
and the initial annotated MPL1.1 is quite nice to read (also the faq)

http://www.mozilla.org/MPL/1.1/annotated/

http://www.mozilla.org/MPL/1.1/FAQ.html
5
1
PRESTIŻ PC's profile photo
Add a comment...

Firebird

Shared publicly  - 
 
#Spanish blog about #Firebird #SQL   after one year exceeded 116,000 visits

Author tells his story  on the blog first birthday:

When I launched, one year ago I did not knew if it would be read, if anyone is interested in what I had planned to write, but I thought it needed a blog in Castilian language to help us learn more about Firebird, because it is an engine very good data bases and documentation was missing in our language.

My expectations were not so high , I thought hopefully in a year could reach 10,000 visits and would consider myself very lucky and if reached 20,000 visits. Well, at this time and exceeded 116,000 visits so I am more than happy with the good reception that we have It’s really a very pleasant surprise.

http://firebird21.wordpress.com/2014/03/02/cumpleanos-del-blog/
3
1
Fredy Caballero's profile photo
Add a comment...

Firebird

Shared publicly  - 
 
Firebird: Changing the database collation 


Recently I have faced a challenge. I had a big database (about 3GB of data, hundreds of tables) and I needed to change the collation for all the CHAR and VARCHAR columns. How to do it it? Is there an easy way?

Preface:

The database was created with charset WIN1250 and collation either WIN1250 or PXW_CSY (czech sorting, case-sensitive). I needed to change it to WIN_CZ (czech sorting, case-insensitive).


http://rovanicek.blogspot.ro/2013/11/firebird-changing-database-collation-i.html

#Firebird   #SQL   #WIN1250   #WIN_CZ  
Recently I have faced a challenge. I had a big database (about 3GB of data, hundreds of tables) and I needed to change the collation for all the CHAR and VARCHAR columns. How to do it it? Is there an easy way? Preface: The da...
2
Roberto Carlos Silva's profile photo
 
you can create a new database with the charset and collate appropriate, preferably only tables without indexes, after you create the database you can use the DataPump tool to migrate data available at http://www.clevercomponents.com/ downloads / index.asp, after this you can use the Database Comparer tool, also available on this site, to recreate the structure of the indexes.
Add a comment...
People
In their circles
305 people
Have them in circles
566 people
Arda Tunccekic's profile photo
Jiří Novotňák's profile photo
Ivan Zuniga Perez's profile photo
Communities
Created by Firebird
View all
Firebird's profile photo
408 members
Story
Tagline
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms.
Introduction

Introduction

If you are reading this paper, this is probably your first encounter with the Firebird RDBMS. This paper will present to you the main features of the Firebird database. At the end, I am sure you will be anxious to download its lightweight installer and try it out yourself.

History

Firebird is derived from Borland InterBase 6.0 source code. It isopen source and has no dual license. Whether you need it for commercial or open source applications, it is totally FREE!

Firebird technology has been in use for 20 years, which makes it a very mature and stable product.

Major Features

Don’t be fooled by the installer size! Firebird is a fully featured and powerful RDBMS. It can handle databases from just a few KB to many Gigabytes with good performance and almost free of maintenance!

Below is a list of some of the Firebird’s major features:

  • Full support of Stored Procedures and Triggers
  • Full ACID compliant transactions
  • Referential Integrity
  • Multi Generational Architecture
  • Very small footprint
  • Fully featured internal language for Stored Procedures and Triggers (PSQL)
  • Support for External Functions (UDFs)
  • Little or no need for specialized DBAs
  • Almost no configuration needed - just install and start using!
  • Big community and lots of places where you can get free and good support
  • Optional single file embedded version - great to create CDROM catalogs, single user or evaluation versions of applications
  • Dozens of third party tools, including GUI administrative tools, replication tools, etc.
  • Careful writes - fast recovery, no need for transaction logs!
  • Many ways to access your database: native/API, dbExpress drivers, ODBC, OLEDB, .Net provider, JDBC native type 4 driver, Python module, PHP, Perl, etc.
  • Native support for all major operating systems, including Windows, Linux, Solaris, MacOS, HP-UX and FreeBSD.
  • Incremental Backups
  • 64bits builds available
  • Full cursor implementation in PSQL
  • Monitoring tables
  • Connection and Transaction Triggers
  • Temporary Tables
  • TraceAPI - know what happens in your server

 

Try it now!

Trying Firebird is a very simple task. The installer size usually isless than 7MB (depending on the operating system of your choice) and fully automated. You can download it from the Firebird main site.

You will notice that Firebird server comes in four flavors:SuperServerClassic, SuperClassic and Embedded. You can start with SuperServer. Right now, Classic is recommended for use with SMP machines and some other specific situations. SuperServer shares its cache among the database connections and uses threads to handle each connection. Classic starts one independent server process for each connection made. SuperClassic offers multithreaded single process server with independent cache for each connection.

The embedded version is an amazing variation of the server. It is afully featured Firebird server packed in just a few files. It is very easy to deploy, since there is no need to install the server. It is ideal for CDROM catalogs, demos or standalone desktop applications.

Firebird comes with a full set of command line utilities that allow you to create databases, retrieve database statistics, run SQL commands and scripts, perform backups and restores, etc. If you prefer to use a GUI (Graphical User Interface) tool, there are lots of options to choose from, including free ones. Check the list at the end of this paper for a good start.

On Windows, you can run Firebird as a service or in application mode. The installer can create an icon in the Control Panel that you can use to manage the server (start, stop, etc).

Documentation

There are a lot of papers, FAQs and articles that you may want to check in the Firebird main site. Also, you can check if your country has a localized community site or discussion list, so you can get support in your native language.

All this information can be found digging around in the Firebird main site. Also, check www.firebirdnews.org to get up to date with the most recent news related to Firebird.

For all sized databases

Some people thinks that Firebird is a RDBMS to be used with just small databases and a few connections. They are wrong! Firebird is being used with many big databases and lots of connections. You can read full article about real 1 Terabyte database.

Tools & Components

Here you can find a list with some interesting resources including tools, drivers, etc. Please check the official Firebird site for a more complete and up to date list.

GUI Administration tools

Drivers and access components

Delphi componentsODBCOLEDBJava.Net ProviderC++Other languages 

Replication tools

Support and resource links

Misc

Papers and documentation

 

Would you like to help?

Due to the nature of an Open Source project, anyone cancontribute by developing new features or fixing bugs. If you want to become a member of the Firebird Development Team, download the Firebird source code from sourceforge and study it. Also, you may join the fbdevel discussion list to get in touch with other developers (note: fbdevel is not a general support list, so don’t ask support questions there, instead use firebird-support for free community support).

You don’t need to be a coder to help the project. Become amember of the Firebird Foundation or make a donation and you will be helping to fund core developers so they can invest more time working in the project.

Thanks for these two minutes...

Contact Information
Contact info
Email