Daniel Magin’s Weblog

My life in the Developers World

Long trip to Scotts Valley

Yesterday i startet my trip to Scotts Valley (CodeGear Meeting). A lot of guys around the world will have a big meeting about technical and sales. Meeting the different teams of products will bring up new technical informations.

But the best part of my long trip (complete over 20 hours) was a reboot in the plane. Ok not the plane overall only in the multemedia software.

i have the luck to upgrade my ticket with my miles to business class on the trip from Frankfurt to Los Angeles. So everybody here have a personal screen. During the flight the Multimedia System crashed and for the technical guys, like me, was showing the complete boot sequence on the personal screens.

In my area some technical guyes was present and we have a lot of fun to see the Multimedia System in Lufthansa works with embedded Windows CE Operatingsystem. The reboot was still 10 Minutes running.

Here some pictures of all:

The Boing 747-400

The Boing 747-400
Reboot Multimedia System

MultiMedia Reboot 1MultiMedia Reboot 2MultiMedia Reboot 3MultiMedia Reboot 4MultiMedia Reboot 5MultiMedia Reboot 6MultiMedia Reboot 7

Greenland from sky 

Greenlandgreenland 2greenland 3greenland 4

Some Snow in US

Grand Canyon 2Grand Canyon 1

Today we have a free day ( 🙂 ) so i can do some shopping on Sunday ( welcome to US ).


October 7, 2007 Posted by | Embarcadero (CodeGear) stuff | 1 Comment

Interwise CodeGear RadStudio 2007 Session

Matthias Eissing and me have given today with over 100 customers a free 2 hour Interwise Session about the new CodeGear RadStudio 2007 Session. We have produces a lot of live coding about the new

  • IDE
  • Delphi Win32 What’s new for Vista, Dialogs, User Account Control,…
  • Delphi VCL.net Generics and other cool stuff
  • ASP.net 2.0 Master templates, CSS Sheets, and Login Templates with Blackfish
  • Writing Stored Procedures with Delphi .net for Blackfish
  • and a lot of more tips around the delphi world

we have a lot of fun and we will continue this sessions together.

Thanks Matthias

Matthias Eissing (left) and Daniel Magin (rigth)

October 2, 2007 Posted by | Embarcadero (CodeGear) stuff | 2 Comments

BlackFish SQL

Steve have puplished some more stuff about BlackFish on his block.

See this LINK of Original Message from Steve Shaughnessy

Simple deployment. 

There are single file deployment options for both the .NET and Java platforms.  If you use the windows version, there is only one .NET assembly you need to deploy.    This is particularly nice for ASP.NET applications.  No longer need to rent a database from your ISP.  On the Java platform there is a single jar file to deploy.  The license file also needs to be deployed, but this is small and it is “not” machine locked.  This makes it easy to do simple xcopy deployments.  On both platforms the delployment size of the binaries is about 1.3 megabytes.

Industry compliance.

SQL-92 compliant.  Local and remote ADO.NET providers.  Local and remote JDBC drivers.  DBX4 100% Object Pascal win32/.NET driver.


Early on we would do benchmarks against other Java databases.  However we quickly found that we were orders of magnitude faster than them.  We also found that we had no problem competing with databases written in native code.  Invariably, every time we found ourselves being beat it had nothing to do with managed code vs native code.  We could always match or beat the competition with better algorithms.  I know native code can be made faster for simple code, but with the complexity of transactional, high concurrency database kernel, better algorithms are king.  We have not performed major tuning for a while, and I’m not going to claim it’s the fastest, but this database is fast.

In-process execution.

The local ADO.NET and JDBC “local” drivers execute in process for improved performance and ease of deployment.

Delphi, C#,  VB.NET, and Java stored procedures and triggers.

These are safer and more powerful languages to write database stored procedures and triggers in.  In addition to using mainstream languages, you can also use off the shelf IDEs, debuggers and profilers to develop your stored procedures and triggers.

Really cross platform. 

Blackfish SQL pretty much runs every where .NET and Java run. We also have built a compact framework assembly for Blackfish SQL for the compact framework as well.  We are not ready to release this now, but we know it can be done. 


This is the only way Blackfish ever knew to handle character data.  Dealing with character data is always simple.  No multi-byte, national character, etc issues.  You also don’t need to specify the length of a string for performance reasons.  String storage is transparently managed.  For collation we use the collation key support provided by the .NET and Java platforms.  Why reinvent the wheel? 

64 bit support.

We didn’t have to lift a finger for this support.  If the .NET virtual machine is 64 bit, you can have a 64 bit database cache.  The same for a 64 bit Java vm.  Same binary for both 32 and 64 bit platforms.


Databases can be password protected and there is SQL based security including support for oles.  The database file itself can be encrypted using the Two fish 128 bit Two Fish block cipher.  Don’t forget your password.  There is no back door.  Some security conscious companies and government agencies view 100% managed code solutions as more secure.


We have mentioned in our roadmap that Blackfish SQL as a BDE replacement.  Today this is still a bit of work because it requires that you move away from the simple TTable/Query navigational data access model.  Going forward we will be looking at what we can do to support a navigational model to facilitate BDE application migration to Blackfish SQL.  The idea is to support native win32/64 client applications that can connect to a Blackfish SQL server using a navigational data access model (TTable).


Our Blackfish SQL tooling is very basic.  Leonel put a lot of work into adding ADO.NET, dbExpress 4 and query builder support into the DataExplorer in a relatively short period of time.  Our plan is to improve the capabilities and extensibility of DataExplorer going forward not just for Blackfish SQL, but also for Interbase and the rest of the databases we support as well.  In the mean time, Blackfish SQL has built-in “DB_ADMIN” stored procedures that allow applications to perform many common administrative tasks including database backup/copy/defragment/verify/encrypt/configuration, change password, metadata retrieval, active connections, lock manager state, and server side logging configuration.  The built-in DB_ADMIN stored process allows us to avoid polluting the name space of our standards based SQL dialect with Blackfish SQL specific extensions.

October 1, 2007 Posted by | Embarcadero (CodeGear) stuff | Leave a comment