Category: Worth Reading

Content not direct related to FB, but interesting reading.

FBCon 08 – 25-26-27 september – Bergamo – Italy

Leave a comment
You CAN’T miss FBCon 08 – 6th Firebird International Conference that will be held in Bergamo from 25 to 27 september. Conference will be from thursday september 25 till saturday Every day have a special theme with best italian and worldwide firebird-world expert!
Here some of our sessions, for a detail go to www.firebirdconference.net:

Italian sessions :

  • CTE e query ricorsive
  • Database per sysdba – avanzato
  • Database per sysdba – base
  • Database per sysdba – web
  • Delphi, DBExpress e Firebird
  • delphi4php e Firebird
  • GO: Gestionale Open
  • ISAPI
  • Php e Firebird
  • SQL and Firebird
  • SQL enhancements in FB 2.5
  • Sw-ing
  • vTiger

english sessions:

  • 10 ways to backup FB database
  • Common Table Expressions : tutorial
  • Delphi and Firebird
  • Developing Firebird apps for pocketpc/smartphone clients
  • Execute block e trigger (database)
  • Fb{Ref?}Doc – the Firebird Documentation project
  • Fire in The Lamp – FireTube an example for scaling Firebird on web2.0
  • Firebird 2.5 Architecture
  • Firebird Development in 2008/2009
  • Firebird in real time applications
  • Firebird on Linux – advanced topics
  • Firebird on Linux – basics
  • Firebird Stored Procedures in Depth
  • Firebird, tools and Linux distribution integration
  • Installing Firebird with your application under Windows
  • Introduction to development with Firebird and Python
  • Know what is happening in your database and server
  • Managing recursive data structures (trees) with Firebird
  • Migrating from MSSQL and mySQL to Firebird
  • Practical Guide to the Garbage Collection
  • Query optimization – how to speed up COUNT(*) function
  • Replication for a high availability infrastructure
  • Security in Firebird: 2.1, 2.5, 3.0
  • Separating web development from database logic
  • Service Oriented Architecture with Firebird
  • SQL: Migliorare e ottimizzare le prestazioni
  • Stored procedures
  • The Firebird System Tables
  • Towards a REST architecture with Delphi and Firebird
  • Transactions In Your Applications
  • Ultimate Vmware Appliance – Ubuntu and Firebird
  • Updating Database structures
  • Using embedded Firebird with .NET
  • Working with Firebird in Python

To REGISTER go to www.firebirdconference.net

Also note that 24-th September at the same place, before the Conference, there will be FREE IBSurgeon seminar:

  • Introduction
  • Firebird database recovery and protection against corruptions
  • How to find and solve performance problem in Firebird with IBSurgeon products
  • Replication with IBReplicator
  • Using dbFile

p.s. I will be there. My wife told me that I must taste native pizza, pasta, cappuchino, etc.

Posted by Dmitri Kuzmenko at 10:06 PM

Primary Database in Use – Firebird ?

Leave a comment

Survey Results – Primary Database in Use on LewisC’s An Expert’s Guide To Oracle Technology

I’m starting to gather the data from my survey. When I get all the data gathered, I will post it as a downloadable file. Until then, I will post some summary data. This data shows the current PRIMARY database in use at the respondents companies. I find the data suspect and you’ll see why. This data has not been cleaned and duplicate IP addresses have not been removed. This is totally raw data and should remain suspect until after cleansing. Still, it is interesting.

Primary Database

Percentage

Respondents

Oracle

20.38%

65

DB2

5.96%

19

SQL Server

8.78%

28

MySQL

25.39%

81

Teradata

0.31%

1

Ingres

0.00%

0

Postgres

7.21%

23

SimpleDB

0.00%

0

Firebird

25.71%

82

LucidDB

0.00%

0

Vetica

0.00%

0

Sybase

0.63%

2

Netezza

0.31%

1

Access

0.31%

1

Excel

0.63%

2

xBase

0.63%

2

ADABAS

0.00%

0

Alpha 5

0.00%

0

Filemaker

0.00%

0

IMS

0.00%

0

Informix

0.63%

2

SQLite

0.63%

2

Paradox

0.00%

0

Progress

0.00%

0

Other

2.51%

8

I have serious doubts that Firebird is primary database at 25.71% of the respondents. I think I may find some duplicate IP Addresses with that answer. I’m not really surprised at the remainder of the answers though.

I also posted a summary of countries who answered and a few questions on open source software usage.

LewisC

Multi-file Database ?

Leave a comment

Some last database repair cases we did were with multi-file databases. Interesting, that latest InterBase and Firebird versions was used, and also file system for the storage was NTFS, not FAT32 and FAT16. But, the databases was created and maintained using 1 gigabyte files.

[ED: seems that is better to put the database  on an good file system and in an single file ]

Random selection, with a bias ..

Leave a comment

Say you want to randomly select your employee of the month, but not so randomly, better, you’d like to give your best employees a bigger chance to be selected based on their rating.

This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the sense of this.

1 … 52 53 54 55 56 … 84