Firebird: choosing an owner for database deployment

Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.

It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer’s computer.

Read the rest on Accounting++ blog

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

New IBExpert Version 2012.02.21 available

News from ibexpert page
New Data import, Extract metadata and Search metadata features, new IBEBlock functions, and more

New features include:

  1. Data import: now you can convert Boolean values to smallint values when importing data into a new table. You can also now automatically generate simple column names for the target table.
  2. To-Do list: now you can duplicate To-Do items.
  3. Extract metadata: New Always include COLLATE option.
  4. Search metadata: New Do not search in comments option.
  5. New IBEBlock functions and features.
  6. Many small bug fixes and minor improvements.

Since version 2011.12.01 IBExpert now uses the Firebird database and Firebird Embedded 2.5 to store all IBExpert data (registered databases, query histories etc.) by default. In previous versions by default IBExpert stored this data in the IBExpert.stg file and the user was able to change this manually in Options / Environment Options / User Database. Working with IBExpert.stg is still possible (for example, if you disable the User Database manually), but you will get a warning every time you start IBExpert, and we will not support this method in the future.

  • The Customer version (setup_customer.exe) can be downloaded here (for customers with valid license keys). You can also download the customer version in theIBExpert KG Download Center. If you can not see it there, you might have used a different e-mail in the customer registration process or your account has already expired.
  • The Trial version (setup_trial.exe) can be downloaded here (45 day test version) or from the IBExpert KG Download Center.
  • The free Personal version (setup_personal.exe) can be downloaded here (version with limited features free of charge).
1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 2.57 out of 5)
Loading...

We are currently preparing to release Firebird 2.0.7

From Paul Beach’s Blog:
We are currently preparing to release Firebird 2.0.7, since I take responsinility for the Mac builds, I did a 2.0.7 build on MacOSX 10.7 using the development tools installed by XCode 4.1 (gcc 4.2.1 etc). I set up the relevant environment variables for this older 32bit only build CFLAGS, CXXFLAGS, LD_FLAGS and also set the MACOSX_DEPLOYMENT_TARGET=10.4. The builds completed without any problems, some simple tests on MacOSX 10.7 showed no problems.

Now – Imagine my surprise when Philippe told me that when he tried to QA the builds on MacOSX 10.5 we got this error on SuperServer startup.

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

The bleak future of SSD drives

The technology trends we have described put SSDs in an unusual position for a cutting-edge technology: SSDs will continue to improve by some metrics (notably density
and cost per bit), but everything else about them is poised to get worse. This makes the future of SSDs cloudy: While the growing capacity of SSDs and high IOP rates will make them attractive in many applications, the reduction in performance that is necessary to increase capacity while keeping costs in check may make it difficult for SSDs to scale as a viable technology for some applications.

Not good news, specially for those thinking about using the for critical work, like database servers.

Read full research here (in English). Short article in portuguse here.

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

ANN: FB TraceManager V2.5.0 with per-database monitoring released!

Upscene Productions is proud to announce V2.5.0 of FB TraceManager, a specialized tool to continuously monitor your Firebird database via the Firebird 2.5 Trace API.

More information on the new release is available here:
http://www.upscene.com/displaynews.php?item=20120215

Beside the Trace API stuff, V2.5.0 now adds per-database monitoring including:

  • Database header page monitoring
  • Full Firebird monitoring (MON$) tables integration

In combination with the Trace API, this is a powerful and integrated toolset to optimize and tune your Firebird server, database and client application even further.

Read more about per-database monitoring here:
http://www.upscene.com/documentation/fbtm2/database_monitoring.htm

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.:
http://www.upscene.com/go/?go=fbtm

The full product documentation is also available online:
http://www.upscene.com/documentation/fbtm2/index.html

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

Database Workbench 4.2.1 released

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

Database Workbench 4.2.1 Pro

This release includes the FREE Lite versions for InterBase, Firebird and MySQL.

For more information, see here.

For a video explaining how to debug a Firebird Stored Procedure, click here.

Click here for the full list of changes in v4.2.1
Click here for the full list of changes in v4.2.0

Database Workbench supports:
– Borland InterBase ( 4.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 )

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

Kitto – A framework for creating data-driven web applications with Delphi and ExtJS

Kitto allows to create Rich Internet Applications based on a data model that can be mapped onto any database. The client-side part uses ExtJS (through the ExtPascal library) to create a fully AJAX application, allowing you to build standard and advanced data-manipulating forms in a fraction of the time.

Kitto is aimed at Delphi developers that need to create web application without delving into the intricacies of HTML, CSS, Javascript or learning to use a particular library such as ExtJS, yet it allows access to the bare metal if required.

Kitto includes a database-agnostic data-access layer, allowing to create applications that work on any database engine and port applications between database engines.

A Kitto application is described in a set of easily maintained YAML files, keeping definitions abstract and declarative and allowing for future extensions. Business rules are enforced either declaratively or through small javascript fragments on the client, or in Delphi code on the server.

Kitto was designed by Nando Dessena and its development is sponsored by Ethea, which uses Kitto for internal development projects and client work and provides Kitto-related tools, support and development services.

Start here for further information.

The getting started guide can be tested with Firebird and Delphi

 

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

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

ANN: Firebird Data Sync 12.2 released

Firebird Data Sync SQL Maestro Group announces the release of Firebird Data Sync 12.2, a powerful and easy-to-use tool for Firebird database contents comparison and synchronization.

Major features of the new version include comparison of database views and subsets of data, automatic checking of mappings, and exporting the comparison results to 18 file formats including Excel and HTML. There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc).

Read full press-release.

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

The Document Foundation Announces LibreOffice 3.5: The Best Free and Libre Office Suite Ever

The Document Foundation announces LibreOffice 3.5, the third major release of “the best free office suite ever”, which shows to end users the improvements derived from the development strategy adopted since September 2010.

LibreOffice 3.5 derives from the combined effort of full time hackers – the largest group of experienced OOo code developers –and volunteer hackers, coordinated by the Engineering Steering Committee.
Related to Firebird there is the ODBC linux 64 bug killed .
Also the db with no bool support (Firebird 2.5) issue is done

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

1 182 183 184 185 186 485