Welcome to

Ivan Prenosil's Firebird/InterBase site

12.2008 - New version of FSQL added.

• FSQL - command line utility for executing sql scripts.  version 1.6.15
  Alternative to ISQL, with some enhancements.
• Firebird Index Key Size Calculator  Added FB2 support
  Simple tool to verify whether your data are indexable.
• To BLOB or not to BLOB
  Some notes that can help with decision whether to store long strings in BLOB or in CHAR/VARCHAR columns.
• How to connect to Firebird server
  Description of connect string.
• Tips&Tricks - Useful pieces of code
  • String functions in SP/Trigger language.
    TrimRight, Truncating string, Length of string, Position of substring function
  • Working with generatos.
    How to set generator value in SP, etc.
  • Date/Time functions
    Week-of-year etc.
  • UDF and NULL parameters
    Some tips on how to solve the problem of detecting NULLs in UDF.
• Description of command line switches
  • GBAK  updated 2.2009
  • GFIX
  • FBServer
• Cache settings
  Different methods of setting cache size.
• Security - Enhanced isc4.gdb
  Some tips to improve security of isc4.gdb database.
• Modifying users in security database
  Short list of available methods for modifying users in security database.
• Quiz
  I wonder if anybody is interested in this kind of pastime on serious internet site ... :-) No correct answers so far.
• Pictures from the Firebird Conference 2005
• DOWNLOAD
  • GLINK - utility for moving/renaming multi-file databases.

  ---

• My PHOTOGALLERY
  Something completely unrelated to databases ...

• Here http://www.eosdev.it are many documents translated to Italian.
  Thanks to Manlio Morini.
• Translations of some articles from this site
  can be found on this Brazil site.
• Japanese translation of this site
  Thanks to Meiji KIMURA.
• To BLOB or not to BLOB
  French translation.

Send comments to

Ivan.Prenosil (AT) seznam.cz

(Europe -> Czech Republic -> Prague)

Interbase® WebRing        [ Join Now | Ring Hub | Random | << Prev | Next >> ]