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


Picon

Firebird - Where we stand and where we go

The virtual session that Dmitry Yemanov gave last year for the 11th Firebird Developers Dayis now publicly available in YouTube.

The video is in English, and there are subtitles in PT-BR available. In this video, Dmitry talks about the most recent developments done in FB 3, comment about the reasons for the delays of the releases, what can we spect for the future, etc.

Obs: Please note that this session was recorded August/2014.


Firebird - Onde estamos, para onde vamos...




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


Picon

Historic Question

I'm just having fun with 64 bit support in PHP and while drafting a
reply I suddenly thought. "When did 64bit BIGINT appear in Firebird?"
Were generators always 64 bit or did they evolve from 32bit. I probably
knew the answer at one point, but those grey cells have long since been
detached from the recall subroutines :)

--

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

------------------------------------
Posted by: Lester Caine <lester <at> lsces.co.uk>
------------------------------------

Picon

Interbase price in 1990

Whikle searching for Interbase Software Corporation I found this announcement for ib 3.0 


https://books.google.ro/books?id=pslDqcef8UEC&pg=PA32&lpg=PA32&#v=onepage&q&f=false




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


Picon

Samsung Unveils SSD Delivering Speeds of Over 2 GB/s

It can be good for database servers with these specs : 


With a PCIe 2.0 interface, the SM951 has sequential speeds up to 1,600MB/s read and 1,350MB/s write and random performance of 130,000 IOPS read and 85,000 IOPS write.


viea hackernews


Samsung Unveils SSD Delivering Speeds of Over 2 GB/s | Hacker News




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


Picon

Jaybird 2.2.6 released

We're happy to announce the release of Jaybird 2.2.6, just in time for 
the new year.

See http://www.firebirdsql.org/en/jdbc-driver/ for more information and 
download links.

Happy New Year to you all.

Mark
--

-- 
Mark Rotteveel

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

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

Picon

Vote for Firebird as Database of the Year 2014 at LinuxQuestions

Vote for Firebird as Database of the Year 2014 at LinuxQuestions (must be registered user with at least one Linux related post)

http://www.linuxquestions.org/questions/2014-linuxquestions-org-members-choice-awards-113/database-of-the-year-4175528382/

Spread the word on all forums and Firebird communities




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


Picon

Testing the Firebird 3 protocol enhancements

In case you have slow networks 


http://www.firebirdnews.org/testing-the-firebird-3-protocol-enhancements/




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


Picon

You can install and use Firebird on new ARMv8 ubuntu devices




ARMv8 X-Gene X-C1 Development Systems, powered by 14.04 LTS, now available.



You can install and use Firebird on new ARMv8 (64bit) ubuntu devices




__._,_.___
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




__,_._,___

Gmane