big table google video presentation

You can watch the video presentation how bigtable based database is working for google.com
(inside view).
Another related paper (pdf) with bigtable info is located at google's labs

http://labs.google.com/papers/bigtable-osdi06.pdf

.:(firebird):..:(databases):..:(sql):..:(google):..:(bigtable):..:(clusters):.

Don't tell us that is Marina! - we sent her to indonesia

That is marina novikova ? Don't tell us that she is :)
Now is doing well in her dream trip
Firebird never looked so good

.:(firebird):..:(databases):..:(sql):.

firebird rc4-5 soon

i submitted the news about rc4 and 5 on the bsdnews channel
I try to find new sites where to spread the word about firebird and new ways of doing pr (any wacky ideas are allowed)

.:(firebird):..:(databases):..:(sql):..:(bsd):..:(openbsd):..:(freebsd):.

Firebird Conference 2006 Initial Programme

..has been released on the Conference pages. It's a tightly-drawn selection of highly interesting topics with something for everyone. Notice that, this year, several papers will be presented on the Sunday afternoon, in advance of the Welcome session in the evening.

.:(firebird):..:(databases):..:(sql):..:(conference):.

Firebird and phpbb 3.0

I tested the new phpbb 3.0 setup with firebird 1.5.3 and php 4.4.x
and almost i finished the creation of all the tables then it crashes at some point

A fatal and unrecoverable database error has occured. This may be because the specified user does not have appropriate rights to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1323 ]

SQL : INSERT INTO phpbb_modules (module_basename, module_enabled, module_display, parent_id, module_class, module_langname, module_mode, module_auth, left_id, right_id) VALUES ('attachments', 1, 1, NULL, 'acp', 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach', 1, 2)

.:(firebird):..:(databases):..:(sql):..:(php):..:(phpbb):.

firebird client for ARM platform (KinterbasDB interface)

Hi,
following question was allready posted on firebird-support but no answer:

Se would like to connect our ARM based computers (Linksys NSLU2 with
the DebianSlug Linux) to the firebird database running on the server.
Is there a way how to compile linux Firebird (client ONLY!!!) for ARM
platform?

We are using Python and KinterbasDB Firebird interface, which runs
only, when the Firebird is installed on the machine.

Best regards

Petr Jakes on the firebird-python group


.:(firebird):..:(databases):..:(sql):..:(debian):..:(python):.

Can I install Firebird on Asus WL-HDD

Asus WL-HDD is an mipsel machine so with custom firmware (linux toolchain) it may be possible
to install firebird on it .
Here is the mipsel port status
http://www.firebirdnews.org/?p=559
Here is the request (thread)
http://wl500g.info/showthread.php?t=6502

.:(firebird):..:(databases):..:(sql):.

Some books about distributed databases / systems (principles)

Here are the list of books i want to read these days (on my desk)

http://www.aw-bc.com/catalog/academic/product/0,1144,032131283X,00.html
http://www.aw-bc.com/catalog/academic/product/0,1144,0321263545,00.html
http://vig.prenhall.com/catalog/academic/product/1,4096,0130888931,00.html
http://www.amazon.com/gp/product/0136597076/sr=1-1/qid=1155718008/ref=sr_1_1/102-8280438-8944144?ie=UTF8&s=books

.:(firebird):..:(databases):..:(sql):.

Intelligence (for) business: Using Pentaho with Firebird

[To use Firebird as a database source for queries in your pentaho solution you need very little things]

Read more at new-google-blog.blogspo...

Oracle Users: Keen on Open Source | Database | SQL Server | Oracle | MySQL | DB2 | PostgresSQL |

[Although a majority of Oracle users who participated in a recent study don’t or won’t use open-source databases, the uptake of open source in general is going strong.Sixty percent of Oracle users who responded to a survey put out by the Independent Oracle Users Group are using open-source operating systems somewhere in their operations.]

Read more at www.idoel.smilejogja.co...

How Products Were Named: How Was "Firefox" Named?

the new name, Firebird, provoked mixed reactions, particularly since thefree database software Firebird uses the same name. In late April,following an apparent name change to Firebird browser for a few hours,the Mozilla Foundation stated that the browser should always bear thename Mozilla Firebird in order to avoid confusion with the Firebirddatabase server. However, continuing pressure from the FLOSS communityforced another change, and on February 9, 2004, Mozilla Firebird becameMozilla Firefox (or Firefox for short).

Read more at productnames.blogspot.c...

Debian architectures, according to popularity-contest

[Our nex porting target would be arm or powerpc , Here is the popularity contest results for debian, The raising star is 'arm',now used by 1.3% of the population.]

Read more at lists.debian.org/debian...

Firebird 2 Release Candidate 4

We are pleased to invite you to download your preferred binary kit for Firebird 2 Release Candidate 4. Though very close, this is still a field-testing release. Please check any problem areas you encountered in RC 3 and report to the Firebird-devel list without delay if something isn't working as you expect.
Please note also that this release will NOT become the final one, due to an issue that appeared after these builds were made.

.:(firebird):..:(databases):..:(sql):.

spreading the word about latest firebird 2 rc 3

[it's time to spread the word about firebird 2 rc3 , i started with sites bellow ]

News i will send to (over time):

http://news.google.com/news?q=mysql
http://www.google.com/search?q=mono+1.0
http://www.google.com/search?q=postgresql+8.0

other good linux/mac/windoze sites

Completed area
- amdzone.com [DONE]
- icewalkers.com [DONE]
- sourcewell.berlios.de [NOT DONE]
- http://linux.softpedia.com[DONE by a good soul]
- betanews.net [DONE]
- osnews.com [DONE]
- linux360.ro [DONE]
- myl.ro [DONE]
- devshed.com [DONE on forum]
- lwn.net[DONE]
- linuxelectrons.com [DONE]
- phoronix.com [DONE]
- eweek.com [DONE sent to LisaVaas]
- informationweek.com [NOT DONE]
- infoworld.com [DONE sent to Neil McAllister]
- freshmeat.net [DONE]
- lxer.com [DONE]
- developers.slashdot.org [DONE]
- linuxquestions.org [DONE ?]
- digg.com [DONE digg it :)]
- debcentral.org [DONE]
- newsforge.net [NOT DONE]
- linuxtoday.com [NOT DONE]
- linuxpr.com [NOT DONE]
- osdir.com[NOT DONE]
- opensourcexperts.com - > PR [DONE]
- databasejournal.com [DONE forward from betanews]
- linuxgazette.net [NOT DONE]
- linuxcompatible.org [NOT DONE]
- pclinuxonline.com [NOT DONE]
- madpenguin.com [NOT DONE]
- tuxmachines.org [NOT DONE]
- prweb.com [NOT DONE ]
- sourcewell.berlios.de[NOT DONE]
- vnunet.com [DONE]
- linuxdevices.com [DONE]
- neowin.net [NOT DONE]
- warp2search.net [NOT DONE]
- fbtalk.net [DONE EN-RO]
- forum.amd.com [DONE]
- geek.com [DONE]

Open source database conference

[the folks at S&S organized a novelty: an open source database conference. It was a great success. We had people from most projects for end users to talk to: PostgreSQL, BerkleyDB, MySQL, SQLite, Apache Derby, HSQLDB, Firebird and MaxDB.]

Read more at pooteeweet.org/blog/463

A Continuous Learner's Weblog: Visual Studio 2005 and Firebird

[an small howto use firebird + vs2005]

Read more at spietrek.blogspot.com/2...

CHTEKK’s blog » #gentoo-db

[The new channel is intented to provide a platform for discussions, concerning both support and development, centering on Gentoo and databases.]

Read more at chtekk.longitekk.com/?p...

Firebird Developers Day

last chance to subscribe on the Firebird Developers Day http://www.firebirddevelopersday.com.br


.:(firebird):..:(databases):..:(sql):..:(conference):.

Firebird Embedded on Linux

[Milan published an guide about firebird embedded on linux]

Read more at sotu.berlios.de/Firebir...

Race between Firefox and Firebird

Anyone wants to bet which project: Firefox or Firebird will be first for release version 2.0?

Time to digg an Firebird vs Firefox story

.:(firebird):..:(databases):..:(sql):.

LWN: Firebird 2.00 Release Candidate 3 announced

[Enter your comment here]

Read more at lwn.net/Articles/190214...

Firebird 2.0 RC3 (omega) is out. What's next ? Gold Final Release

Firebird Database 2.0 RC3 builds are available for download (including kits for x64 Linux).Unless there are any dramas, this build will become the gold final version. More details about this release are in full changelog notes

.:(firebird):..:(databases):..:(sql):..:(linux):..:(windows):..:(amd64):..:(freebsd):..:(news):..:(macosx):..:(software):..:(ubuntu):..:(microsoft):..:(debian):..:(unix):.

Firebird Omega - Latest Release Candidate

[So this should be the name for last release candidate , and gold for the Final 2.0 ]

Read more at en.wikipedia.org/wiki/D...

Firebird 2.0 Gold Release

[Here is the info about the Gold Relase Meaning , I loved the name Netscape Gold - when i was using netscape 4.x , I wonder is that why microsoft doesn't use the word "gold" in their releases ?]

Read more at en.wikipedia.org/wiki/D...

Mobile Linux developer hails successful IPO

[Firebird is working with KDE (see the knoda tool ) , we need an Firebird ARM port for mobile devices: like cell phones, nokia770 ... ]

Read more at www.eetimes.com/news/la...

Firebird Project Doc Downloads

[Firebird Project's doc downloads in pdf format ]

Read more at www.firebirdsql.org/pdf...

Servoy Magazine: PowerDesigner (Sybase) and Firebird

[ED: sybase agressive marketing at work , "then they fight you" ]

It has been two years now since a couple of Sybase guys walked up to the Servoy booth at Apple's developer conference in San Francisco and checked the product out. Very soon after that introduction Sybase replaced Firebird to become the default database to ship with Servoy.

Read more at www.servoymagazine.com/...

Firebird is for Enterprise | SYP

[Thanks for the ping back ]

Read more at scott.yang.id.au/2006/0...

SunbeltBLOG: Microsoft model: Lose money on everything. Make it up in volume

[Ed: Blog of the day ]

"What about Access? Microsoft blew it out for $99 and killed Borland (my former employer). Then took over the high-end market with SQL. What happened? SQL gets slammed by worms and the effects have been horrendous. And how many security patches have we had with Access?"

Read more at sunbeltblog.blogspot.co...

LWN: The Firebird Conference 2006 CFP

[A call for papers has gone out for the Firebird Conference 2006, submissions are due by July 31]

Read more at lwn.net/Articles/186445...

freshmeat.net: Project details for knoda

[new version realesed for knoda database frontend]

Read more at freshmeat.net/projects/...

Jim Starkey Speaks, July Boston MySQL Meetup - My-ess-queue-ell vs. My-see-quell

[found it on the mysqlplanet]

Read more at sheeri.com/archives/88

DevMedia - Feito para desenvolvedores de software

[firebird configuration in detail , in portuguese]

Read more at www.devmedia.com.br/vis...

Firebird 2.0 RC2 (gold) is out. What's next?

Firebird Database 2.0 RC2 builds are available for download and testing (including kits for x64 Linux). More details about this release are in the full changelog

Firebird 2.0 RC2 has just been released. As we have to complete the documentation and solve some minor installation issues. Also, there were a few regressions fixed in the meantime.

But should one expect RC5 and so on? This depends on you only. The better you test the server and provide us with the feedback, the sooner we release the final version



.:(firebird):..:(databases):..:(sql):.

Looking for an firebird/linux related job

Sorry for cross posting (and spam)


Seems that i lost my job at www.reea.net (All confirmed)
so i'm looking again for job (I had to finish all my administrative tasks at
reea.net,and this temporary solution for working with them is gone now)

I will update my cv on the wiki page https://wiki.ubuntu.com/Mariuz

I have applied to the role of community manager for bazaar project ,
and canonical.com answered that they will review my cv, let's hope it will be an good answer.
(Nothing sure yet)



.:(firebird):..:(databases):..:(sql):.

New Server Dual Core - and firebird

[some firebird user with one opteron dual core need @layeredtech]

Read more at layer0.layeredtech.com/...

Remastering DSL: A Short HOWTO - candidate for small Firebird+Flamerobin live CD

[Another very good candidate for an very small Firebird + Live CD , Milan mentioned it and now i will try to remaster it . Is very good for < 100M live cd or to install it/boot on USB, with qemu starts very fast]

Read more at www.linuxforums.org/des...

Debian Live +Firebird

[Seems to be smaller than ubuntu with gnome or xubuntu , so if i can remaster it maybe i can make the default firebird+flamerobin live cd ]

Read more at live.debian.net/

Lazarus - Delphi like ide -Appliance

Here the firebird dbaware components are active and and dbgrid populated at
design time

 

Ultimat Firebird Database Appliance

Here is when install firebird components in lazarus ide
  

Mono Live + Firebird - work in progress this summer

I will create an Firebird Live Cd + mono applications this summer (be it if i'm accepted for

google summer of code or not)

Here is the list of application i intend to add to the dapper live cd (the list is taken from the mono-live.org )

Desktop Applications (written in Mono)
Beagle - Desktop Search (done with apt-get)
Blam - Blog Reader
F-Spot - Photo Album
Muine - Music Player or Banshee (itunes like with apt-get install)
Tomboy - Simple Note-Taking

Web Applications (ASP.NET)
ASP.NET Forums - 1.0 on Firebird (if it works or will be ported)
BlogX - Weblog Engine
IBuySpy - Portal on Firebird (if it works or will be ported)
mojoPortal - Community Portal
nGallery - Web Photo Gallery

Developer Tools (Mono and non-Mono)
MonoDevelop - Mono IDE (done apt-get)
Monodoc - Documentation Browser (done apt-get)
Glade - GTK+ / Gtk# GUI Builder (done apt-get)
FirebirdSQL- Best Open Source Database [DONE]
Flamerobin - Graphical Firebird Administration and Development Tool[DONE]

Other possible inclusions:
Reports Starter Kit using Mono/Firebird

Time Tracker Starter Kit using Mono/Firebird

DotNetFirebirdBB It should work with Mono/Firebird
Lucene.net (with firebird support addded) and optional spider (Hard work)
Read more about the original mono-live cd www.mono-live.org/Defau...

Firebird 2.0 From source howto (ubuntu dapper drake)

download the Firebird 2.0 RC 2 kit
wget http://ovh.dl.sourceforge.net/sourceforge/firebird/Firebird-2.0.0.12654-ReleaseCandidate2.tar.bz2

tar -jxvf Firebird-2.0.0.12654-ReleaseCandidate2.tar.bz2
cd firebird-2.0.0.12654-ReleaseCandidate2/
sudo apt-get install libreadline5-dev
sh autogen.sh --prefix=/opt/firebird2 --enable-superserver
make
sudo make install
ps -awwwx | grep firebird (see if is working)

/opt/firebird2/bin/isql -u SYSDBA -p masterkey /opt/firebird2/examples/empbuild/employee.fdb

Database: /opt/firebird2/examples/empbuild/employee.fdb, User: SYSDBA
SQL> show tables ;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES

SQL>select * from sales;

Here is one screenshot






.:(firebird):..:(databases):..:(sql):..:(ubuntu):..:(debian):.

Firebird Backups

[some notes on backup process - blog of the day]

Read more at blog.arturanjos.com/200...

MySQL PowerPC optimizations

[maybe is time for firebird on powerpc , this time i need some hardware : g4/g5 with ubuntu x.xx ]

Read more at www.greyhound-data.com/...

Firebird locking from 10.000 ft

[small intro to locking and MGA in firebird ]

Read more at cipto-kh.blogspot.com/2...

ZeosDBO intro and call for help

[they need more delphi/lazarus developers]

Read more at cipto-kh.blogspot.com/2...

installing JEDI VCS

An alternative to cvs/subversion for delphi users, what is interesting about it ? you can install it on an firebird server or use the firebird 1.5.x ebedded included in the JCVS app server setup

Read more (in portuguese) at www.delphiman.com.br/bl...

related to nhibernate and firebird support

[ What NHibernate Supports: DB2, Firebird, SQL Server 2000 / 2005, MySQL (3? ) / 4 /5, Oracle, PostgreSQL, SQLite, Sysbase, AccessYes, I guess that NHibernate is so much less flexible than their product.]

Read more at www.ayende.com/Blog/200...

Firebird locking

[firebird blog of the day]

Read more at cipto-kh.blogspot.com/2...

How open source databases will kill mssql server

[I agree with the open source databases vs mssql part, i don't have comments on the other things]

10.MySQL / PostgrSQL / Firebird threatens MS SQL Server. SQL Server is the one division that showed a modest profit in 2004, but many database professionals are switching Open Source alternatives. Even though sales for SQL Server is growing, it is growing at a slower rate than the overall market.

Read more at toorg.blogspot.com/2006...

Firebird used in ethernus (embedded devices)

[Firebird used in embedded device ]

DB/CRM module accompanied with Lefthand CRM is a great extension of Your ethernus .Stable, preconfigured [Firebird] database server for your company and flexible Customer Relationship Management encourage your employees to more efficient work.

Read more in polish at www.idg.pl/news/93067.h...

Sequoia 2.8.1 (C-JDBC) - new release new features

[Seems that Clustered JDBC got new release out- Now they renamed the project to Sequia also project have new license : apache]

Read more at freshmeat.net/projects/...

DBReplicate - Firebird dump tool ?

[interesting perl tool for dumping firebird's database structure- didn't test it yet]

Perl program to help extracting a database's data and metadata and dumping it as a set of SQL commands (similar to pg_dump or mysqldump).

Read more at www.honeypot.net/~kirk/...

firebird-docs - quote of the day - Paul Vinkenoog

I guess is time for more action in documentation area , if you can help please give a hand

[Please don't apologize! We're all volunteers, we're doing our best andwe have limited spare time. You should read some of my announcementson this list, stating that this-or-that will be ready in one day / oneweek / a couple of weeks... and compare to the actual delivery dates.In december 2002 (or 2003?) I estimated that we could have a full setof Firebird documentation ready in two years, everything written fromscratch, no copying from IBPhoenix or other docs. Of course I wouldn'thave to do it alone - there were as many as TWO active members in themanual subpoject then :-) :-)]

Read more at sourceforge.net/mailarc...

Ragetutorials.com » 1. History and definition of PHP

[I din't knew php was started as an bunch of perl scripts ;) . Good news is that you can use it with firebird , and in the future someone will fix the pdo driver in php5.x too - seems to be the next jdbc like interface to databases ]

Read more at www.ragetutorials.com/a...

myTracker - firbird project of the day

[MyTracker is tracking and collaboration system that allows users to collect, file, share, and discuss any type of information, whether it is news, a thought, bug, task, idea, document, graph and report. MyTracker is powerful, well-organized, efficient, fully customizable and easy to use.]

Read more at mytracker.sourceforge.n...

SitePoint Forums - Anyone suggest a good Firebird Database Host?

[i guess i could reply with ibphoenix firebird hosters lists and ... reea.net]

Read more at www.sitepoint.com/forum...

Ingress "Enterprise" database 2006 released

quote of the day "Its not as simple or straight forward as PostgreSQL or MySQL (or even Firebird) but its not much of a chore either. The one thing that I can't figure out is the 'sql' or 'isql' interfaces. I can't find explanations beyond how to invoke them in the guide and nothing I do has an effect.... I'll figure it out in time."

Read more at cuddletech.com/blog/piv...

FBReplicator 4.1 - released

For those who are interested, a new version of FBReplicator is now released. New features include the following

* Fixed bug with ReplManager to allow addition of target databases

* Fixed bug with ReplManager Preferences to allow for test email

* Enhanced ReplManager to provide for better form design on different screen sizes

* Changed ReplManager to run maximised

* Changed all icons to new form

* Updated to Indy 10 component set for all three packages

Please enjoy…

.:(firebird):..:(databases):..:(sql):..:(replication):..:(delphi):.

CVS report for firebird2 - Last changes

[lisf of changes for this week ]

Read more at flamerobin.org/mapopa/f...

Books! - PANIC! - by Vetle Roeim

[someone got books - yes ! Firebird bible is included]

Read more at my.opera.com/vetler/blo...

David V.F. Burton Dot Com Firebird Database support

[I call it site/blog of the day, hope that he will add fresh content to it ]

Read more at www.davidvfburton.com/i...

firebase article about installing apache 2.2 firebird and php

[How to install apache2.2. php and firebird on fedora ]

Read more at www.firebase.com.br/fb/...

Mark Logic CEO Blog: Ingres: Can You Ever Go Back?

[worth reading it - a short intro to ingres history ]

Read more at marklogic.blogspot.com/...

falcon will rock on fulltext searches (mysql)

via Jeremy's blog

The good news is that the recently announced falcon storage engine should have a FULLTEXT engine that rocks. After explaining the situation a bit more, we decided that in the mean time a 64-bit MySQL with a ton of RAM is probably the only viable solution.

.:(firebird):..:(databases):..:(sql):..:(mysql):.

Xul for thought: Strange Blog behaviour and Firebird Embedded Database on Linux

[ED:Don't know what was the solution to his problems , at least firebird embedded is used by someone ;)]

Read more at xullicious.blogspot.com...

spreding the word - firebird 2rc1

Firebird 2 rc1 released
http://www.firebirdsql.org/index.php?op=files&id=fb2_rc1

Firebird 2.0 RC1 has just been released. There will definitely be RC2 as well, as we have to complete the documentation and solve some minor installation issues. Also, there were a few regressions fixed in the meantime.

But should one expect RC3 and so on? This depends on you only. The better you test the server and provide us with the feedback, the sooner we release the final version

News i will be send to :

http://news.google.com/news?q=mysql
http://www.google.com/search?q=mono+1.0
http://www.google.com/search?q=postgresql+8.0

other good linux/mac/windoze sites

Completed area:
- icewalkers.com [DONE]
- sourcewell.berlios.de [DONE]
- http://linux.softpedia.com [DONE by a good soul]
- betanews.net [DONE by a good soul]
- osnews.com [DONE]
- linux360.ro [DONE]
- myl.ro [DONE]
- devshed.com [ DONE on forum and on blog i will post soon]
- lwn.net[done]
- linuxelectrons.com [DONE]
- phoronix.com [DONE]
- eweek.com [DONE send to Lisa Vaas]
- informationweek.com [DONE]
- infoworld.com [DONE send to Neil McAllister and Paul Krill or look for someone else pr contact?]
- http://freshmeat.net/projects/firebird/
- lxer.com [DONE]
- developers.slashdot.org [ DONE - will be rejected as usual]
- linuxquestions.org [ DONE]
- digg.com [DONE]
- debcentral.org [DONE]
- newsforge.net [ DONE]
- linuxtoday.com [DONE]
- linuxpr.com [ DONE]
- osdir.com[ DONE]
- opensourcexperts.com - > PR [ DONE]
- databasejournal.com [ DONE]
- linuxgazette.net [ DONE]
- linuxcompatible.org [ DONE]
- pclinuxonline.com [ DONE]
- madpenguin.com [DONE]
- tuxmachines.org [DONE]
- prweb.com [DONE ]
- sourcewell.berlios.de [DONE]
- vnunet.com [ DONE]
- linuxdevices.com [DONE]
- neowin.net [ DONE]
- warp2search.net [DONE]



.:(firebird):..:(databases):..:(sql):.

Daffodil Replicator v2.1 - upport for Heterogeneous Data Replication with Firebird

Few new features included in Daffodil Replicator v2.1 are:

MySQL Database Replication Support: Heterogeneous Data Synchronization between MySQL and other databases has been introduced.

Support for Heterogeneous Data Replication with Firebird: Daffodil Replicator v2.1 provides the flexibility of data replication between Firebird and any other database supported by Daffodil Replicator.

.:(firebird):..:(databases):..:(sql):..:(mysql):.

Gentle.NET ORM with firebird support

I have seen lots of .NET architect speak highly about NHibernate which I agree that is a great framework but I think that as it was ported from java they did not take the .NET advantages in consideration. I have tried for a while to use gentle.net framework which I found to be more of what I expected from a .NET framework as it uses attributes as it's mapping mechanism and by that you get in my opinion a better experience as a programmer.

.:(firebird):..:(databases):..:(sql):.

Job Scheduler 1.2.6 (Default branch)

The Job Scheduler runs executable files, shell scripts, and database procedures automatically
.:(firebird):..:(databases):..:(sql):.

Generator (FB) vs Sequence(Oracle)

In this comment I will compare a featured called "generator" in Firebird (FB) with "sequence" in Oracl

.:(firebird):..:(databases):..:(sql):.

chess game in ajax - done by morfik team

Much had been said about the browser as a platform. It was an idea strongly promoted by, the now gone, Netscape at the start of the Web revolution, but we never got there. Did we? Yes, we did! We just did not notice it!
If you take your browsers to this chess game, you might start to understand what I mean.

< This game has a great interface and is played against you by your own computer. Your moves do not get sent off to a server which comes up with a response and sends a move order back to your browser. The analisys of the play and the decision of the move is entierly done in Javascript, in your own machine, by the browser.

[ED:via Mauricio Longo’s blog , now that is something useful ]

.:(firebird):..:(databases):..:(sql):..:(ajax):..:(javascript):..:(game):.

MyPostBirdSQL 2.0 RC1 released

Today a RC1 release is announced that many oss developers had been awaiting
MyFireGreSql 2.0 is based on code from mysql 6.0 ,firebird 3.0,postgresql 9.0
We needed a big shake up in open source database world and working on the common code base have it's
advantages:Firebird and Postresql borrowed from mysql's speed , mysql used MVCC for it's transactional engine (is based on firebird) .
SQL2003 is implemented in all three engines now that is published as standard .So why working on a three SQL200X implementations when we could work only on one? , The project's model is linux kernel where vendors are using only one source code for their distributions (patched properly) but there is only one organization for working on the kernel osdl.

.:(firebird):..:(databases):..:(sql):..:(mysql):..:(postgresql):.

Then they laugh at you

ot only does open source Firebird-Fyracle have a catchy name and almost match Oracle on the 6 well known “gold standard key database evaluation mapping criteria”, but it is “just as idiosyncratic”, AND you can run “Compiere v2.5.3c” ( almost )!

Here is the response from shocked oracle users after they found Firebird/Fyracle (Denial Mode)

Permalink

.:(firebird):..:(databases):..:(sql):..:(oracle):..:(mssql):.

20GB of video data available, with around 100 hours of firebird related presentations from Firebird Conference

Here is the list of available Films

What is IBExpertLive?

HK-Software has implemented a streaming system based on the Firebird database server, which publishes pictures and audio, as needed to view the presentations from the 2004 and 2005 Firebird Conferences. We will also be adding IBExpert tutorial videos enabling you to learn more about working with Firebird and InterBase with IBExpert.

There is currently about 20GB of video data available, with around 100 hours of firebird-related presentations from last two Firebird Conferences and other events.

To use IBExpertLive, you need a firebird connection via Internet using port 13050 to our server on IP 80.237.154.78. If it does not work, please check your firewall settings. For reporting any other questions/problems regarding IBExpertLive, please use the following contact addresses:

IBELive newsgroup: hk-software.ibexpert.live (English, German and Russian language).

E-mail: ibexpertlive at ibexpert.biz.

There might be some videos that are not working yet, even if they are on the list. Please bear with us; we'll have everything up and running as soon as possible.

The download address is: www.ibexpert.com/ibexpertlive/IBExpertLive_setup.exe

.:(firebird):..:(databases):..:(sql):.

google reader firebird

Here is the list of feeds i have in google reader

http://forums.devshed.com/rss61.xml
http://fhasovic.blogspot.com/atom.xml
http://www.firebirdsql.org/devjournal/rss.php
http://www.firebirdnews.org/?feed=rss2
http://firebirdnews.blogspot.com/atom.xml
http://flamerobin.blogspot.com/atom.xml

I had the firebird-support added but it was too much for
google reader (scrolling between many posts)

.:(firebird):..:(databases):..:(sql):.

The Firebird ADO .NET Data Provider 1.7.1 for .NET 1.1 and Mono 1.1 is available for for download.

Download information can be found here ·

· 1.7.1 ( 2006-03-29 ) ·

(Please read the Changelog for details)

Bug Fixes:

- Fixed bug #1417618

- Minor fix on Guid datatype infer.

Changes:

- Changes to try to avoid problems with IPV6.

- Added new synonym for the user identification ( userid ) in
connection strings.

New features:

- Added initial support for EXECUTE PROCEDURE commands in
FbBatchExecution class.

–
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/

..::firebird::..dotnet::..mono::..asp.net::..csharp::...net::..

fyracle - oracle replacement blog of the day

I won't be suggesting this as a replacement for my Oracle production databases anytime soon, but it might be worth looking at for some applications.

..::firebird::..oracle::..

Google blogsearch drowning in spam

I agree with that
Try to search Firebird on the google search (and sort it by Date)
ps: i tweak-ed the search a little eliminating the auto,body, parts articles
Now even tehnocrati.net is starting to get spammed (Search for firebird+database)
..::firebird::..:(google):..:(spam):..:(tehnorati):..:(blogs):..

Firebird source code reviews

Claudio Valderrama wrote:

"Recently, Coverity presented their first results in their scanning technology that hunts for defects in source code. One of the addressed projects was Firebird. After Roman Rokytskyy reviewed the results, he concluded the failures are in two areas ..."

..::firebird::..

New acronyms FLAPS , FWAP, FWIP

FLAPS is FLAP with ssl (that is s for)

FWAP is an acronym for the combination Microsoft Windows, Apache, Firebird and one or more of Perl, PHP and Python. It is modelled after the more well-known FLAP, referring to the all-open source/free software approach which uses Linux instead of Windows.
FWIP is the WIMP equivalent (alias) with firebird used instead of mysql
..::firebird::..::windows::..::lamp::..::apache::..::php::..

FlameRobin whitepaper

it was recently concluded that the original authors have the copyright
on papers that were published at the Firebird Conference, so I decided
to make my paper available to the public.

Some small portion of the text is outdated (based on version 0.4.0),
but you can read about history and basic ideas around the project:

http://www.flamerobin.org/flamerobin_paper.pdf
Thanks,

Milan

..::firebird::..::flamerobin::..

TurboCASH development implementing Firebird database

From the blog of the day department

This blogger's comment:

I think this is really good news, since the Delphi source code poses a lot of limitations, Delphi being a commercial compiler/IDE. The way I understand it, you basically have to purchase Delphi if you want to customize and recompile the TurboCASH source. The same with BDE-Paradox. I'd really like to see TurboCASH take-off in this direction.

..::firebird::..::delphi::..::pascal::..::linux::..

Six Reasons Why a Company or Business should consider Blogging

I sent an email to one of my freelance clients regarding the advantages of having a blog site, and I thought it would be nice to share them with you.

..::firebird::..::blogging::..

Let there be Fire - morfik site revamped

Today I was glad to see the new website of Morfik Technology was unveiled. Along with a totally redesigned web site, comes the public release of a test version of the their WebOS AppsBuilder tool. These transformations probably reflect a move by Morfik, to bring the development of the WebOS AppsBuilder into the light, after being kept in the shadows for quite some time.

Ed:if you don't know what is the link between firebird and morfik here is an e-mail interview with the Morfik team

..::firebird::..::ajax::..::csharp::..::delphi::..

MSSql difficult to configure? switch to firebird

However I don't like MSSql server, first of all it is hard to configure, finding solutions to problems is not an easy task, it has lots of dependencies scattered around the hard disk. Hail mysql and firebird.


..::firebird::..::mysql::..::mssql::..

Postgres, SQLite, Firebird are all by boring Americans

It occurs to me that the Unix world is truly international. The new addv-thingy (no title yet, I might reuse SFIC, don't know) is going to be written for Ruby on Rails. The Ruby part is from Japan, and is therefore probably written by catgirls and/or ninjas. Maybe catgirl ninjas. (If such do not exist, they should.) Rails, on the other hand, comes from Denmark and is full of viking goodness. Now if I only could find a database from an as-yet-unrepresented region of the world. MySQL is Swedish, but I think that may be overrepresenting Scandinavia. Postgres, SQLite, Firebird are all by boring Americans, and I ought to be the only boring American on this project. Ah well, geeographic diversity ain't everything.

http://beinsane.livejournal.com/56919.html?view=48727#t48727

..::firebird::..::mysql::..::rubyonrails::..::freebsd::..::postgresql::..::lamp::..

New Debian firebird2 packages fix denial of service

Aviram Jenik and Damyan Ivanov discovered a buffer overflow in firebird2, an RDBMS based on InterBase 6.0 code, that allows remote attackers to crash.

The old stable distribution (woody) does not contain firebird2 packages.

For the stable distribution (sarge) this problem has been fixed in version 1.5.1-4sarge1.

For the unstable distribution (sid) this problem has been fixed in version 1.5.3.4870-3

We recommend that you upgrade your firebird2 packages.

..::firebird::..::debian::..

firebird in shutdown mode

Shutdown mode prevents everyone other than SYSDBA and the owner from
connecting.

This allows you to safely run metadata scripts etc and be sure no-one
else is connected while this happens.

gfix -shut f 300 aliasname

will terminate all connections after 5 minutes.

To allow logins again, you need to use

gfix -online

Here is the rest of the user's blog discovering this firebird "mode"


..::firebird::..

dbdesc 1.4.1 available

The author wrote

"Yesterday I’ve uploaded a small maintenance release of dbdesc.

These are the changes and bug fixes since version 1.4"

..::firebird::..

Why using Firebird? - Blog of the day

This statement is base on my experience, so maybe it's not true for you. Firebird version that I know for the first time is 1.0 version, since then I fall in love with Firebird (FB).

Read more on this blog

..::firebird::..

New Firebird ODBC Driver (V2.0.0129 and V1.3.0093)

Updated snapshots and builds of the Firebird ODBC Driver (V2.0.0129 and V1.3.0093) are available.

..::firebird::..::odbc::..

Sweet-talking Firebird with Delphi

Australian Delphi User Group Symposium - La Trobe University, Melbourne. Helen Borrie will be giving a session on: Sweet-talking Firebird with Delphi
Writing database applications for a Firebird (or InterBase) back-end is all about conversations. Applications request and Firebird responds. The better the request, the more sweetly the database engine will oblige. In this presentation, Helen will address various techniques that Delphi developers use and explain how rewarding a good understanding of Firebird's personality can be. More details at: ADUG Symposium

..::firebird::....::delphi::..

oracle licensing too expensive for oracle community site

from this thread on the orafaq forum:

“There is no way we would be able to raise the money required to buy a commercial Oracle license.”

“I believe the XE edition is a max of 2gig. htmldb would be free for that, but by the time you add htmldb overhead and users, I gotta think this site has way way more data than what is left out of the starting 2gig. … Standard Edition One would be the next option, at 5 grand per proc.”

maybe oracle will toss a free license their way, but this is a great case study on how useless oracle’s free offerings really are. (to contrast, of course, mysql’s free offering is fully-featured, with no artificial limitations. same with other truly free databases like firebird or the open-source versions of postgresql.)

» march 16 (thursday) 11:27pm
..::firebird::..::oracle::..::mysql::..::postgresql::..

Vulcan threading - needs to be fixed

INTRODUCTION

The point of this email is to call attention to what I think is the most critical outstanding element of the Vulcan project - the reliability of the threading and sharing model. This email is, I'm sure, going to devolve in unexpected ways; I'd ask that you read it carefully and think before replying, but please do reply... I believe the "Vulcan" part of the Firebird community very much needs the input of the rest of you all.

Vulcan currently has two conditionally defined threading models. More accurately, two models describing very different levels of sharing of data structures. They have very different qualities, and I believe neither one (in it's current form, at least) is what we ultimately must have.



SHARED_CACHE

If the symbol SHARED_CACHE is defined (the default currently) then Jim's original Vulcan model of fine-grained threading and data sharing is built. This model works generally on the assumption that most things should be shared if possible, and relatively light-weight locking mechanisms are employed to provide serialization/exclusivity when it is recognized that there is a shared data structure that must be made thread-safe.

Key benefits of this model include a more efficient memory footprint since there are very few redundant copies of data structures in memory. This is at the cost of increased synchronization primitive use; a read that does not actually have any conflicts with another thread must act as if a conflict is possible or imminent, and so there is a performance cost to most data access paths to protect the code from potential collision from other threads.



(NO) SHARED_CACHE

If the SHARED_CACHE symbol is not defined, then a much coarser level of sharing is implemented, more akin to the Classic model - each thread has it's own page cache, and so data structures resolved from the page cache are usually thread-private. When cache coherency between copies of the cache must be resolved, the same locking mechanisms are used as in SHARED_CACHE to support code to invalidate pages and force reloads.

Key benefits include a much faster read performance rate since far less data is shared. The cost of this is that write rates have a disproportionately negative impact on performance since updated pages must be invalidated in every connection's copy of the page cache. Worse, the memory foot print increases linearly with the number of connections and the per-connection page cache must therefore be kept relatively small, reducing the effectiveness of the cache.


THE BIG PROBLEM

The point of all this is that the biggest problem with the SHARED_CACHE model is that it does not work reliably under load. We can argue the merits of the test cases for a while, but putting Vulcan under significant load on a real multiprocessor system causes it to fail, and fail relatively quickly. Sometimes the failure is caused by undiscovered critical sections that need additional locking, but sometimes the failure is a deadlock because the relationship of critical sections wasn't completely predicted when the locks were added.

Based on my experience with the embedded usage scenario for Vulcan, I do not believe that SHARED_CACHE works reliably enough to actually use in its current form. Period.



BREAKING IT DOWN

There are quite a few issues that come from this. Here are many of my thoughts, in no specific order. When I say "we" in the following paragraphs, I mean the entire community of Firebird and Vulcan developers, not just my particular company.


1. The (NO)SHARED_CACHE model is not the long-term future, and only works in server environments where very large amounts of memory can be dedicated to the server and/or connection throttling and pooling mechanisms attempt to mitigate the scalability problem. It is a stop-gap that we introduced because we needed Vulcan to work in a timeframe that matches some of our product delivery dates.

2. The SHARED_CACHE model does not work, and is very very hard to debug. Clearly debugging by careful inspection can go a long way, but presumes that the inspector(s) know what they are looking for and/or understand the intended sharing model clearly. It also requires a lot of time and effort. SAS has thus far been unable to make this work ourselves, in part because the underlying lock manager appears to deadlock for reasons we have not been able to solve.

3. Testing multi-threaded code is difficult, and nearly impossible to do without the right hardware. I'll be the first to acknowledge that this is a significant problem in an open source community where many of the participants are either self-funded or trying to balance business objectives against community involvement and may not have the luxury of dedicating significant hardware to this. We need to find a practical way to resolve the test environment issues so that the core development team (at least) can regularly validate changes.

4. We need an agreed-upon test suite to validate the threading and sharing model. SAS uses a set of tests ("threadtest") that can be variably configured to control the number of simultaneous client connections and the work load. I think we've shared this already, but if not we'll be glad to make it available as a candidate test tool. More importantly, the community needs to agree on a test scenario that is considered a minimum requirement for this scenario that must pass before Vulcan can be considered ready for real users.

5. We cannot accept a system that works "for a while" or "for a few users" and then dies in a horrible way, hard to reproduce and putting data at risk. Its fine for a server to have limits, but those limits should be something that can be determined in advance or predicted at runtime so a thoughtful and reasonable response can be given to clients and tools. Declaring a test scenario unreasonable because it is hard to debug is not acceptable. Declaring a test case unreasonable and yet still guaranteeing that the server has a reasonable response is great.

6. There are volumes written about the difficulty of retro-fitting threading on code never written to support it. This is a very hard thing to do at all, and very very very hard to do well. My point is not to be a naysayer about Vulcan, but to make clear that we must understand that threading the Firebird code base is not simple to implement, test, or debug.

7. This is important because planning for the Vulcan/FB integration needs to take into account a realistic view of the state of Vulcan. If we think that Vulcan is nearly done as a 1.0 release (the timeline published during the conference called for a public release around now, if I recall) then a merger really becomes about the divergence in the code bases and reconciling them. If Vulcan really can't perform as it must to be used as the fundamental engine architecture of FB3, then the FB3 merger is about far more than resolving class name changes and updating the optimizer - it is about the guts of Vulcan and whether the sharing model really understands what is shared, when, and why.

8. Related to this has to be some kind of protocol for testing before a push. Threading issues are so hard to debug that they become exponentially harder to track down and repair the further they become buried in the CVS history records. If code is changed that could reasonable be expected to influence the thread-safety of the project, it must be tested against the approved benchmarks regularly and ideally before commit for large changes. It is bad enough when single threaded code is pushed without adequate validation, but it can be the death of a code base when those changes affect concurrency. You can take this any way you like, but too much of Vulcan has already been written without adequate testing. We are compounding the difficulty of retrofitting threading on a monolith by attempting to retrofit quality on the threading. Lots of this is due to the issues above involving availability of test environments and agreement on the requirements, but it's a problem
that will get worse - not better - as more folks get involved in modifying Vulcan.


WHAT DO WE NEED TO DO NEXT?

I don't want to start a flame war, and I sure don't want to retard forward progress on Vulcan. But I work with more than a few smart people, and our team couldn't make SHARED_CACHE work reliably after trying for quite a while, using the best tools and systems we had available. It is my sincere hope that this was largely because we at SAS are still learning the Firebird/Vulcan architecture, and if we had the kind of deep knowledge that many of you have, it would be a workable problem.

My point is that I think this is a big deal, and needs to be tackled before there is too much planning on a FB3 merger that will take away energy from the "does it really work" question. And that question needs independent validation, from parties other than either Jim or me.

The community needs a plan to tackle this, and some resources to do it.

1. A test scenario needs to be developed. There needs to be an assessment about a reasonable test server configuration, in terms of number of processors, CPU power, memory footprint, etc. And we need to understand the test case to be thrown at that server: number of clients, think time versus work time, read/write ratios, degree of sharing of indexes, tables, and databases, etc.

2. There needs to be a definition of a "successful" test case. This should include what must happen during the test run, and what must not happen during the test run.

3. There needs to be a thorough review of the test software itself. We don't want the test driver to contain implicit assumptions or limits that skew the test towards any particular outcome. The test should not be what just one company wants or needs, but should represent the community interest.

4. There needs to be a test configuration provided for an independent assessment, with an agreed upon build of the system and a validation that it meets the requirements set out in item #1 above.

5. The tests need to be published and the community needs to openly discuss what they mean and what influence they will have on FB3 planning and execution.



CONCLUSION

At the end of the day, SAS is just one of the members of this community - and a fledgling one at that. But we have some resources that we can use to help solve these problems, even though we do not have the full knowledge of Firebird internals.

More importantly, we think that the promise of Vulcan is valuable and good, but the current implementation is not getting the attention it needs to fulfill that promise. We can help, but only so far as our knowledge takes us. I believe that the community needs to pick up the issue of Vulcan's scalability and threading and make it the first priority of post-FB2 work. And we need to start with a dispassionate evaluation of what we have in Vulcan today.

I wrestled with whether this was a Firebird developer or architecture issue, but I have settled on the developer list - we have real problems with the real code already implemented, and need a plan of attack on how to fix it that is larger than assigning it to a core developer.

I look to the community for input on what to do next.


--
Tom Cole, Platform R&D, SAS Institute Inc.

sorry for slashdot-ing

My recent article, MySQL's response to Oracle's moves, was Slashdotted. We all know what that means.

Luckily I host in the US, with layeredtech. The site seemed to survive the onslaught, except for a few complaints that may have been about the stylesheets not loading.

http://www.greenman.co.za/b2evolution/blogs/index.php?p=267

..::firebird::..

Smart moves by MySQL AB

Now there seems to be a clear response. MySQL has hired former Firebird developer Jim Starkey and MySQL has a new CTO: Taneli Otala - read Kaj Arnö's interview with Taneli.

The final statement on this interview declares a clear goal: "Definitely. I want to be part of the team building the world's best database!". The times when MySQL targeted itself mainly to drive small and medium web based applications are definitely over!

The fact that MySQL is hireing new developers is just another indication that underlines that MySQL is moving forward towards the "big competitors".

read more on db4free blog

..::firebird::...:mysql::..::oracle::..

php5 and firebird 1.5 on debian or ubuntu

Darren wrote (in firebird-php list)

Decided to install php5 and firebird 1.5 on Debain
very easy

do the following edit

# vi /etc/apt/sources.list

add these two lines to the file

deb http://people.debian.org/~dexter php5 sarge
deb-src http://people.debian.org/~dexter php5 sarge

save and exit :wq

then do a
# apt-get update

then install all the modules you need
use this command to check whats available
#apt-cache search php5

then install what you want
#apt-get install php5 php5.0-firebird

it installs a few things like apache etc if you havent already got it
installed.

then restart apache
/etc/init.d/apache2 start

you might want to remove php4 beforehand if you have it installed

it seems to work fine big thank you to the guy who maintains this
package! if you are on here. Debian ROCKS.

..::firebird::..::php::..::debian::..::ubuntu::..::php5::..

Firebird logo - remineds me of mortalkombat.

Quote of the day " Also I love the logo, remineds me of mortalkombat."
..::firebird::..

firebird in 60 seconds

60 seconds to know what is firebird
www.firebirdnews.org/docs/fb2min.html
..::firebird::..