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

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

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

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

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

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

No need to panic over #MySQL – are other open source databases available. #PostgreSQL, #Firebird, #HSQLDB, even Apache #Derby

MySQL users are nervous about Oracle’s takeover of Sun Microsystems, according to InfoWorld. You can see their point: Why would a company whose main product is a proprietary database be interested in maintaining an open source competitor to it?

There are other open source databases available. PostgreSQL, Firebird, HSQLDB, even Apache Derby can all be called into service, depending on your needs. The developer communities behind any of these projects would be more than happy to help scores of ex-MySQL users migrate to their particular platform. They almost certainly already have tools to do it

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

Cast Date to Integer, like Delphi does.

Today I needed to convert a Delphi/Pascal code to Firebird PSQL. Part of the code used the integer value of a date to do some calcs. First, I tried to use Firebird CAST to convert a Date to Integer, but FB can’t do this type of cast (anyway, I’m not sure if the result would be the same as Delphi, since I don’t know what starting date Firebird uses for internal storage). So, the solution was to create a workaround and subtract the date from 30-December-1899 (Dublin Julian Day), ie:

my_int_var = current_date – cast(‘30.12.1899’ as date);

The above line will return the integer value of the today date, as Delphi/Pascal would do. In other words, it is the number of days since 30-Dec-1899.

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

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

DbBench 0.6.0 Release

Tsutomu Hayashi released DbBench 0.6.0.

List of changes :

* Move development environment to Delphi2010.
* Add “ENGINE INNODB” to MySQL CREATE TABLE script.
* Firebird now use dbExpress driver for firebird by Embarcadero.
* Add “WaitOnLocks = True” for each drivers parameter.
* Change processed transaction count method, now include rollbacked transaction.

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

1 266 267 268 269 270 484