German translation of Firebird security article

There’s an article on the Firebird Documentation web-page about Firebird File and Metadata Security. Since this is an interesting topic to our customers, I took the time to translate it to German.

The article describes the fundamental problems in securing network connections. One of the biggest problem is key management. Since the Firebird server is usually controlled by and installed at the client’s site, you don’t have any control over it. So, theoretically, someone could always build his own Firebird server to spy on the password. But that’s only one of the problems discussed.

Many thanks to Geoff Worboys, the author of the original article, and Paul Vinkenoog for publishing it on the official web-site.

IBProvider for Firebird and Interbase has been released.

Changes in IBProvider v2 (build 2.6.06.2688)

  • Addition of UTF-8 charset support
  • Loading of charset information for COLUMN and PROCEDURE_PARAMETERS metadata schemes from system tables.

Changes in IBProvider v3 (build 3.0.0.6327 RC3)

New IBProvider v3 offers the brand new method for working with text data charsets:

  • We added ctype_user property that allows setting the encoding of data coming to client irrespective of the encoding in which this data is coming from database server.
  • New algorithms of BLOB fields converting provide for quick work with flowing data, optimization of interaction with ICU library.
  • We added ctype_none property that allows setting the charset for working with text data in NONE encoding.
  • Other important changes.
  • Support of Firebird and Interbase charsets aliases.

See detailed information on working with new character set processor in Firebird and Interbase character sets.

Text columns size in Firebird 2.X

IBProvider started to control text columns size when working with Firebird 2 servers in Unicode mode. If the length of loaded data exceeds the text column size the exclusion will be generated.

New article: Start working with Firebird

IBProvider announce the artcile: Start working with Firebird
 
Table of content:
————————————————————————————-
What is Firebird SQL Server?
What Firebird version to choose?
Firebird installation: choosing server type
       Firebird Super Server
       Firebird Classic Server
       Firebird Embedded
       If it is difficult to choose
Start working with Firebird
      New Firebird database creation
Firebird security
      SYSDBA User. Changing default password
Connection to Firebird from client’s application
     Firebird and VBScript, Visual Basic, VBA
     Firebird and Delphi
     Firebird and .Net
     Firebird and C++
Firebird database editing
    The List of Firebird administration utilities
Useful links

Original manual: Firebird

Firebird and MSVC8 run-time. Again

Vlad Horsun  wrote on Firebird-Devel list

After reading MSDN articles about assemblies, side-by-side installation,
context activation API, etc, i think i have an idea how we can avoid (in most
cases) requirement to install MSVC8 runtime via Windows Installer and just
deploy it with our binaries.

Firebird-Python and Character set issues – From Bug/Post of the day dept

After a long interruption I’m back at Firebird and kinterbasdb and I’m
just also back at character set troubles, my favorite pastim

In the new edition of IBProvider Professional 7 codepages support was implemented, bugs were fixed, BLOB-fields access and memory management was improved

IBProvider v3 Release Candidate 3

  • Support of the following codepages added: DOS858, TIS620, BIG5, KSC_5601, GB_2312, SJIS_0208, EUCJ_0208;
  • Bug in the errors handling for OUT-parameters of query was fixed;
  • BLOB-fields access was improved;
  • Memory management was improved;

IBProvider v2/v1

  • BLOB-fields access was improved;
  • Memory management was improved;

Source: Interbase and Firebird driver site

Primary Database in Use – Firebird ?

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

1 8 9 10 11 12 18