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

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

HOWTO: Install SAP Sybase ASE 15.x and Linux Containers (LXC) – Ubuntu Server 12.04

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

Requirements: Host OS: Ubuntu Server 12.04 x86-64 (64bit) At least 4GB RAM 300GB available disk space Sybase Patches: If you’re going to run 32bit SQL Anywhere (or an embedded RSSD with Replication Server), you need to apply a SQL Anywhere patch: http://search.sybase.com/kbx/changerequests?bug_id=694479 Install LXC and the bridge-utils to support a network bridge: aptitude install lxc [...]

Share Button

How to install PostgreSQL 9 on Ubuntu Linux 10.04/10.10

by Jason L Froebe on December 18, 2010, one comment

Very easy, just add a repository and run apt-get install postresql-9.0 Dctr Watson explains how: Installing PostgreSQL 9.0 on Ubuntu 10.04

Share Button

How to: How to copy an Oracle tablespace across platforms – quick and dirty ;-)

by Jason L Froebe on April 5, 2010, no comments

On the source machine: Set the tablespace(s) into read only mode SQL> Alter tablespace <tablespace> read only Export the tablespace meta data using export % expdp system/<password> DUMPFILE=expdat.dmp DIRECTORY = dpump_dir TRANSPORT_TABLESPACES = <list of tablespaces separated by commas> TRANSPORT_FULL_CHECK=Y If the dumpdir is not set up, you will get an ‘invalid’ directory error: SQL> [...]

Share Button

Get your Sybase ASE 15.5 MDA table posters! Straight from Sybase’s Jeff Tallman

by Jason L Froebe on February 19, 2010, 2 comments

I asked Jeff Tallman if I could redistribute his excellent MDA posters for Sybase’s ASE 15.5 database server.  He said yes so …  here they are in both Adobe PDF and Sybase PowerDesigner PDM formats! Jeff Tallman also provided us with the MDA posters for Sybase 15.0.3 last year.

Share Button
Facebook login by WP-FB-AutoConnect