Hacker Read

emmett · 2008-11-24 11:58:41

#postgresql, #ruby-lang, #python

marcopicentini | karma 557 | avg karma 4.64 · | 2023-08-24 10:10:39

Ruby on Rails, Postgres.

marcopicentini | karma 557 | avg karma 4.64 · | 2023-01-27 05:12:26

Ruby on rails + Postgres.

mukund | karma 15 | avg karma 0.13 · | 2007-04-09 12:50:20

Ruby on rails + Postgres

ativzzz | karma 1927 | avg karma 2.09 · | 2019-08-07 18:32:57

Rails + postgres!

iShrimp | karma 113 | avg karma 1.95 · | 2017-10-26 21:54:43+00:00

Ruby on rails and postgres if thats what you mean

mixmastamyk | karma 12554 | avg karma 1.22 · | 2022-01-27 01:05:59

Postgres has supported Python for quite a while.

ceyhunkazel | karma 850 | avg karma 4.91 · | 2016-08-24 17:39:49

I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization

https://www.youtube.com/watch?v=knUitQQnpJo

reply

jeltz | karma 6278 | avg karma 2.2 · | 2013-05-13 15:41:10+00:00

I think it can use either pg (wrapper around libpq) or postgres-pr (pure ruby), though I always use pg.

EDIT: Seems like they have dropped support for postgres.

EDIT2: Yes, I did mean postgres-pr.

reply

nik736 | karma 1631 | avg karma 2.53 · | 2018-03-03 12:44:59+00:00

Rails + Postgres

mkull | karma 310 | avg karma 2.38 · | 2007-04-09 10:52:04

rails + postgres

MichaelBurge | karma 2729 | avg karma 2.09 · | 2017-05-22 04:05:37

Rails + Postgres

logjam | karma 2140 | avg karma 5.91 · | 2012-05-17 13:14:20

Looks good to me, although we use Postgre. web2py has been surprisingly good to work with.

I agree with the parent on Ruby vs Python - just pick the path you're already more comfortable on.

reply

lmwnshn | karma 157 | avg karma 6.54 · | 2022-04-21 22:24:15

On the other hand, you're probably writing your SQL parser to parse SQL queries that are being fed into some DBMS. I found pg_query's argument convincing: "Our conclusion: The only way to correctly parse all valid SQL queries that PostgreSQL understands, now and in the future, is to use PostgreSQL itself." [0]

[0] https://pganalyze.com/blog/parse-postgresql-queries-in-ruby

reply

davidw | karma 63893 | avg karma 3.82 · | 2008-08-01 16:56:11+00:00

Postgresql.

speedgoose | karma 8135 | avg karma 2.13 · | 2023-12-04 07:41:57

PostgreSQL.

luriel | karma 2464 | avg karma 5.51 · | 2012-09-02 16:12:34+00:00

PostgreSQL.

mbogda | karma 3 | avg karma 0.75 · | 2020-05-14 18:40:22

Implementing 'Datomic-esque' system using Ruby on top of PostgreSQL.

awinter-py | karma 5774 | avg karma 2.98 · | 2020-08-03 23:02:34

whoa neat

and agree re parsing -- turned out to be a huge pain. I think someone bundled the postgres parser for python; I wish this were true for every dialect but even so, there are versions to consider.

reply

niels_olson | karma 6462 | avg karma 2.8 · | 2012-11-11 21:21:12+00:00

If you want, the needed input cases and their desired output forms are in the repo, I would love to see how it's done in Ruby.

https://github.com/2grep/CoPATH-Parser

I'm not completely wed to postgresql, but I would hate to give up Joe, who has been tremendously helpful. And most of my admin experience is with postgresql (blogs, wikis, etc).

reply