Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #9758

Re: Ubunto

Show key headers only | View raw

On Sun, 06 Nov 2011 17:13:49 -0800, Lew wrote:

> For development purposes, the default installation of Postgres works
> pretty well.  For production purposes, as with any DBMS, the situation
> can be more complicated.
>
PostgreSQL itself can be shifted about fairly easily: the inflexibility 
was in the SYSVinit daemon management script it uses which, at least on 
RedHat Fedora systems up to the F12 release,  could only be reconfigured 
by editing the script because it ignored the convention of stashing 
configurable values in /etc/sysconfig. They fixed this for F13 - just in 
time to change things again when F15 introduced the systemd service 
management system.

> Postgres and Derby both tend to win in another important area -
> standardness of the SQL dialect.
>
Agreed. Does anything apart from MySQL insist on using auto-incrementing 
variables where the rest of the DB world mostly uses sequences? I don't 
really see the point given that you almost always want to know the value 
that was assigned (particularly if the field is in a prime key) and this 
forces you to read a row immediately after it was inserted.
 
> If you're doing a lot of enterprise or web work you should consider
> Postgres  strong contender.  Even during development, it mixes well with
> the enterprise way of looking at things (layered and componentized).
>
I'm still very impressed with it, not least for the way it keeps its 
filing system tidy and the DB stats updated with next to no management 
effort apart from making backups and the periodic need to restore from 
the backup after a major version upgrade.

> Porting a system from Postgres to, say, Oracle or DB2 turns out to be
> not so bad.  Of course no two RDBMSes speak the same dialect of SQL, but
> the transformations between the big guns seem to be mostly mechanical -
> Oracle uses VARCHAR2 for VARCHAR, for example.  It's harder when a
> system decides to reinvent the semantics of a keyword to something
> rather different, as MySQL did with TIMESTAMP.
>
The only major Postgres anomaly, that I've noticed anyway, is its use of 
a BYTEA where other DBMS would use a CLOB.

> For desktop distribution Derby may well be the ideal solution.  For a
> desktop app needing more than desktop-scale data, perhaps a distributed
> DBMS architecture - keep the local DB as a sort of edge cache for
> wide-area data.
>
Derby is very much on my radar: I just haven't yet found a round tuit or 
a good reason to use Derby in place of PostgreSQL.

Have you tried using it as a small central DBMS, i.e. not run as an 
integral part of an application? If so, are there any obvious gotchas or 
performance issues with running it that way?
 


-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Ubunto Roedy Green <see_website@mindprod.com.invalid> - 2011-10-13 10:44 -0700
  Re: Ubunto Robert Klemme <shortcutter@googlemail.com> - 2011-10-13 22:27 +0200
    Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-14 01:08 +0000
    Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-14 14:21 +0100
      Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-14 17:00 -0400
        Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-14 22:20 +0000
          Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-15 01:16 -0400
            Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-15 12:21 +0000
              Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-15 15:42 -0400
                Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-16 00:23 +0000
              Re: Ubuntu Roedy Green <see_website@mindprod.com.invalid> - 2011-10-15 13:01 -0700
                Re: Ubuntu Arne Vajhøj <arne@vajhoej.dk> - 2011-10-15 16:49 -0400
                Re: Ubuntu Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-16 00:57 +0000
                Re: Ubuntu Tom Anderson <twic@urchin.earth.li> - 2011-10-17 00:51 +0100
                Re: Ubuntu Arne Vajhøj <arne@vajhoej.dk> - 2011-10-16 22:12 -0400
                Re: Ubuntu Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-17 21:21 +0000
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-18 14:50 +0000
                Re: Ubuntu Lew <lewbloch@gmail.com> - 2011-10-18 08:59 -0700
                Re: Ubuntu Robert Klemme <shortcutter@googlemail.com> - 2011-10-18 18:19 +0200
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-18 17:43 +0000
                Re: Ubuntu Robert Klemme <shortcutter@googlemail.com> - 2011-10-18 22:18 +0200
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-19 13:26 +0000
                Re: Ubuntu Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-19 00:18 +0000
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-19 13:27 +0000
                Re: Ubuntu Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-19 19:39 +0000
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-20 14:15 +0000
                Re: Ubuntu David Lamb <dalamb@cs.queensu.ca> - 2011-10-20 12:24 -0400
                Re: Ubuntu Tom Anderson <twic@urchin.earth.li> - 2011-10-20 20:53 +0100
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-21 16:24 +0000
                Re: Ubuntu Tom Anderson <twic@urchin.earth.li> - 2011-10-22 20:38 +0100
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-25 07:03 +0000
                Re: Ubuntu Eight of Seventeen <eights17@gmail.com> - 2011-10-25 23:23 -0700
                Re: Ubuntu blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-21 16:24 +0000
                Java 7 javadocs (was Re: Ubuntu) blmblm@myrealbox.com <blmblm.myrealbox@gmail.com> - 2011-10-20 14:16 +0000
                Re: Java 7 javadocs (was Re: Ubuntu) David Lamb <dalamb@cs.queensu.ca> - 2011-10-20 12:27 -0400
                Re: Java 7 javadocs (was Re: Ubuntu) Arne Vajhøj <arne@vajhoej.dk> - 2011-11-06 15:44 -0500
                Re: Ubuntu Tom Anderson <twic@urchin.earth.li> - 2011-10-20 20:53 +0100
                Re: Ubuntu Eight of Seventeen <eights17@gmail.com> - 2011-10-20 17:05 -0700
                Re: Ubuntu Tom Anderson <twic@urchin.earth.li> - 2011-10-17 00:32 +0100
            Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-15 15:06 +0100
              Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-15 15:59 +0000
                Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-15 17:15 +0100
                Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-15 16:48 +0000
                Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-15 15:45 -0400
                Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-16 00:17 +0000
                Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-16 23:40 +0100
                Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-16 23:50 +0000
              Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-15 15:46 -0400
                Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-16 23:44 +0100
                Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-16 20:41 -0400
                Re: Ubunto Lew <lewbloch@gmail.com> - 2011-10-16 17:48 -0700
                Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-16 20:59 -0400
    Re: Ubunto Stanimir Stamenkov <s7an10@netscape.net> - 2011-10-16 11:39 +0300
      Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-16 11:22 +0000
        Re: Ubunto Arved Sandstrom <asandstrom3minus1@eastlink.ca> - 2011-10-16 10:58 -0300
      Re: Ubunto Dancing Fingers <batymahn@gmail.com> - 2011-10-21 01:51 -0700
  Re: Ubunto Arne Vajhøj <arne@vajhoej.dk> - 2011-10-13 22:54 -0400
  Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-14 14:20 +0100
    Re: Ubunto Roedy Green <see_website@mindprod.com.invalid> - 2011-10-15 13:04 -0700
      Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-16 01:03 +0000
        Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-17 00:31 +0100
          Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-17 00:29 +0000
            Re: Ubunto Arne Vajhøj <arne@vajhoej.dk> - 2011-10-16 22:03 -0400
              Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-17 15:08 +0100
                Re: Ubunto Arne Vajhøj <arne@vajhoej.dk> - 2011-11-06 15:49 -0500
              Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-17 21:29 +0000
                Re: Ubunto Arne Vajhøj <arne@vajhoej.dk> - 2011-11-06 15:47 -0500
                Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-11-06 22:49 +0000
                Re: Ubunto Lew <lewbloch@gmail.com> - 2011-11-06 17:13 -0800
                Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-11-07 23:49 +0000
                Re: Ubunto markspace <-@.> - 2011-11-07 21:07 -0800
            Re: Ubunto Tom Anderson <twic@urchin.earth.li> - 2011-10-17 16:47 +0100
          Re: Ubunto B1ll Gat3s <wm.g4t3s@m1cr0s0f7.c0m> - 2011-10-16 20:55 -0400
            Re: Ubunto Martin Gregorie <martin@address-in-sig.invalid> - 2011-10-17 21:37 +0000
          Re: Ubunto Arne Vajhøj <arne@vajhoej.dk> - 2011-10-16 22:14 -0400

csiph-web