Groups > comp.databases.postgresql > #520

Re: why is postgresql better than mariadb?

From	Robert Klemme <shortcutter@googlemail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: why is postgresql better than mariadb?
Date	2013-12-02 21:18 +0100
Message-ID	<bg4887FrjjgU1@mid.individual.net> (permalink)
References	<485d489a-e7a5-4885-9c7d-2d983efef307@googlegroups.com> <72c0e227-0319-4daf-a1c2-73e043dab682@googlegroups.com>

Show all headers | View raw

On 29.11.2013 18:17, Marcello Dias wrote:
> What I really hated in PostgreSql is that it infers in the way I name
> My fields I like to use CamelCase

SQL standard mandates case insensitivity:

http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

Section 5.2, Syntax Rules 10).

> and if i Do that I have to write
> everything using commas,

Die you mean "double quotes" instead of "commas"?  I don't see how 
commas would help with the case in SQL.  To get exact case handling you 
usually have to enclose identifiers in double quotes in SQL.

> that really annoying since it makes querys
> less readable and verbose. So everybody uses _ like customer_id
> nick_name ,but every RDBMS have its own weirdness.

SNAKE_CASE is pretty common for database entity names.  I'd just stick 
with the convention rather than having double quotes all over the place.

Kind regards

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2013-08-15 20:20 -0700
  Re: why is postgresql better than mariadb? Jasen Betts <jasen@xnet.co.nz> - 2013-08-17 12:54 +0000
  Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-08-18 21:40 +0200
    Re: why is postgresql better than mariadb? Mario Splivalo <majk@fly.srk.fer.hr> - 2013-09-12 19:57 +0000
      Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-09-12 22:16 +0200
      Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-06 08:21 +0000
        Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-06 12:10 +0200
          Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-06 20:44 +0000
            Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-06 23:17 +0200
          Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-10-07 18:03 +0200
            Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-07 18:30 +0200
              Re: why is postgresql better than mariadb? Milo Minderbinder <milo@mmenterprises.invalid> - 2013-10-09 01:51 +0000
            Re: why is postgresql better than mariadb Milo Minderbinder <milo@mmenterprises.invalid> - 2013-10-09 01:46 +0000
              Re: why is postgresql better than mariadb Robert Klemme <shortcutter@googlemail.com> - 2013-10-09 08:41 +0200
                Re: why is postgresql better than mariadb Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:24 +0000
        Re: why is postgresql better than mariadb? Fredrik Jonson <fredrik@jonson.org> - 2013-10-11 12:17 +0000
          Re: why is postgresql better than mariadb? Paul Sephton <prsephton@gmail.com> - 2013-10-14 03:47 -0700
            Re: why is postgresql better than mariadb? Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-10-14 18:52 +0200
              Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:58 +0000
            Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:55 +0000
          Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 03:50 +0000
            Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-25 04:07 +0000
            Re: why is postgresql better than mariadb? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2013-10-25 10:09 +0200
            Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2013-12-07 10:52 -0800
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2013-12-07 10:58 -0800
  Re: why is postgresql better than mariadb? Mladen Gogala <gogala.mladen@gmail.com> - 2013-10-06 08:24 +0000
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2014-04-09 02:32 -0700
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-11-29 07:39 -0800
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2014-04-09 02:33 -0700
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-11-29 09:17 -0800
    Re: why is postgresql better than mariadb? Robert Klemme <shortcutter@googlemail.com> - 2013-12-02 21:18 +0100
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-11-30 05:59 -0800
    Re: why is postgresql better than mariadb? eric@invalid.com (EricF) - 2013-12-04 04:11 +0000
    Re: why is postgresql better than mariadb? johannes falcone <visphatesjava@gmail.com> - 2014-04-09 02:37 -0700
  Re: why is postgresql better than mariadb? Marcello Dias <marcellaodobrasil@gmail.com> - 2013-12-07 02:53 -0800
  Re: why is postgresql better than mariadb? yangnw@live.com - 2014-05-12 08:06 -0700

csiph-web