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: SQLite

Optimizing the Firefox (SQLite databases)

by Jason L Froebe on January 27, 2013, no comments

Most people that want to speed up Firefox know about the various settings in about:config but many forget that Firefox uses SQLite databases that can become cluttered. In your home directory ($HOME on *nix/Mac and %APPDIR% on Windows), run sqlite3 with vacuum, reindex and analyze on eche of the *.sqlite databases. Don’t have sqlite3? No [...]

Share Button

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

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

It’s here! The very first issue of MyDatabases!

by Jason L Froebe on July 29, 2008, 3 comments

MyDatabases Volume 1 Issue 1 (July 2008) MyDatabases Volume 1 Issue 1 Geek Spotlight:  Michael Peppler Sybase ASE on Ubuntu 8.04 Multicore Processors VMware Virtualization Logical Process Manager

Share Button
Facebook login by WP-FB-AutoConnect