The bleak future of SSD drives

Leave a comment

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!

Leave a comment
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

Leave a comment
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

Leave a comment

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

Leave a comment
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

Leave a comment

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...

Firebird Embedded and LibreOffice is the killer combination to scale from a single file application to a client/server approach

Leave a comment

Quote of the day is via this thread on Firebird Java Group :

It would be good if Jaybird 2.3 could be used with embedded and
LibreOffice because the feature set in Firebird is obviously much, much greater
than HSQL or the proposed SQLite replacement.

The ability to create a zeroconf, transportable data file is of interest to me
(along with using iReport to generate printouts from that file).

OT: Personally I think that Jaybird / Firebird / Firebird embedded is the way to
go for LibreOffice instead of the very limited SQLite. The ability to upscale
from a single file application to a client/server one is a killer.

Update:Firebird Driver and Embedded version merged into LibreOffice git master

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

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

Firebird on Large Big Iron servers : 512G-2TB of ram 100.000 concurrent users

Leave a comment

Nikolay Samofatov wrote about his Large Iron production systems that he maintains :

We run Firebird to power larger systems (for 12 government agencies and 3 banks).

It has approximately 100000 end users multiplexed through 2500 (max) pooled connections.

Here is the snapshot of nearly idle system at night:

top - 03:20:39 up 10 days,  8:39,  7 users,  load average: 2.08, 1.87, 2.15
Tasks: 1732 total,   1 running, 1730 sleeping,   1 stopped,   0 zombie
Cpu(s): 11.9%us,  4.0%sy,  0.0%ni, 83.5%id,  0.0%wa,  0.0%hi,  0.6%si,  0.0%st
Mem: 529177288k total, 378587600k used, 150589688k free, 761532k buffers Swap: 1073741816k total, 130612k used, 1073611204k free, 333281232k cached

[root  mvv bin]# ps aux | grep -c rdb_inet_server
719

Database is on a small FusionIO drive:

mount:
/dev/fiob on /mnt/db type ext2 (rw,noatime)
df -h:
/dev/fiob             587G  423G  135G  76% /mnt/db

Also later he mentions that he uses 2TB of RAM machines

Chipsets that can handle 2 TB of RAM and 8 CPU sockets (<=80 cores, <=160 threads) are the largest “commodity” type hardware available now. These are the largest systems we worked on. 8 GB of lock manager space per database should be just enough for them. With the allocation error check in place we’ll have this problem solved for the next year or two until larger systems become common.

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

1 … 183 184 185 186 187 … 485