Preferred database / SQL variant for infra?

[Daniel Pocock]

Is there a preferred database, such as PostgreSQL, MariaDB, MySQL or some NoSQL for
services intended to run on Fedora infrastructure?

[Chaoyi Zha]

I think we prefer Postgres

On Sat, May 16, 2015, 7:17 AM Daniel Pocock <daniel(a)pocock.com.au&gt; wrote:

>  Is there a preferred database, such as PostgreSQL, MariaDB, MySQL or some
>  NoSQL for services intended to run on Fedora infrastructure?
>
>  _______________________________________________
>  infrastructure mailing list
>  infrastructure(a)lists.fedoraproject.org
>  https://admin.fedoraproject.org/mailman/listinfo/infrastructure

[Daniel Pocock]

On 16 May 2015 13:34:21 CEST, Chaoyi Zha <summermontreal(a)gmail.com&gt; wrote:
> I think we prefer Postgres
>
> On Sat, May 16, 2015, 7:17 AM Daniel Pocock <daniel(a)pocock.com.au&gt;
> wrote:
>
> >
> > Is there a preferred database, such as PostgreSQL, MariaDB, MySQL or
> some
> > NoSQL for services intended to run on Fedora infrastructure?
> >
> > _______________________________________________
> > infrastructure mailing list
> > infrastructure(a)lists.fedoraproject.org
> > https://admin.fedoraproject.org/mailman/listinfo/infrastructure
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> infrastructure mailing list
> infrastructure(a)lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/infrastructure 

Is there also any aversion to any abstraction layers such as unixODBC in particular or
that is acceptable if an application doesn't have direct PostgreSQL client code?

[Kevin Fenzi]

On Sat, 16 May 2015 18:29:24 +0200
Daniel Pocock <daniel(a)pocock.com.au&gt; wrote:

>  Is there also any aversion to any abstraction layers such as
> unixODBC
>  in particular or that is acceptable if an application doesn't have
>  direct PostgreSQL client code? 
Yes postgres. The only two things we have left that use mysql/mariadb
are paste and wiki and we are migrating the wiki away soon. ;) 
(Of course qa has some mariadb so we won't be done with it, but at
least we will be somewhat reduced). 

Most of our applications use sqlalchemy and alembec. 

kevin

[Ralph Bean]

On Mon, May 18, 2015 at 09:07:21AM -0600, Kevin Fenzi wrote:
>  On Sat, 16 May 2015 18:29:24 +0200
>  Daniel Pocock <daniel(a)pocock.com.au&gt; wrote:
>  
>  > Is there also any aversion to any abstraction layers such as unixODBC
>  > in particular or that is acceptable if an application doesn't have
>  > direct PostgreSQL client code?
>  
>  Yes postgres. The only two things we have left that use mysql/mariadb
>  are paste and wiki and we are migrating the wiki away soon. ;) 
>  (Of course qa has some mariadb so we won't be done with it, but at
>  least we will be somewhat reduced). 
>  
>  Most of our applications use sqlalchemy and alembec.  
Correct, but a spelling correction: it is 'alembic' (for schema
migrations).