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

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

Re: programming...?

Show all headers | View raw

On Wed, 21 Feb 2018 08:29:55 -0800, Eric Douglas wrote:

> I'm not sure how much differences there are between SQL.
>
Some SQL dialects are more standard than others. PostgeeSQL is often 
mentioned as being closest to the standard while Oracle was/is the most 
deviant dialect.

> Transact-SQL functions have different syntax for different DBs.
> 
I forgot that, mainly because I've almost never used it. Nearest I came 
was DEC's Rdb which used compilable modules that embedded SQL statements 
in a lot of procedural stuff - the combo was the equivalent of the SQL 
package + the JDBC driver.

And you're right: almost every DBMS has its own stored procedure 
language. I was out of that loop by the time a standard for stored 
procedures emerged in 1999 and anyway the specialised data warehouse I 
was using at the time only had an ODBC interface and didn't support 
stored procedures.

> I hate having to purchase software to learn it.  We have 3
> implementations currently running on 2 servers, one running a MySQL
> (totally free, not sure the limitations),
>
I think there's a general opinion that MariaDB, a fork of MySQL, is 
better than its parent. I haven't used either, so don't know whether that 
opinion is due to Oracle owning MySQL, Michael Widenius having baled 
after Oracle bought Sun and started MariaDB, or for some other reason. 
I've not used either. All I know is that RedHat Fedora switched from MySQL 
to MariaDB as its default small DBMS.

At the time I needed to choose an RDBMS MySQL was still much better as a 
searcheable data source than it was as a transactional DB and I prefer 
the PostgreSQL sequence data type to MySQL's autoincrementing integer 
fields, so I went with PostgreSQL on my Fedora systems and have never had 
reason to regret that choice.

> There's a free SQL Server with limitations which as far as I know does
> everything you should need for development testing and small personal 
> applications.
>
That's what I referred to as the Access replacement. Apparently its 
largely incompatible with almost all SQL Server's DBA tools, so I have no 
idea what its like inside - Access with a new coat of paint? 


-- 
Martin    | martin at
Gregorie  | gregorie dot org

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

Thread

programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 07:38 -0800
  Re: programming...? Jon <jon101011@yahoo.com> - 2018-02-20 17:07 +0100
    Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 08:19 -0800
      Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-20 11:45 -0500
        Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 12:39 -0800
          Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 13:25 -0800
            Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 14:00 -0800
            Re: programming...? Daniele Futtorovic <da.futt.news@laposte.net> - 2018-02-21 00:31 +0100
            Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-20 19:24 -0500
          Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-20 19:21 -0500
  Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-20 11:41 -0500
  Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-20 19:37 +0000
    Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 12:10 -0800
      Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-20 22:00 +0000
  Re: programming...? Robert Spanjaard <spamtrap@arumes.com> - 2018-02-20 21:09 +0100
    Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-20 12:16 -0800
      Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-20 22:09 +0000
        Re: programming...? Robert Spanjaard <spamtrap@arumes.com> - 2018-02-21 01:16 +0100
          Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-21 00:47 +0000
            Re: programming...? Robert Spanjaard <spamtrap@arumes.com> - 2018-02-21 12:29 +0100
              Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 10:42 -0500
              Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-21 15:44 +0000
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 11:03 -0500
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-21 08:38 -0800
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 11:54 -0500
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-21 10:40 -0800
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 14:35 -0500
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-21 11:48 -0800
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-21 08:29 -0800
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 11:47 -0500
                Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-21 17:35 +0000
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 12:47 -0500
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-21 10:45 -0800
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 14:40 -0500
                Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-21 21:23 +0000
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 21:39 -0500
                Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-22 09:06 +0000
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-24 20:29 -0500
                Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-25 02:12 +0000
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-26 08:19 -0800
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-03-01 13:17 -0500
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-21 10:43 -0800
                Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-21 21:14 +0000
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-21 21:35 -0500
                Re: programming...? Kiwi User <martin@mydomain.invalid> - 2018-02-22 09:10 +0000
                Re: programming...? Eric Douglas <e.d.programmer@gmail.com> - 2018-02-22 06:23 -0800
                Re: programming...? Arne Vajhøj <arne@vajhoej.dk> - 2018-02-22 19:32 -0500

csiph-web