Posts Tagged “firebird”:

Node.js Firebird Drivers

I'm pleased to announce the initial release of my Firebird drivers projects for Node.js. - You said projects? - Yes! The work is split in three projects, as described below. # node-firebird-driver-native Firebird high-level native client for Node.js / TypeScript ([github](https://github.com/asfernandes/node-firebird-driver-native) / [npm](https://www.npmjs.com/package/node-firebird-driver-native)) This is the more interesting project for... [Read More]

Node.js Firebird API

I started a personal (*) project to create a Node.js Firebird driver based on the FB 3 OO API. (*) A personal project because Firebird admins is not interested in this technology. So bad! Why another driver if there are others? Althrough it's a manual work for now as I... [Read More]

Funny Firebird operators

Here is a table with Firebird operators you probably don't know that exist: |Funny |Standard equivalent | |--------|---------------------| |`x ! y`|`not (x > y)` | |`x ^> y`|`not (x > y)` | |`x ~> y`|`not (x > y)` | |`x != y`|`x y` | |`x ^= y`|`x y` | |`x... [Read More]

Artigo "Novidades do Firebird 2.5": Linguagem PSQL

A linguagem procedural do Firebird, a PSQL, foi incrementada com novos comandos e outras melhorias. A primeira melhoria que irei apresentar se trata do uso de subqueries como expressões PSQL. Antes, o desenvolvedor era obrigado a criar uma variável e fazer um `SELECT INTO` para obter um valor e usá-lo... [Read More]

Artigo "Novidades do Firebird 2.5": Comandos DDL

Além do comando CREATE COLLATION, mostrado na seção anterior, o Firebird 2.5 acrescenta comandos DDL que aliviam limitações anteriores e outros comandos totalmente novos. Duas limitações existentes nas versões anteriores eram relacionadas à impossibilidade de alteração de colunas COMPUTED BY e views. Era preciso eliminar estes objetos e recriá-los com... [Read More]

Artigo "Novidades do Firebird 2.5": Migrando de versões anteriores

Conforme citado na introdução, a compatibilidade é levada a sério no Firebird. Infelizmente, porém, às vezes é preciso fazer mudanças que causam certas dificuldades de migração. Antes da versão 2.1 o Firebird tinha importantes bugs referentes a implementação de character sets multibyte herdados do InterBase. Um destes character sets é... [Read More]

Artigo "Novidades do Firebird 2.5": Introdução

O desenvolvimento do SGBD Firebird foi iniciado em Julho do ano 2000 a partir do código fonte da versão beta do InterBase 6.0, disponibilizado pela Inprise (Borland) sob licença open source. Desde então cinco versões foram lançadas pela sua equipe de desenvolvimento, mostrando uma evolução contínua do produto. O foco... [Read More]

Artigo "Novidades do Firebird 2.5"

A partir de sexta-feira, dia 20/12/2013, começarei a postar o artigo que escrevi para a revista ClubeDelphi. Esse artigo saiu na edição #125 da revista, em dezembro de 2010.O artigo será postado em partes, conforme abaixo:- Introdução- Migrando de versões anteriores- A arquitetura SuperClassic- Character Sets e Collates- Comandos DDL... [Read More]

DSQL/BLR compilers internals

This post is some raw notes and is not very understandable by people who never worked with this code. In fact, the old implementation was so ugly that it was not simple even for me (who is constantly working in this area) to achieve this result. It needed many tries... [Read More]

Novidades do Firebird 2.5 - Revista ClubeDelphi

Saiu na edição 125 da revista ClubeDelphi o artigo que escrevi sobre as novidades do Firebird 2.5. Esta edição também tem outra matéria sobre Firebird, entitulada "Aplicações com Firebird Embedded – Parte 1".Já tinha recusado convites similares, mas desta vez resolvi topar o desafio. Não gosto muito de escrever, sou... [Read More]

Introducing the boolean datatype

The support for a BOOLEAN datatype was the third most voted feature in the Firebird tracker. The deal with it was about make it right and complete, having booleans expressions allowed where values are expected, and vice versa. Oracle did it wrong and they BOOLEAN is crap.Yesterday I finished and... [Read More]

Firebird 2.5 Introduces New Audit Features and Improved Scalability

October 4, 2010The Firebird Project today announces Firebird 2.5, the fifth and newest major release of its open source relational database management system. Enhancements in this new release are pitched at better serving the needs of businesses of any scale, from embedded device to enterprise resource planning solutions.Philippe Makowski, President... [Read More]

Firebird 2.5 launch

Firebird 2.5 release date is set - it will be October 4th, 2010.Please join Philippe Makowski, President of Firebird Foundation, and Dmitry Yemanov, lead Firebird developer, at the Launch Webinar devoted to the 5th major release of Firebird.It will take place at October 4th, 2010, at 13:00 GMT (10:00 pelo... [Read More]

Firebird 10th anniversary. How I came to it.

July 31th, 2010. Today Firebird completes its 10th anniversary. The Firebird website has a set of history documents about how that started. It’s something you must read if you’re interested in Firebird.I’m sometimes asked about how I became one of its team members. So I’m going to tell something about... [Read More]

Window functions (part3) - new functions

In the first and the second part of window function series, I talked about the OVER clause, with/without partitions and with/without ordering. Till then, no new function had been introduced, so it has about the already existing aggregate functions.Now, new window-only functions has been introduced. I'll separate them in two groups: ranking and navigational.... [Read More]

Window Functions (part2) - cumulative aggregates

Continuing with the window functions support for Firebird 3, I have now added another OVER sub-clause: ORDER BY. The ORDER BY sub-clause can be used with or without partitions, and it makes aggregate functions return the partial aggregations as the records are being processed.Considering our employee table has this data:idsalary110.00212.0038.0049.00510.00And we run this... [Read More]

Window Functions

By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions are used with the OVER clause. Users of Oracle also knows window functions as... [Read More]

Integração da JVM ao Firebird

A um tempo atrás "descobri" a integração do Oracle com Java no lado servidor, e logo pensei: O Firebird precisa disso também.Sabia da iniciativa anterior de outros desenvolvedores fazerem o mesmo, e a idéia foi fazer o projeto vingar. Por diversos motivos isso pareceu impossível, então resolvi iniciar uma implementação... [Read More]

CVSNT client is slow

For years I was using CVSNT client to work with Firebird and any other CVS repository. I started to use it because I needed a client capable of handling the "sserver" protocol method, which the "standard" CVS can't. A first thing I've noted has that it most times refetches completely... [Read More]