Re: making postgresql "source" its data feed from external csv file ...

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Albretch Mueller <lbrtchx(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: making postgresql "source" its data feed from external csv file ...
Date: 2011-01-04 00:38:29
Message-ID: AANLkTikN5bHyCf6zvCJxcfiB28UC6P_w2zBdODCHLG32@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

If your tables are read-only (which it kind of sounds like), you could
abstract out the reload mechanism, use the current implementation for
the in-memory databases, and use a combination of watching the CSV
files (e.g., through inotify on Linux) and TRUNCATE / COPY in
PostgreSQL. I think how well this will work will really depend on what
you're doing with the system, but it could be worth a shot.
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Albretch Mueller 2011-01-04 01:09:14 Re: making postgresql "source" its data feed from external csv file ...
Previous Message Craig Ringer 2011-01-04 00:14:10 Re: making postgresql "source" its data feed from external csv file ...