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

Category Archives: MySQL

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

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

FW: Migration Migraines

by Jason L Froebe on January 28, 2009, no comments

Migration migraines: the top seven DBA data headaches Posted by Adrian Bridgwater Once or twice a year I get to work with an excellent DBA pal from Illinois called Jason Froebe who describes himself as a, “Perlmonger capable of speaking fluent munchkin.” His personal blog is called Ramblings of a Geek, but I keep telling [...]

Share Button

Borderline Scamming being done by software companies

by Jason L Froebe on December 22, 2008, 22 comments

The latest craze from software vendors to companies is to charge for each and every core a machine has regardless of whether or not you’re going to use it. Get this, if you want to buy a production license for your database/middleware/web server, the vendor (starts with an “S”) wants you to send them the [...]

Share Button

Watch out! Adrian is posting about me ;-)

by Jason L Froebe on September 10, 2008, no comments

In his ZDnet blog, Adrian Bridgwater mentions my blog and the latest article I wrote for the ISUG Technical Journal.  This has totally made my month!  (Not counting the blue raspberry slushee zombie baby Perl in the shell Posted by Adrian Bridgwater Why doesn’t anyone talk about computer programming languages these days? I’ve just spent [...]

Share Button
Facebook login by WP-FB-AutoConnect