Re: [SLUG] Which linux database app recommended for replacement of MS Access?

From: Paul M Foster (paulf@quillandmouse.com)
Date: Mon Mar 03 2003 - 19:10:33 EST


False administrivia bounce.

----- Forwarded message from slug@lists.nks.net -----

On Mon, 2003-03-03 at 15:56, John Clay wrote:
> What would 'yall recommend as a Linux based replacement for Access? It
> will need to have a nice gui and be able to import/export from/to Access
> in it's various incarnations.

You're asking several different questions:

"What's a good replacement for the front-end database GUI thingie you
_g_e_t_ with Access"

and

"What's a good replacement database for Access?"

and

"How can I export/import from/to Access and something else?"

For the former question, I've used TOra for accessing Oracle databases
in the past, and it supposedly has MySQL and PostgreSQL support in the
latest incarnation, but it's more of a "query workspace" than any sort
of GUI designer app; there are a number of those out there that I've
seen, but I don't really know much about any them, since I don't use
them.

I would choose PostgreSQL or MySQL for the database back-end, depending
on what sort of capabilities you need. In the past, MySQL has been
"blazingly faster" than PostgreSQL by huge margins, but in stuff I've
been doing at work lately, I've discovered that PostgreSQL has caught up
almost across-the-board with MySQL in speed, and there are things
PostgreSQL can do much faster than MySQL, particularly when it comes to
complex queries.

MySQL and PostgreSQL both have ODBC drivers available, so whatever you
use, you should be able to use ODBC to export from your Access database
and import into whatever you're using to replace it.

Keep in mind through all of this though that Access is to MySQL or
PostgreSQL, roughly as Notepad is to vi or Emacs. Access is designed to
"point and click" your way into having a silly little file-based
database while MySQL and PostgreSQL are standalone SQL database servers
which can and do hold millions of records and support thousands of
concurrent users.

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
#!/usr/bin/perl -w
$_='while(read+STDIN,$_,2048){$a=29;$b=73;$c=142;$t=255;@t=map
{$_%16or$t^=$c^=($m=(11,10,116,100,11,122,20,100)[$_/16%8])&110;
$t^=(72,@z=(64,72,$a^=12*($_%16-2?0:$m&17)),$b^=$_%64?12:0,@z)
[$_%8]}(16..271);if((@a=unx"C*",$_)[20]&48){$h=5;$_=unxb24,join
"",@b=map{xB8,unxb8,chr($_^$a[--$h+84])}@ARGV;s/...$/1$&/;$d=
unxV,xb25,$_;$e=256|(ord$b[4])<<9|ord$b[3];$d=$d>>8^($f=$t&($d
>>12^$d>>4^$d^$d/8))<<17,$e=$e>>8^($t&($g=($q=$e>>14&7^$e)^$q*
8^$q<<6))<<9,$_=$t[$_]^(($h>>=8)+=$f+(~$g&$t))for@a[128..$#a]}
print+x"C*",@a}';s/x/pack+/g;eval

usage: qrpff 153 2 8 105 225 < /mnt/dvd/VOB_FILENAME \ | extract_mpeg2 | mpeg2dec -

http://www.cs.cmu.edu/~dst/DeCSS/Gallery/ http://www.eff.org/ http://www.anti-dmca.org/

----- End forwarded message -----



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:27:43 EDT