librelist archives

« back to archive

What? No PostgreSQL?

What? No PostgreSQL?

From:
Dan Langille
Date:
2013-09-27 @ 11:50
I was just speaking with another Pentabarf user (he works on FOSDEM).  He 
and I both use Pentabarf for our respective conferences (FOSDEM, BSDCan, 
PGCon).  In our conversation I learned grab is not using PostgreSQL, but 
has gone with SQLite.

This won't scale.

e.g. I can't keep my database on server A, my web services on server B, 
and my web-proxy on server C.

I also heard there was some initiative to head back and use PostgreSQL and
the data integrity that comes built-in.

Is this true?

If so, count me in for helping out.

-- 
Dan Langille - http://langille.org

Re: [frab] What? No PostgreSQL?

From:
Nils Magnus
Date:
2013-09-27 @ 12:28
Am 27.09.2013 13:50, schrieb Dan Langille:
> I was just speaking with another Pentabarf user (he works on FOSDEM).  
He and I both use Pentabarf for our respective conferences (FOSDEM, 
BSDCan, PGCon).  In our conversation I learned grab is not using 
PostgreSQL, but has gone with SQLite.
>
> This won't scale.
>
> e.g. I can't keep my database on server A, my web services on server B, 
and my web-proxy on server C.
>
> I also heard there was some initiative to head back and use PostgreSQL 
and the data integrity that comes built-in.

AFAIK based on our tests, Frab comes bundled with support of Sqlite, 
MySQL and PostgrSQL. I remeber that since you actually need to install 
*all* of those gems during this slightly confusing (but not too bad) 
installation process.

For a PoC Sqlite worked very smoothly and to be honest, I doubt that 
there are many use cases when you run into performance issues. After 
all, frab is more or less a frontend for one (or very few) persons who 
enter data into tables.

The data schema looked quite sensible from my perspective, but you won't 
intreract with that anyway, though, as there is a ORM between you and 
the DB (as in every RoR application). However, configuring PostgreSQL 
might make sense and should be a matter of minutes.

One final remark: I was very reluctant to use Pentabarf for many years, 
since it lacked a number of features I think we need here at LinuxTag. 
Beside that, the UI (and export output) was, erm, "not conforming modern 
style expectations".

In both aspects Frab is a major milestone. I was positively surprised by 
its looks and features. It still lacks a few features specific for 
LinuxTag and there are some design decisions I did not completely 
understand, but it appears to be a solid foundation.

After all, it is Ruby with all its pros and cons. The installation 
process is tricky, but even I as someone who has never worked with RoR 
before managed it.

Like many web applications, Frab does not fit very well into your OS 
package manager. This is not an excuse, but a sad reality.

Regards,

Nils Magnus
-- 
Director LinuxTag e. V. * LinuxTag: May 22 - 25, 2013 in Berlin, Germany

Re: [frab] What? No PostgreSQL?

From:
Ruurd Pels
Date:
2013-09-27 @ 12:15
On 27 sep. 2013, at 13:50, Dan Langille <dan@langille.org> wrote:
> I was just speaking with another Pentabarf user (he works on FOSDEM).  
He and I both use Pentabarf for our respective conferences (FOSDEM, 
BSDCan, PGCon).  In our conversation I learned grab is not using 
PostgreSQL, but has gone with SQLite.
> 
> This won't scale.
> 
> e.g. I can't keep my database on server A, my web services on server B, 
and my web-proxy on server C.
> 
> I also heard there was some initiative to head back and use PostgreSQL 
and the data integrity that comes built-in.
> 
> Is this true?

no.

-- 
Ruurd Pels,       Boogerd 1, 1791 GW  Den Burg - Texel, The Netherlands
rfpels@gmail.com        http://about.me/ruurdpels          +31612914545

Re: [frab] What? No PostgreSQL?

From:
Dan Langille
Date:
2013-09-29 @ 12:47
On Sep 27, 2013, at 2:15 PM, Ruurd Pels wrote:

> On 27 sep. 2013, at 13:50, Dan Langille <dan@langille.org> wrote:
>> I was just speaking with another Pentabarf user (he works on FOSDEM).  
He and I both use Pentabarf for our respective conferences (FOSDEM, 
BSDCan, PGCon).  In our conversation I learned grab is not using 
PostgreSQL, but has gone with SQLite.
>> 
>> This won't scale.
>> 
>> e.g. I can't keep my database on server A, my web services on server B,
and my web-proxy on server C.
>> 
>> I also heard there was some initiative to head back and use PostgreSQL 
and the data integrity that comes built-in.
>> 
>> Is this true?
> 
> no.


The above answer seems to conflict with the reply from Nils Pels.  Can you
elaborate please?

-- 
Dan Langille - http://langille.org

Re: [frab] What? No PostgreSQL?

From:
Nils Magnus
Date:
2013-09-29 @ 13:04
Am 29.09.2013 14:47, schrieb Dan Langille:
>
> On Sep 27, 2013, at 2:15 PM, Ruurd Pels wrote:
>
>> On 27 sep. 2013, at 13:50, Dan Langille <dan@langille.org> wrote:
>>> I was just speaking with another Pentabarf user (he works on FOSDEM).
He and I both use Pentabarf for our respective conferences (FOSDEM, 
BSDCan, PGCon).  In our conversation I learned grab is not using 
PostgreSQL, but has gone with SQLite.
>>>
>>> This won't scale.
>>>
>>> e.g. I can't keep my database on server A, my web services on server 
B, and my web-proxy on server C.
>>>
>>> I also heard there was some initiative to head back and use PostgreSQL
and the data integrity that comes built-in.
>>>
>>> Is this true?
>>
>> no.
>
> The above answer seems to conflict with the reply from Nils Pels.  Can 
you elaborate please?

Who is Nils Pels?

Where is the conflict?

 From our recent Frab installation:

.../frab/config$ head -15 database.yml
# SQLite version 3.x
#   gem install sqlite3-ruby (not necessary on OS X Leopard)
#development:
#  adapter: sqlite3
#  database: db/development.sqlite3
#  pool: 5
#  timeout: 5000

development:
   adapter: postgresql
   database: frab_2014_dev
   pool: 5
   timeout: 5000
   username: frab
   host: rhythm

Traditionally we use PostgreSQL on our database host rhythm, and so do 
we in this installation.

Regards,

Nils Magnus
-- 
Director LinuxTag e. V. * LinuxTag: May 22 - 25, 2013 in Berlin, Germany