Understanding barrier on Linux

It is known that massive write operations in Firebird databases (like updates affecting thousands or millions of records) had become much slower in more recent Linux servers. After investigation, I found this to be related with the fact that most recent distros brings the barrier parameter of the filesystem activated.

Unfortunately, I wasn’t able to solve this “problem” completely, without opening a door for corruption. The slow down when barrier is enabled can be minimized a lot if the database is configured with forced writes OFF, but this also may lead into corruption if something bad happens to the server.

Anyway, the purpose of this post is to share an article that helps to understand how barrier works and why it slow down such kind of operations.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Lazarus Free Pascal RAD IDE 1.0 RC2 is released

The Lazarus team is glad to announce that Lazarus 1.0RC2 is available for download at the SourceForge download page:
http://sourceforge.net/projects/lazarus/files/

Choose your CPU / OS / distro and then the 1.0RC2 directory.

Minimum requirements:
Windows:       98, 2k, XP, Vista, 7, 32 or 64bit
FreeBSD/Linux: gtk 2.8 or qt4.5, 32 or 64bit
Mac OS X:      10.4, LCL only 32bit, non LCL apps can be 64bit

This release has been built with fpc 2.6.0 (the former release 0.9.30.4 was
built with that too).

The svn tag is
http://svn.freepascal.org/svn/lazarus/tags/lazarus_1_0_RC2

The list of changes:
http://wiki.lazarus.freepascal.org/Lazarus_1.0_release_notes

1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)
Loading...

ANN: Firebird PHP Generator 12.8 released

Firebird PHP Generator SQL Maestro Group announces the release of Firebird PHP Generator 12.8, a frontend to generate feature-rich CRUD web applications for your Firebird database. The software comes in both Freeware and Professional editions.

New release provides you with a lot of features to create perfect web applications including an ability to completely customize the appearance of web pages, enhanced master-detail views, wide choice of new color schemes, and many other useful things. There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc).

Read full press-release.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Firebird Django and the Future : FDB pure python driver , Django 1.4.x , Python 3.x support

Maximiliano Robaina wrote on the firebird django group some words and questions about the future of the driver :

My ideas for future organization are:

  1. Update de google repository with the last django-firebird version with support for django 1.4. It will be the last update in this sense.
  2. From here, the next oficial repository will be at github
  3. The version on github will use fdb in place of kinterbasdb

The point 3 is the most important to discuss because it means the total drop of firebird 1.5.x support.

I have added to the group the notes for installing django 1.4.x firebird driver on ubuntu

ps: bonus for using the FDB driver is python 3.x support out of the box , that means we can start testing django 1.5 on python 3.x

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

#AnyDAC Summer 2012 v 6.0.1 – #Delphi Components for Firebird, Interbase and more

DA-SOFT Technologies announces the availability of major new version AnyDAC for Delphi Summer 2012 release v 6.0.1 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, Advantage, dbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications.

Do not miss the Summer sale25% discount on all AnyDAC orders in August !

AnyDAC for Delphi can be immediately downloaded from the download page.

What is new in v6.0.1 and what is AnyDAC ?

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Database Workbench 4.3.0 released

Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:

Database Workbench 4.3.0 Pro

For more information, see here.

Changes include:

  • Stored Procedure, Function and Trigger Debugger for MySQL
  • Incremental search of data in SQL, Table & View Editor
  • Syntax check in Trigger Editor for Firebird & InterBase

And much more: click here for the full list of changes in v4.3.0

The free Lite Editions will be released later.

Database Workbench supports:
– Borland InterBase (6.x – XE )
– Firebird ( 1.x, 2.x )
– MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
– MySQL 4.x, 5.x
– Oracle Database ( 8i, 9i, 10g, 11g )
– Sybase SQL Anywhere ( 9, 10, 11 and 12 )
– NexusDB ( 3.0 and up )

You like this news? Twitter it! Share it! Blog about it!

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

1 168 169 170 171 172 485