Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

Andrew E. Bruno: Database Design with Dia

by Jason L Froebe on November 5, 2009, 3 comments

Back in December of 2007, Andrew E. Bruno wrote an excellent article on how to use the open source program Dia to design databases.  He used the resultant design to create a MySQL database but the same principles could be used to create just about any relational database from the design.  Dia is available for [...]

Share Button

Sybase’s PowerBuilder v12 is powerful, .NET based, and wonderful! Why you shouldn’t use it

by Jason L Froebe on August 27, 2009, 14 comments

The following is MY perception of Sybase’s PowerBuilder: Years ago PowerBuilder was king.  No one could touch it.  It was relatively inexpensive.  Microsoft’s Visual Basic matured and the Pascal based Borland’s Delphi was released.  Then it fell and fall it did. As it was falling from the throne Sybase purchased Powersoft, makers of PowerBuilder.  As [...]

Share Button

Calling Sybase developers! Please help fix the Sybase and Microsoft driver for the CakePHP framework!

by Jason L Froebe on February 2, 2009, no comments

While the CakePHP framework is very good, the dbo “driver” (wrapper) between CakePHP and the PHP Sybase/Microsoft drivers ar not implemented to be actually usable.  Most of the issues are differences of SQL dialect between MySQL and the commercial DBMSs. The issues tend to be simple ones such as, “select * from my_table limit 10″ [...]

Share Button

Flourish 2008 Conference Roundup

by Jason L Froebe on April 8, 2008, one comment

This year’s Flourish Conference was held at the University of Illinois in downtown Chicago (UIC). The Flourish web site describes Flourish as: The goal of the Flourish Conference is to promote the use and adoption of Free Libre Open Source Software (FLOSS) by demonstrating the practical applications of FLOSS in the business and academic world. [...]

Share Button
Facebook login by WP-FB-AutoConnect