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


Picon

HyperLogLog in Pure SQL

Using probabilistic counting we'll make count distinct even faster, trading a little accuracy for the increase in speed.

We'll optimize a very simple query, which calculates the daily distinct sessions for 5,000,000 gameplays (~150,000/day)



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


Picon

Create table with different ownership

   Hello, All.

   Is there in SQL standard a way to create database object as owned by different user or 
to transfer ownership to a different user?

--

-- 
   WBR, SD.

------------------------------------

------------------------------------

Picon

Raspberry Pi and Firebird science project

The Meteor Pi citizen science project is developing a network that will track and record meteorites and other astral objects using Raspberry Pi and Firebird.

http://www.cambridgesciencecentre.org/MeteorPi/


News via twitter 
Meteor Pi on Twitter




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


Picon

ANN Firebird 2015 Tour: SQL optimization

Hi All,

We invite all Firebird developers and administrators to 1-day seminar in the frames of Firebird 2015 Tour.  Firebird 2015 Tour is devoted to the SQL performance optimization:  SQL plans, queries and database statistics, query tuning techniques and deep understanding of undercover work of Firebird.

Firebird 2015 Tour is organized by IBSurgeon and IBPhoenix, with support of Firebird Developers core team.
Locations and dates of Firebird 2015 Tour (see details in the appropriate sections below):

April 24 - Seligenstadt, Germany
May 19 – Prague, Czech Republic
June 5 – Moscow, Russia

Topics of Firebird 2015 Tour seminar:

1)    Performance of SELECT queries
 a.    PLANs: what are INDEX, SORT, ORDER, NATURAL and how to manage them
 b.    Execution statistics interpretation, data paths, cache hits
 c.    Tracking slow and resource-consuming resources through MON$ and Trace API
 d.    Firebird configuration parameters
 e.    Best practices, tips and tricks to speed up queries

2)    Performance of INSERT queries
 a.    Typical errors which lead to slow INSERTs
 b.    How indices, triggers and database structure affect INSERT performance
 c.    Transactions and INSERTs
 d.    Best practices to speed up INSERTs

3)    Performance of UPDATE and DELETE queries
 a.    General approach for updates and deletes
 b.    How indices, triggers and database structure affect UPDATE and DELETE performance
 c.    Update Conflicts, transactions and their resolution, DELETE, SELECT WITH LOCK
 d.    Real-life example of UPDATEs algorithm without conflicts
4)    Multi-user performance optimization
 a.    Locks, mutexes and races for resources
 b.    Selecting Firebird architectures and tuning their parameters for multi-user environments
 
Locations details for Firebird 2015 Tour

April 24, Seligenstadt, Germany

Seminar will take place in Hotel Columbus (www.hotel-columbus.de/contact.php/), April 24, 2015.
Important! All topics are presented in English!

Seminar's schedule:
9-30-10-00 Registration
10-00 - 17-00 Seminar (with Lunch and Coffee breaks)

Attendee's package includes seminar’s materials, lunch and coffee breaks.

The early bird registration fee is EUR 49 (till April 5, volume discounts are available).
https://secure.shareit.com/shareit/checkout.html?productid=300604679

May 19, Prague, Czech Republic

Seminar will take in the Hotel Extoll Inn (http://extolinn.cz/en/contact.htm),  May 19, 2015.
 Important! All topics are presented in English!
Seminar's  schedule:

9-30-10-00 Registration
10-00 - 17-00 Seminar 10-00 - 17-00 Seminar (with Lunch and Coffee breaks)

Attendee's package includes seminar’s materials, lunch and coffee breaks.

The early bird registration fee is EUR 39 (till April 25, volume discounts are available)
https://secure.shareit.com/shareit/checkout.html?productid=300660565

June 5, Moscow, Russia

Seminar will take place in TechnoPark «Slava» (www.technopark-slava.ru/contacts),  June 5, 2015.
Important! All topics are presented in Russian!

Seminar's  schedule:
9-30-10-00 Registration
10-00 - 17-00 Seminar (with Lunch and Coffee breaks)
Attendee's package includes seminar’s materials and coffee breaks.

The early bird registration fee is EUR 39 (roubles 2800) (till April 25).
https://secure.shareit.com/shareit/checkout.html?productid=300604678

Для получения российского счета на оплату напишите sales <at> ibase.ru


Questions?

Feel free to ask any questions at firebird2015 <at> ib-aid.com


Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com





__._,_.___
Posted by: Alexey Kovyazin <ak <at> ib-aid.com>


Picon

Programatically updating Aliases.conf and virtualization

Hi all

Using FireBird as the back end the Aliases.conf file needs to be updated at runtime.  Now Windows 7 does not like me updating this file
C:\Program Files (x86)\Firebird\Firebird_2_5\aliases.conf

It will update a copy instead
C:\Users\UserName\AppData\Local\VirtualStore\Program Files (x86)\Firebird\Firebird_2_5\aliases.conf

Not wanting to update folder permissions of Firebird what is the best way to tackle updating without virtualizing this file.  This becomes important because when users connect over the LAN they will only connect using the alias as stored in this file where as the local update of the file on the server has been virtualized so essentailly the users won't be able to connect to the intended database.

Please advise

Thanks and regards
Bhavbhuti

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



Gmane