SQL Compact Edition or Firebird Embedded ?
I need to choose an embeded database for my Windows desktop application programmed in C# .NET.
Firebird related news
I need to choose an embeded database for my Windows desktop application programmed in C# .NET.
Hi all,
This is mostly a bug-fix release, probably a first ‘stable’ 0.8
version without major bugs. Windows, Linux and Mac OS X binaries and
source code package are available for download. I recommend all Linux
distribution packagers to upgrade (especially if you still use 0.8.3
or lower). Here’s the changelog since 0.8.3:
New features
– DataGrid: BLOB data is now (optionally) shown in cells. Read-only for now.
– DataGrid: A basic ORDER BY clause building when column header is
double-clicked
– Support for LIST function in Firebird 2.1
– Support for MON tables in Firebird 2.1 (Read-only for now.)
Enhancements and Bug fixes
– DataGrid: FR no longer crashes when transaction has ended
(commit/rollback) and grid edit control is active
– DataGrid: Complete string is now shown for editing and copying multiline text
– DataGrid: Copy command now copies a single cell if nothing is selected
– DataGrid: Fixed mixup between BLOB ID and data it contains
– DataGrid: Fixed bug when editing or deleting in grid causes exceptions.
– DataGrid: Successfully deleted rows are deselected, so user can
easily see what is done.
– DDL extraction for GRANTs now only quotes names when needed
– DDL extraction for defaults does not use double quotes anymore.
– Database property page now shows minor ODS version when it is not zero
– Hovering over icons in privileges window, now really shows the grantor
– Improved parsing of SELECT statements
– Support for INSERT..RETURNING and EXECUTE STATEMENT that return a
single record
– Fixed messagebox flood when Execute Procedure called and it doesn’t
return anything
– Print preview and SaveToHtmlFile works again for manual and changelog
– Extracting invalid DDL (missing domain data in system tables) does
not crash FR anymore
– Silent installation (on Windows) does not show changelog window anymore
– Autogenerated domains (system domains) do not show up in the tree anymore
– Added ALTER DOMAIN action for domains
– Tree now shows NOT NULL for columns that inherit NOT NULL from domain
– Fixed parsing bug when non-reserved keyword is used as identifier
– Fixed autocomplete for selectable procedure alias when procedure
call contains parameters (in PSQL)
Enjoy.
The ubuntu gutsy 7.10 and hardy 8.04 includes firebird 2.0.3 latest stable release, here is how to install it on both
You can download Firebird 2.5 head builds for linux from here
The new version of FirebirdClient (ADO.NET Data Provider) is available for download: http://firebirdsql.org/index.php?op=files&id=netprovider .
It’s mainly a bugfix release. Work on Entity Framework support still continues.
The goal of this project is to provide information about how various pieces of software (e.g. operating systems, DBMS and others) sort textual data, in the form of easy-to-read charts.
Check Firebird collation charts.
you can test it in debian unstable (amd64 and i386) from debian sid repository
http://packages.debian.org/sid/flamerobin
Other binary snapshots for flamerobin 0.8.5 are here
(you can tests on other operating systems: Linux, MacosX, windows,wine)
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
It’s weird that sqlite is not on the first row it’s used in firefox/google gears … and disabled in php.ini by default
Which one of the two would you choose and why?