Picon

few questions from noob

Hello,

two days ago I noticed some thread in Lazarus/FPC forums mentioning
Firebird. I knew about it from before, but never bothered to research
more about always thinking that for my usage as application's fileformat
and/or storage back-end Sqlite3 is good-enough.

Now, after being interested to learn and use FPC/Lazarus, Firebird has
fanned my interest...did some reading about it, installed it on my
Debian (Sid), watched several slide-presentation, did some chatting in
#firebird...and now have few questions...

As someone who would like to use Firebird mostly as embedded database
(of course, no idea what the future will bring about) and just aobut to
start learning about it, do you recommend to start with 3.o which is
available in Debian's "experimental" in order to avoid re-learning stuff
during 2.5 --> 3.0 migration?

What about the docs? 3.0beta2 release notes are extensive, but I wonder
about QuickStart Guide and Language Reference? Are the old docs still
mostly relevant for learning Firebird?

Is there any plan to produce The Firebird Book Third Edition covering
3.0 in paper soon? (I simply like holding concrete books in my hand and
despite having Kobo ereader prefer to read from the paper.)

It seems Firebird is good option for FPC/Lazarus development, do you
have any specific hints in regard?

Let me also congratulate Firebird devs for making it possible to have
(Continue reading)

Picon

Open source for products in four rules (and 10 slides)

There are four rules to understand when building products out of open source software. 


http://opensource.com/business/15/8/open-source-products-four-rules




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Re: Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for July

Well...

It is a long time ago, but I missed transaction, Referential Integrity, and stability, DBF (or paradox files) tend to corrupt once in a week if you are lucky ! :)

But I worked with it a lot of years, it was all that I had access (no pun intended). But I can't imagine working with DBF files anymore....

see you !

On 31/7/2015 12:50, 'Mark Rotteveel' mark <at> lawinegevaar.nl [Firebird-general] wrote:
<!-- /* start of attachment style */ .ygrp-photo-title{ clear: both; font-size: smaller; height: 15px; overflow: hidden; text-align: center; width: 75px; } div.ygrp-photo{ background-position: center; background-repeat: no-repeat; background-color: white; border: 1px solid black; height: 62px; width: 62px; } div.photo-title a, div.photo-title a:active, div.photo-title a:hover, div.photo-title a:visited { text-decoration: none; } div.attach-table div.attach-row { clear: both; } div.attach-table div.attach-row div { float: left; /* margin: 2px;*/ } p { clear: both; padding: 15px 0 3px 0; overflow: hidden; } div.ygrp-file { width: 30px; valign: middle; } div.attach-table div.attach-row div div a { text-decoration: none; } div.attach-table div.attach-row div div span { font-weight: normal; } div.ygrp-file-title { font-weight: bold; } /* end of attachment style */ --> <!-- #ygrp-mkp { border: 1px solid #d8d8d8; font-family: Arial; margin: 10px 0; padding: 0 10px; } #ygrp-mkp hr { border: 1px solid #d8d8d8; } #ygrp-mkp #hd { color: #628c2a; font-size: 85%; font-weight: 700; line-height: 122%; margin: 10px 0; } #ygrp-mkp #ads { margin-bottom: 10px; } #ygrp-mkp .ad { padding: 0 0; } #ygrp-mkp .ad p { margin: 0; } #ygrp-mkp .ad a { color: #0000ff; text-decoration: none; } -->
What definition of relational databases do you hold? I have had the "pleasure" of working with access, and with FoxPro (which used the dbase file format) and both pretty much conform to what I expect a relational database to do at a minimum.

Mark


----- Reply message -----
Van: "'Carlos H. Cantu' listas <at> warmboot.com.br [Firebird-general]" <Firebird-general <at> yahoogroups.com>
Aan: "Dmitry Yemanov dimitr <at> users.sourceforge.net [Firebird-general]" <Firebird-general <at> yahoogroups.com>
Onderwerp: [Firebird-general] Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for July
Datum: vr, jul. 31, 2015 17:18

I stopped reading after see that Access and dBase are being considered relational databases... []s Carlos H. Cantu www.FireBase.com.br - www.firebirdnews.org www.warmboot.com.br - blog.firebase.com.br DYdusnFg> 31.07.2015 17:25, mapopa <at> gmail.com [Firebird-general] wrote: >> >> Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for >> July DYdusnFg> Or 4th place among relational open-source RDBMS. DYdusnFg> Dmitry DYdusnFg> ------------------------------------ DYdusnFg> Posted by: Dmitry Yemanov <firebird2 <at> yandex.ru> DYdusnFg> ------------------------------------ DYdusnFg> Community email addresses: DYdusnFg> Post message: Firebird-general <at> yahoogroups.com DYdusnFg> Subscribe: Firebird-general-subscribe <at> yahoogroups.com DYdusnFg> Unsubscribe: Firebird-general-unsubscribe <at> yahoogroups.com DYdusnFg> List owner: Firebird-general-owner <at> yahoogroups.com DYdusnFg> Shortcut URL to this page: DYdusnFg> http://www.yahoogroups.com/community/Firebird-general DYdusnFg> ------------------------------------ DYdusnFg> Yahoo Groups Links ------------------------------------ Posted by: "Carlos H. Cantu" <listas <at> warmboot.com.br> ------------------------------------
Picon

Re: [Firebird-general] Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for July

What definition of relational databases do you hold? I have had the "pleasure" of working with access, and with FoxPro (which used the dbase file format) and both pretty much conform to what I expect a relational database to do at a minimum.

Mark


----- Reply message -----
Van: "'Carlos H. Cantu' listas <at> warmboot.com.br [Firebird-general]" <Firebird-general <at> yahoogroups.com>
Aan: "Dmitry Yemanov dimitr <at> users.sourceforge.net [Firebird-general]" <Firebird-general <at> yahoogroups.com>
Onderwerp: [Firebird-general] Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for July
Datum: vr, jul. 31, 2015 17:18
v>
I stopped reading after see that Access and dBase are being considered relational databases... []s Carlos H. Cantu www.FireBase.com.br - www.firebirdnews.org www.warmboot.com.br - blog.firebase.com.br DYdusnFg> 31.07.2015 17:25, mapopa <at> gmail.com [Firebird-general] wrote: >> >> Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for >> July DYdusnFg> Or 4th place among relational open-source RDBMS. DYdusnFg> Dmitry DYdusnFg> ------------------------------------ DYdusnFg> Posted by: Dmitry Yemanov <firebird2 <at> yandex.ru> DYdusnFg> ------------------------------------ DYdusnFg> Community email addresses: DYdusnFg> Post message: Firebird-general <at> yahoogroups.com DYdusnFg> Subscribe: Firebird-general-subscribe <at> yahoogroups.com DYdusnFg> Unsubscribe: Firebird-general-unsubscribe <at> yahoogroups.com DYdusnFg> List owner: Firebird-general-owner <at> yahoogroups.com DYdusnFg> Shortcut URL to this page: DYdusnFg> http://www.yahoogroups.com/community/Firebird-general DYdusnFg> ------------------------------------ DYdusnFg> Yahoo Groups Links ------------------------------------ Posted by: "Carlos H. Cantu" <listas <at> warmboot.com.br> ------------------------------------
Picon

Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for July

Firebird reached 14th place on DB-Engines Ranking of Relational DBMS for July


http://db-engines.com/en/ranking/relational+dbms




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

node-firebird 0.6.5 released



New release for node-firebird fixes minor issue #69

Don’t try to read from an empty buffer

In some cases getSegment can get an empty (undefined) buffer which
result to InternalError: "Cannot call method 'readUInt16LE' of
undefined".

node-firebird

 




__._,_.___
Posted by: mapopa <at> gmail.com


Community email addresses:
  Post message: Firebird-general <at> yahoogroups.com
  Subscribe:    Firebird-general-subscribe <at> yahoogroups.com
  Unsubscribe:  Firebird-general-unsubscribe <at> yahoogroups.com
  List owner:   Firebird-general-owner <at> yahoogroups.com

Shortcut URL to this page:
  http://www.yahoogroups.com/community/Firebird-general




__,_._,___
Picon

10 Rules for a Better SQL Schema

There are a lot of decisions to make when creating new tables and data warehouses. Some that seem inconsequential at the time end up causing you and your users pain for the life of the database.

We've worked with thousands of people and their databases and, after countless hours of reading and writing queries, we've seen almost everything. Here are our top 10 rules for creating pain-free schemas.


10 Rules for a Better SQL Schema




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Jaybird 2.2.8 released (fixed link)

(a previous version of this mail had an incorrect link)

I have just released Jaybird 2.2.8.

The release can be downloaded from 
https://github.com/FirebirdSQL/jaybird/releases/tag/v2.2.8

The release is also available on maven(*):

     <groupId>org.firebirdsql.jdbc</groupId>
     <artifactId>jaybird-jdkXX</artifactId>
     <version>2.2.8</version>

* The artifactId depends on your target Java version: jaybird-jdk18, 
jaybird-jdk17, or jaybird-jdk16.

Full release notes available at 
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.8/release_notes.html

The following has been changed or fixed since Jaybird 2.2.7:

* Support for Java 5 has been dropped
* Fixed: LibreOffice doesn't display tables with more than 41 records 
([JDBC-383](http://tracker.firebirdsql.org/browse/JDBC-383))
* Improvement: Don't use Firebird provided IP address for connecting 
event channel ([JDBC-384](http://tracker.firebirdsql.org/browse/JDBC-384))
* Fixed: Connection.getMetaData().getColumns result set contains wrong 
(empty) COLUMN_DEF if column type was defined using domain 
([JDBC-388](http://tracker.firebirdsql.org/browse/JDBC-388))
* Fixed: Unable to retrieve update count after result set 
([JDBC-390](http://tracker.firebirdsql.org/browse/JDBC-390))
   After executing a query that produces a result set, calling 
getMoreResults will allow getUpdateCount to actually return the update 
count where previously it always returned -1. This also allows obtaining 
the update count after a select query (even when executed using 
executeQuery). For selects the result will usually be 0.
* Fixed: SELECT statements are processed for getGeneratedKeys by 
appending RETURNING (+ all columnnames) 
([JDBC-391](http://tracker.firebirdsql.org/browse/JDBC-391))
* Fixed: Generated key grammar does not correctly handle quoted table 
names ([JDBC-392](http://tracker.firebirdsql.org/browse/JDBC-392))
* Fixed: Generated key grammar does not detect returning clause in 
update and delete 
([JDBC-393](http://tracker.firebirdsql.org/browse/JDBC-393))

Kind regards,
Mark Rotteveel
--

-- 
Mark Rotteveel

------------------------------------
Posted by: Mark Rotteveel <mark <at> lawinegevaar.nl>
------------------------------------

Picon

Jaybird 2.2.8 released

I have just released Jaybird 2.2.8.

The release can be downloaded from 
https://github.com/FirebirdSQL/jaybird/releases/edit/v2.2.8

The release is also available on maven(*):

     <groupId>org.firebirdsql.jdbc</groupId>
     <artifactId>jaybird-jdkXX</artifactId>
     <version>2.2.8</version>

* The artifactId depends on your target Java version: jaybird-jdk18, 
jaybird-jdk17, or jaybird-jdk16.

Full release notes available at 
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.8/release_notes.html

The following has been changed or fixed since Jaybird 2.2.7:

* Support for Java 5 has been dropped
* Fixed: LibreOffice doesn't display tables with more than 41 records 
([JDBC-383](http://tracker.firebirdsql.org/browse/JDBC-383))
* Improvement: Don't use Firebird provided IP address for connecting 
event channel ([JDBC-384](http://tracker.firebirdsql.org/browse/JDBC-384))
* Fixed: Connection.getMetaData().getColumns result set contains wrong 
(empty) COLUMN_DEF if column type was defined using domain 
([JDBC-388](http://tracker.firebirdsql.org/browse/JDBC-388))
* Fixed: Unable to retrieve update count after result set 
([JDBC-390](http://tracker.firebirdsql.org/browse/JDBC-390))
   After executing a query that produces a result set, calling 
getMoreResults will allow getUpdateCount to actually return the update 
count where previously it always returned -1. This also allows obtaining 
the update count after a select query (even when executed using 
executeQuery). For selects the result will usually be 0.
* Fixed: SELECT statements are processed for getGeneratedKeys by 
appending RETURNING (+ all columnnames) 
([JDBC-391](http://tracker.firebirdsql.org/browse/JDBC-391))
* Fixed: Generated key grammar does not correctly handle quoted table 
names ([JDBC-392](http://tracker.firebirdsql.org/browse/JDBC-392))
* Fixed: Generated key grammar does not detect returning clause in 
update and delete 
([JDBC-393](http://tracker.firebirdsql.org/browse/JDBC-393))

Kind regards,
Mark Rotteveel
--

-- 
Mark Rotteveel

------------------------------------
Posted by: Mark Rotteveel <mark <at> lawinegevaar.nl>
------------------------------------

Picon

Fwd: Unable to deliver your message

I'm trying to restore a backup lvl 0, but encountering the following error:

Failure: Cannot get backup guid clumplet from I.O backup

There's no place where this error gets reported and I'm unable to figure out the reason by this simple message.
Any thoughts?




__._,_.___
Posted by: =?UTF-8?B?Vmluw61jaXVzIEUu?= <vncastanheira <at> gmail.com>


Picon

SQL Relay 0.59 is out

SQL Relay version 0.59 is released  http://software.firstworks.com/2015/04/sql-relay-059-is-out.html




__._,_.___
Posted by: mapopa <at> gmail.com



Gmane