SPEAKER PAPER(S)

Paolo Angeretti

No profile

vTiger

CRM - Customer Relationship Management, a firebird based solution.
SPEAKER PAPER(S)

Alessandro Arrigoni

No profile

Sw-ing: Designing and implementing a datawarehouse on Firebird

[undefined]
SPEAKER PAPER(S)

Milan Babuskov

Education:
2001 - B.Sc. In Business Information System Engineering
2003 - M.Sc. In Internet Technology at University of Belgrade

Started to program as a 14 year old, making simple games in BASIC and later assembler on Motorola's 680x0 series CPUs. Programmed in C, Perl and Java. Now writing the code in C++ and PHP.

Started to work with Informix at University, after few experiments with Paradox, MySQL and MSSQL, finally switched to Firebird. Starting from 2002, developing various software using Firebird, PHP and Apache.

Developer of open source FBExport and FBCopy tools, for manipulation of data in Firebird databases. In 2003, started a project to build a lightweight cross-platform graphical administration tool for Firebird. The project was later named FlameRobin, and is built entirely with open source tools and libraries.

Hobbies include playing basketball and writing cross-platform computer games, some of them very popular (Njam has over 36000 downloads on sf.net):

Born in 1977. Still single (that should change before the conference though). Live and work in Subotica, Serbia. Currently employed at large ISP company.

 

Firebird on Linux - advanced topics

- choosing a kernel for FB system (2.4 or 2.6, when to pick which one) - selecting a filesystem (ext3, reiser, imporance of ordered writes, resistance to power failures, etc.) - partitioning disk(s) - swap, raw devices, partition order, RAID, LVM - fine tuning the filesystem (balance between speed and safety, flags for mounting, etc.) - optimizing network stack - changing default system limits - debugging Firebird

Firebird on Linux - basics

- choosing Linux distribution - selection of Firebird architecture ( superserver, classic, embedded) - installation (whether to pick distribution packages or FB official packages, NPTL builds explained) - administration tools (command line, X11, web) - development tools and libraries (command line, X11, web)

SPEAKER PAPER(S)

Carlos Cantu

Carlos H. Cantu maintains a major Firebird Brazilian dedicated portal (www.firebase.com.br). He is the author of "Firebird Essencial" book and one of the owners of the DB FreeMagazine (www.dbfreemagazine.com.br). He had written more than 30 Firebird articles for Delphi and DB related brazilian magazines, is the president of DUG-BR (Delphi Users Group Brazil) and is the organizer of the Firebird Developers Day conference (www.FirebirdDevelopersDay.com.br)

Updating Database structures

For those who have several customers sharing the same application, keeping databases structures up to date is essential to make sure that the database and the application are in sync. This talk will provide one example (using Delphi) of implementing a way to update database structures automatically up to the most recent level required to run that application, by way of SQL scripts. Some cautions regarding connected users, transactions and possible crashes during the metadata update will be discussed as well.

Know what is happening in your database and server

Many developers and DBAs have problems to identify what is happening on the FB server in specific moments, usually when performance degradation is noticed. Fortunately, Firebird 2.1 bring to us the monitoring tables, allowing the developers to know what is going on in a specific database. Also, with he help of some third party tools, it is possible to monitor the FB server activity, and detect possible bottlenecks. This session will present the monitoring tables and some tools that can help you to monitor database and server.

SPEAKER PAPER(S)

Marco Cantù

Marco is the author of the best-selling Mastering Delphi series and of the recent Delphi 2007 Handbook and Essential Pascal. Beside writing books on Delphi, he is a trainer and consultant in Delphi and also in Web 2.0 development technologies, from Web Services to JavaScript, from REST to AJAX.

Marco has spoken at developers' conferences in 4 continents.

Delphi, DBExpress e Firebird

Introduzione a dbExpress e alle altre principali alternative per connettersi al database Firebird da applicazioni Delphi. Oltre a dbExpres si parlerà di IBX, UIB, IBO e altro ancora. Si accennerà anche al possibile ruole del componente ClientDataSet nella realizzazione di architetture Delphi moderne.

Delphi and Firebird

An in-depth analysis of the latest version of dbExpress, including the low-level DBX class, the new drivers model, the remoting architecture, the delegate drivers, and many other technical details of dbExpress IV, the "complete rewrite" of the dbExpress architecture in Delphi 2007.

Towards a REST Architecture with Delphi and Firebird

Developers are generally inclined to use PHP, Ruby, or other scripting languages when creating a REST/web services front and to their database. However, when using Delphi, you can gain advantage from some extra speed and in-memory processing power, caching capabilities, access to XSLT transformation technologies and much more. This presentation provides an outline, a skeleton, or a possible Delphi-native REST architecture with an AJAX front end, offering the starting point of the development of an actual framework.

SPEAKER PAPER(S)

Sandro Carrara

Profilo non disponibile

GO: Gestionale Open

Gestionale Open: il gestionale dalla parte dell'utente.

SPEAKER PAPER(S)

Jiri Cincura

Jiri Cincura is a .NET developer, working mainly as a freelancer. He specializes in projects involving business layer and database design.

Jiri has been a contributor to the FirebirdClient ­ ADO.NET Data Provider for some years and, since January 2008, he has led this project.

Jiri can be contacted by emailing jiri AT x2develop DOT com.

Developing Firebird apps for pocketpc/smartphone clients

In this presentation I would like to cover developing application for PocketPCs/Smartphones that are using Firebird database as storage. I’ll show you what you need to have for creating these applications. Limitations of Firebird usage on these devices and also some tips for creating stable applications. I’ll also show usage of detached DataSets and/or objects to work in offline on PDA and also usage of MS Sync Framework to show synchronization between PDA and FB server (even if the application will be closed and reopened) and also to allow work offline and easily synchronize changes when became back online.

Using embedded Firebird with .NET

Because Embedded Firebird is neat piece of software and it is popular across kinds of developers, this session will cover usage of it in .NET. I’ll show you what you need to do to use it. The drawbacks and problems you can encounter using it. I’ll cover creating environment for developing and debugging the application on developer’s machine and deployment of the application to the customer. I’ll be also showing some special cases for ASP.NET hosting, where you need to take care some simple issues. Also differences between 64-bit and 32-bit machines. The migration from server to embedded and vice versa will be covered too.

SPEAKER PAPER(S)

Pavel Cisar

Pavel has worked in various IT fields for about 20 years. During his career, he has worked on (too) many different projects, from operating system implementation, to automation of technology processes, to games, to various ERP systems.

For many years, his preferred programming language was Pascal but, in the last few years, he has been moving more and more toward Python.

Thanks to Pavel's public activities around Delphi, InterBase and Open Source, he eventually got a job at the Czech branch of Borland, where he worked from 1999-2001 as a tech. support engineer for Delphi, Kylix and InterBase. He left Borland to continue his deep involvement with the Firebird Project and, in the Autumn of 2001, joined IBPhoenix. Additionally, he is responsible for developing the QA procedures and test suites for Firebird, work which is assisted by regular grants from the Firebird Foundation.

Pavel is a regular speaker at Delphi and database-related conferences and events in Czech Republic. He wrote a book in Czech about Firebird and InterBase, and is the author of many articles about Firebird and databases in general for various magazines.

Pavel lives here in Prague. He is married with two children (girl and boy). In his free time, he enjoys family life and reading sci-fi books.

Introduction to development with Firebird and Python

Python is a dynamic object-oriented programming language available on many platforms that can be used for many kinds of software development. It offers strong support for integration with other languages and tools, comes with extensive standard libraries, and can be learned in a few days. This session will introduce you to the realm of software development with Firebird and Python, and show you some available options how you can write data manipulation, data entry, reporting and web applications for Firebird in Python quickly and easily. Requirements: Knowledge of Python is not necessary, but it's an advantage.

Working with Firebird in Python

In this session you'll learn how use Firebird driver for Python, what's the future of this driver and what other Python connectivity packages and higher level libraries you can use with Firebird including examples of their use. Requirements: Knowledge of Python is not necessary, but it's an advantage.

SPEAKER PAPER(S)

Fabio Codebue

Fabio has worked as a consultant since 1991, originally under the BigM umbrella. After several years developing with various languages (RPG, Visual Basic, Clipper, Foxpro, Delphi) working on ERP solutions with some different RDBMS, and especially Firebird since its original version, he created his own company, P-Soft (www.p-soft.biz).

During recent years he has spent a lot of his time working with open source projects (Mambo/Joomla, myDMS, Hylafax, vTiger9) and he joined the Firebird Foundation.

In 2007 he began the the Firebird Italian Community website (www.firebirdsql.it) and helped to convert the biggest Italian open source ERP, GestionaleOpen (www.gestionaleopen.org), to use the Firebird RDBMS natively.

Firebird: Database per sysdba - base

Task amministrativi, Backup, Restore, Indici, data import ed export.

Firebird: Database per sysdba - avanzato

Database recovery, maintenance, configurazione.

SPEAKER PAPER(S)

Andrea Magni

Andrea is an italian software developer and IT consultant.

Born in 1982, he is a Delphi developer since Delphi 2 times (but worked a bit also with D1). After attending scientific high school, he tooks a master degree in Computer Engineering in 2007 at Politecnico di Milano.

Mainly as a freelancer, he worked on several projects involving Delphi, some of them with the use of Firebird as database server. During the last two years he has been working with Ethea, the software development company founded by Nando Dessena and other Delphi and Firebird experts, as external consultant.

Since 2003 he is a member of Delphi&Dintorni's committee, an italian Delphi user group hosted and driven by Marco Cantù. In his spare time, he likes to read and to travel (possibly with his motorbike) and has a passion for photography.

Database Triggers

[No outline] 

CTE, Execute Block

[No outline]

SPEAKER PAPER(S)

Bjoern Reimer

Björn works as DBA at the RRZE at the University of Erlangen-Nuremberg, Germany, and as an independent software developer building applications for small engineering companies. He has worked with Firebird since the first release on Windows, Solaris and Linux.

Replication for a high availability infrastructure

Practical examples how to replicate firebird databases on several physical machines to get a high availability infrastructure and to share load of machines. The session will show, how to build a database, which is suitable for replication, how to implement the replication with different tools and how to prepare a client software to be able to access more than one server.

SPEAKER PAPER(S)

Frank Ingermann

Frank Ingermann is a 40-something Delphi/OOP developer from Aachen, Germany. He works as chief developer and system designer for Klar Partner AG, a small software company specializing in software for formulation development and manufacturing in the pharmaceutical and cosmetics industry.

Frank started off with InterBase 5.6 and has been using Firebird from "day 0". He was a founding member of the Firebird Foundation and was on its original committee.

Frank's hobbies are DJ-ing and music in general, cycling and kite-flying.

Fb{Ref?}Doc - the Firebird Documentation project

The Firebird Documentation project: Where it is and where it could/should go (Follow-up to last year's doc session) + an introduction to DocBook - current state of the Fb Documentation: what we have and what is lacking - different ways of how to contribute to the Documentation project - DocBook: a hands-on DocBook primer - overall concept - Pro's and Con's of DocBook - setting up a DocBook build environment and getting it to work - editing DocBook files and building PDFs + HTML output - writing docs in different languages

Managing recursive data structures (trees) with Firebird

[Part 1:] Basics: - What is a "tree"? (trees, limbs, branches, nodes,...) - "data topology": - does OWN or REFERENCE [all of]|[parts of] ?? - "master refs" in a table vs. separating data structure from data contents - monomorphic vs. polymorphic tree structures (single-table vs. multi-table) - Anchors and Depth of Recursion, limits - "treewalking": tree types (B/W, Bayer...), balanced (AVL) vs. unbalanced search trees, orders of traversion (loading) and persistance (storing) Storage: - Ways to store and load recursive structures - top-down, xref, bottom-up recursion (or: where to store the "pointers") - classic slave-to-master links (_ID, loading methods, "lazy" loads) - masters keeping track of their [slaves|childs] (store list of child id's in M) - Nested Sets [+ other "exotics"?] How-To in Fb: Exploring the Firebird possibilities - client-side "recursion": repeated iterative queries (rootnode: "gimme all childs of node into ", for every childnode X of : "gimme all childs of node into " for every childnode Z of : "gimme all...") - server-side recursion: recursive Storedprocs (limits, caveats, exec stmt) - server-side recursion "NG (next generation)" -> Fb2.1": CTEs, recursive queries [Part 2:] "The completely de-normalized database" or how to set up a system with {any} complexity with just a two (2!) tables database - using db _data_ to feed your application's _metadata_ "attribute-oriented programming" or How to avoid "CustomerField<1>".."CustomerField" designs strategies for a "polymorphic", flexible db design - handling all that with Firebird SQL

SPEAKER PAPER(S)

Lucas Franzen

University: Study of Sociology and Poltiical Science, programming since 1990, Unix-systems. Working with Delphi from the mid nineties on (starting with Delphi 1 and IB4.0), own company since 2001, developing and programming of logistics software (transport & export of goods, freiight calculations, etc.).

Firebird Foundation member since the very beginning and recognised as a highly fitting auctioneer for the famous Mad Auction.

Living in Freiburg, Black Forest (Germany), married, with two sons.

Stored procedures

Stored procedures how and when to use, tricks and tips, black-box, etc.

Firebird in real time applications

Examples / demos on how we work with Firbird in realtime time-critical applications

MAD AUCTION

[No outline]

SPEAKER PAPER(S)

Luca Cargnelutti

No profile

SQL e Firebird - base

Mini corso SQL con firebird. L'utilizzo con i principali tool di amministrazione, dalla riga di comando. Particolarità delle stored procedure e dei trigger.

Firebird: Migliorare e ottimizzare le prestazioni

Analisi dei file di configurazione, tecniche e soluzione per il tuning del database

SPEAKER PAPER(S)

Stefano Gusparo

No profile

Firebird: Database for sysdba - web

Installazione, configurazione di un server web per l'utilizzo di firebird con windows/linux come database con apache

ISAPI

Tool per l'interfacciamento del database per l'elaborazione, esposizione dell'informazione in modo trasparente ed efficace.

SPEAKER PAPER(S)

Fikret Hasovic

Started working with Delphi in 1995 (at University, department for mathematics). First commercial work was in 1997, working as a VB programmer and using Informix as DB backend. In 1998 he moved to new company, SoftGroup d.o.o., where he has worked on the development of various projects using Delphi, Paradox and InterBase.

In 2001 worked for Zrcalo d.o.o. (Slovenian software company) on Banking software development. After 3 months joined USAID Parsons project (Parsons Delaware Inc), developing a complete IT system solution using Delphi and InterBase 6.0.

In 2002 back in Softgroup d.o.o. where he worked on new design for business information systems.

In mid 2002 joined USAID TAMP Project (Development Alternatives, Inc.), working as Senior Programmer and Computer Systems Engineer on design and development of Tax system software for Bosnia and Herzegovina. We are using n-tier concepts (AstaIO and then migrated to kbmMW), creating client applications using Delphi and kbmMW Application Servers (Delphi based) connecting to Firebird 1.5.2 CS on SuSE linux. He migrated these AppServers and LoadBalancing Servers to Linux using Kylix. Client applications connect to AppServers using Wireless connections (we cover the complete country with that system).

Recently he published an article about Firebird in Bosnian IT magazine INFO (www.info.ba), and wrote a Delphi 2005 article (that will be published in next issue). He is a contributor to OpenSource project JediVCS (Version Control System based on FreeVCS sources), and has also developed the collation driver for Bosnian language (Win1250 charset, Collation name BS_BA) (Firebird 2) commited to CVS few weeks ago by Adriano. He is also a member of Firebird Foundation Committee.

Migrating from MSSQL and mySQL to Firebird

Which are best tools for migration, how can we used them to migrate data structure. data and metadata. Using some migration scenario we will analize possible problems.   Practical example of migration

 

Service Oriented Architecture with Firebird

What is a Service? This session will show in deep what's a Service-Oriented Architecture (SOA) and which are benefits of this model. We will see some SOA examples using kbmMW framework:
          - Building an application server  
          - Building an n-tier client    

SPEAKER PAPER(S)

Stefan Heymann

Stefan Heymann is founder and manager of Consic Software Engineering in Germany. He has more than 20 years of experience in the development of database, network and web applications with Turbo/Borland Pascal and Delphi and is the author of the destructor.de Open Source XML parser. He has been a speaker on topics like XML, Delphi and InterBase/Firebird for a few years.

Unicode and Firebird

This session will show you how to use Unicode, Character Sets and Collations in Firebird. We will also take a look at the new Character Set and Collation features of Firebird 2.1.

SPEAKER PAPER(S)

Vladyslav Khorsun

Vlad studied in the Faculty of Applied Mathematics at Dniepropetrovsk State University and received his Diploma in 1996. He has been in love with C++ since his second course, so his first C++ program was written sometime in 1992. He had been working with Borland products from 1991-on and remembers Turbo Pascal 5.0, Turbo C++ 1.0, Turbo Prolog and Turbo Assember as well. He worked with Delphi since its beginning and confesses that he hates Visual Basic!

Vlad's initial database experience happened at university (FoxPro 2.x). InterBase (v.5.1) came into his life around 1997. He started using Firebird when it reached some stability during the v0.9.x betas.

Vlad joined the Firebird development team in 2003 and soon established himself as a highly valuable core developer. His work is assisted by regular grants from the Firebird Foundation.

Vlad lives in Dneipropetrovsk with his wife and their young son.

Common Table Expressions : tutorial

Category : for developers Skills : beginner to intermediate Firebird 2.1 introduced support of great SQL feature - Common Table Expressions. Will learn what is it, how it can be used and what tasks it can help to solve

SQL enhancements in FB 2.5

Category : for developers Skills : beginner to intermediate Will learn in detail some new major features and improvements introduced by FB 2.5 in its SQL language support : autonomous transactions, regular expressions, queries against external databases etc

SPEAKER PAPER(S)

Dmitri Kouzmenko

Started to work with computers using home-made based on Z8080 processor in 1986. Up to 1991 learned assembler, Basic, Turbo Pascal, MUMPS, Prolog and some other less common programming languages.

Most interested in database access methods, database programming and modeling. In 1994 started to work with InterBase and, within 3 years, established a name as an InterBase consultant in Russia.

To the present, organizes Firebird and InterBase training and a website for InterBase users.

In 2002 created his own company, iBase.ru, that is focused on supporting people for all InterBase, Firebird and Yaffil versions. Initiated Yaffil to be a saleable product in Russia.

Author of many articles about Firebird's MGA, transactions and other internal specifics and of the IBAnalyst tools.

Transactions In Your Applications

Firebird has the most rich mechanism of transactions management which enables very flexible work with the data in the applications. This session will cover practical usage of transactions in real-world applications and give you understanding of transaction life time: how to choose right isolation levels and other parameters, how to use read and write transactions to avoid unnecessary usage of server resources and improve performance, how to explicitly lock records if it needed. Tips about when and why to use savepoints and error handling blocks. You will know ready-to-use patterns for using transactions: best choice for read-, write and update operations, optimal transactions' parameters for bulk operations and many other things.

Practical Guide to Garbage Collection

Firebird has a multi-version record architecture, and garbage collection is an important part of records life cycle, which affects performance of database applications, maintenance of databases and make database development special. At this session you will understand what is garbage and its meaning in the records life cycle, how it occurs and how it is swept in different versions of Firebird. Why your database size is growing fast, how to avoid periodically slowness, how to recognize and estimate garbage, how to improve performance and avoid related problems - this is a short list of questions answers to those you will know at this session.

SPEAKER PAPER(S)

Philippe Makowski

Philippe Makowski is the vice-president of the Firebird Foundation VP and a member of Firebird's QA team. He joined the Firebird project as soon as it started, initially to translate documentation into French. Now, he is now mainly doing QA testing on Windows,Linux and MacOsX platforms and support, having joined IBPhoenix as a support consultant and trainer in 2007.

Phiippe helped to build the Firebird RPM packages for Mandriva and OpenSuse and he is involved in the French Linux and Free software community as the member of the SolutionLinux exhibition program committee in charge of the RDBMS track.

Firebird, tools and Linux distribution integration

A RDBMS, even if it is good, is nothing if there is no thirid-party software integrated with it. Thanks to the Firebird Project, Firebird has good .NET and Java drivers. Thanks to the efforts of some people, Firebird is today incorporated into the major Linux distributions.

But often, when you want to use free software, such as the full-text SQL search engine Sphinxsearch, there is no Firebird driver for it, or the driver is not as good as it should be (the Ruby driver for example).

This meeting is to share experiences, I will try to show the current coverage - Linux distributions, tools like Mondrian, etc. - and let's see how we can improve the situation.

Perhaps we need to work on a "light" Firebird API that is easy to understand and manage, as an aid to integration of Firebird with other tools.

I invite you to come, share your experience and let's explore together how we can improve the situation.

CLOSING SESSION

[No outline]

OPENING SESSION (SESSIONE DI APERTURA)

[No outline]

CLOSING SESSION

[No outline]

SPEAKER PAPER(S)

Umberto Masotti

Profilo non disponibile

Php e Firebird - base

Programmare in php con Firebird: base

Php e Firebird - avanzato

Programmare in php con Firebird: avanzato

Delphi4php e Firebird

Delphi for PHP: Esempi di programmazione

SPEAKER PAPER(S)

Alex Peshkov

University: Moscow Physical-Technical Institute. Alex Peshkov has been programming since 1986 on Unix, DOS and Windows.

Since 1991 Alex has worked for Information Systems Ltd., Yaroslavl, Russia. In 1993-1994 he developed a C++ library to access DBF files, with support for distributed data caching, providing (on average) 15-25 times faster access to data compared with the DOS leader at the time, FoxProLN.

Alex has worked with Interbase/Firebird since 2000. In Firebird he implemented the EXECUTE STATEMENT syntax in PSQL and fixed a lot of bugs in the old code. With grant support from the Firebird Foundation he is responsible for Firebird's security, including closure of vulnerabilities to DoS attacks and other more specific attacks, user authentication, etc. He also builds binary packages for Linux.

Alex lives in Yaroslavl with his wife and their two children and enjoys walking his dogs and working in the garden.

Security in Firebird: 2.1, 2.5, 3.0

Session will contain brief review of firebird history in aspect of security state of codebase, followed by detailed description of security-related changes in new versions: 2.1 (provided it does not become "history" dure to 2.5 release :))) ), 2.5 and plans for 3.0.

SPEAKER PAPER(S)

Markus Pinkert

Markus works for the database department of the computing center (RRZE) at the Friedrich-Alexander-University in Erlangen, Germany, which is responsible for providing database services for all departments of the university. Firebird is one of the major database systems there.

Markus graduated at Dresden in network and multimedia technologies with emphasis on web application development. He is responsible for the facility management system and modules of the finance system of the university. A recent project of his is a web application based upon a new Perl framework called Hyper. Hyper's approach differs from other modern web-based development systems, being focused on implementing maintainable workflows and business logic rather than providing tools for rapid application development.

Separating web development from database logic

The development of web applications today is done using highly advanced frameworks for the ever same job of providing a frontend over internet for masses of data in a backend data base. It has become common practice to divide the application into the data base model, the presentation part and the bussiness logic. This practice is known as MVC - Model-View-Controller. On the over hand side for an application accessible all over the internet security is a very important part. Every user input needs to be considered as a possible attempt to underrun security. At this point the data base model often gets mixed up with the bussiness logic. An alteration in the data type definition causes serveral alterations on the program code of the web application. In my talk I will present an approach to leave the data base model where it belongs - in the data base. As an example I will use the Hyper-Workflow-Engine, an web development framework written in Perl. After a brief introduction in actual web development and into the work with the Hyper-Workflow-Engine I will show a way of seperating data field validation from the actual program code. I will show possible attempts and several issues that can't be solved with such an approach. By the way I will give some neccessary thoughts on web security and web development in general.

SPEAKER PAPER(S)

Marius Popa

Marius Popa lives and works in Targu Mures, Romania, where he is employed at reea.net as a programmer and systems administrator. In his free time, Marius he does Firebird/Flamerobin advocacy.

 

Marius started programming in high school, playing with TurboPascal under DOS. He first real job was at wokadat.ro where he had first contact with Interbase/Firebird and Delphi. Impressed with Firebird's power and simplicity, Marius learned about its inner workings from documentation and by playing with the isql command-line utility. One day he installed Red Hat 6.0 on his workstation and started to learn Perl, which subsequently to a job at Netsoft.ro, working with Firebird, Perl, Delphi and MySQL, thus escapring the Windows-only world learning more about Linux, PHP and Perl.

For a short period Marius worked for a Microsoft partner (infopulse.ro) where he learned C# and did some DCOM/COM+ programming in Delphi and C++ and some Javascript.

Since 2004, at reea.net, Marius has been developing Web applications in PHP and Perl for a range of small and medium sized businesses, administering both hosting and internal servers, supporting various open source technologies such as Tomcat, Apache, Sendmail, qmail and postfix and using multiple environments, including Perl, Bash, PHP, MySQL, Postgresql, OpenLDAP, Mono and, of course, Firebird.

Marius' hobbies include open source programming (c++,php,oopascal), traveling , Firebird/Linux advocacy, biking.

Ultimate Vmware Appliance - Ubuntu and Firebird

Ultimate Vmware Appliance - Ubuntu and firebird with all tools needed for firebird development and http://www.vmware.com/appliances/directory/339 http://www.vmware.com/appliances/directory/276 also Firebird Live CD based on Ubuntu applications demo (flamerobin + phpbb+ibwebadmin2.0+lazarus ) starting point will be http://flamerobin.blogspot.com/2007/09/creating-flamerobinfirebird-livecd-with.html

Fire in The Lamp - FireTube an example for scaling Firebird on web2.0

General Php Frameworks presentation with an few examples like cake php , zend framework and then implementation for an real application youtube clone created with cakephp and based on ffmpeg+mencoder php classes + lighttpd . Here i will show basic architecture and scaling layers for an web2.0 application

SPEAKER PAPER(S)

Ivan Prenosil

After finishing university studies in Electronics, Ivan developed microcomputer hardware for controlling robotic manipulators and other devices. That was followed by many years developing editorial systems and full-text databases for news agencies. For the past two years Ivan has been working for a company developing a point-of-sale system for pharmacies.

Ivan started working with Delphi/InterBase 12 years ago, but has used other programming languages for much longer.

10 ways to backup FB database

Category: administration Technical skill: no special knowledges required * 10 ways to backup FB database. * This session will show different methods for making backup of Firebird databases, and compare their advantages/disadvantages.

Query Optimization: How to Speed up Count(*)

This session has several goals - to explain reasons why COUNT(*) function is slow on big tables, to show several methods how it could be optimized, to demonsrate everything on examples (using sql scripts run during presentation), and to explain results obtained by these scripts (i.e. do performance analysis).

SPEAKER PAPER(S)

Paul Reeves

Paul Reeves has been working for IBPhoenix, doing technical support, since not long after the Firebird project started. He has also been heavily involved with the Firebird Project since the beginning.

Pauls says he likes things that are easy to use and reliable, and remembers that it was almost impossible to build Firebird easily under Windows when we first got the code. He had a go at fixing that, and then started work on the installation issues.

Since then he has devoted a lot of time making sure that the process of building from source through to deploying on any version of Windows would 'just work'.

Installing Firebird with your application under Windows

Installing Firebird with your application under Windows Audience - Developers and Administrators Level - Beginners to Intermediate Installing Firebird under Windows has become increasing complex. This is partly due to Firebird's own evolution. It is also caused by the changing requirements of Microsoft's operating systems. This talk will look at how installation requirements have changed and how the Firebird installer deals with them. It will demonstrate some of the tricks the binary installer uses to solve these problems and how you can make use of them in deploying your own applications.

SPEAKER PAPER(S)

Martijn Tonies

Martijn got his first database knowledge when working with Oracle during his day time job and discovered InterBase soon after. A nice small database engine, capable of great things. He was very interested in what happened after InterBase became open source and in close contact with the Firebird project since the earliest days. Martijn has been using InterBase and Firebird ever since and continues to develop for and with InterBase and Firebird.

As the founder of Upscene Productions, a small company he started to develop database developer applications, he works with several database engines each day and knows about the differences, problems and annoyances a database developer has to work with.

Martijn is from the south of The Netherlands, Europe and enjoys (online) computer games, animals, being outside and working on his old-timer truck during the scarce spare hours.

The Firebird System Tables

On how to get metadata information from the system tables and what can be updated and so on. Includes the latest on Firebird 2.1.

Firebird Stored Procedures in Depth

A more advanced presentation on Stored Procedures with several "gotchas" and tricks.

SPEAKER PAPER(S)

Dmitry Yemanov

Dmitry Yemanov is a core developer in the Firebird Project and is coordinator of development. He started programming with Borland C++ in 1996 (various utilities) and then switched to Delphi and databases in 1998, where he was developing distributed information systems for Russian Ministry of Defence. InterBase 4.2 was his first experience in the database world. After changing a few jobs and Delphi versions, in 2000 Dmitry became the lead developer in a small company developing accounting and HR software. Originally, the company used InterBase 6.0 OE but switched to Firebird as soon as it arrived. They used Oracle for their high-end applications.

During that time, Dmitry was an active reader of Firebird related news and mailing lists. It wasn't long before he started digging in the Firebird code and he has never returned to normal. Starting with version 1.5, he was an active Firebird developer and a release manager. In 2005 he gave up his day job and, to this day, devotes his working life entirely to Firebird, assisted by regular grants from the Firebird Foundation.

Dmitry lives in Penza, Russia.

Firebird Development in 2008/2009

We'll be talking about multi-threading improvements as the key goal of the current development. You'll see what achievements in this regard the project has made during this year in version 2.5 and what is left to do for version 3.0. Other features intended for version 3.0 will be also mentioned, including the development cooperation with SAS and RedSoft and how it affects the mainstream development. Finally, as always, an updated roadmap will be presented to public.

Firebird 2.5 Architecture

This session describes the architectural changes done in the v2.5 release. It introduces SuperClassic as a new architecture that combines features from both Classic and SuperServer and is targeted at highly loaded applications, primarily on 64-bit hosts. All the features of the new architecture will be explained in details, as well as new technological abilities of Classic and SuperServer.