Arc Forumnew | comments | leaders | submitlogin
1 point by justgord 5726 days ago | link | parent

As an interim hack to get to postgres data, I'm currently using system to call the external psql command - less than ideal :[

<pre> (def sqltxt (sql) (system (string "psql -c " "\"" sql "\"" ))) </pre>

[ I guess opening a socket to the db server and parsing the resultset wouldn't be much harder if its text mode - could probably use the perl or ruby pglib as a guide, and port from that... ]



2 points by shader 5726 days ago | link

Hmm. I would think that you wouldn't want to open a new psql connection every time you want to look something up.

How about running the system command in a thread, which redirects psql's stdin and stdout to named pipes so that another arc thread could read from it using file read commands? That would give you more persistence, so you wouldn't have to keep loading psql.

Also, have a look at lib/mysql-ffi.arc in anarki; supposedly it has a ffi for mysql, though I haven't really looked at it much myself.

-----

1 point by justgord 5726 days ago | link

yeah or theres the mz: extension to access one of mzschemes pgsql libs...

Sure its ugly/slow.. but allows me to prototype in the meantime.

Thanks for the mysql ref, I'll take a look.

-----

2 points by absz 5726 days ago | link

I can't help you with the SQL, but I can give you a formatting tip: to get

  code formatted like this,
surround your code block with a blank line on each side and indent each line of code by at least two spaces.

-----

2 points by justgord 5726 days ago | link

  (prn "thanks absz")

-----