use filesystem
if this was 10 sec or something, but having 1 hour timeframe would
definitely made me choose db over filesystem.
Esmin.
On Sat, Jun 4, 2011 at 12:44 AM, John R Pierce pie...@hogranch.com wrote:
On 06/03/11 3:09 PM, Esmin Gracic wrote:
another option is using sqlite for storing
another option is using sqlite for storing images. All data is in single
file. (or files if you organize it that way) easier backup etc... you have
some db benefits and retaining solid speed vs file system. Haven't used
this, but seems as viable option to explore.
Esmin
On Fri, Jun 3, 2011 at
I'm migrating mssql database to pgsql, and have a bunch of small simple ref.
tables.
I want to put all ref tables into one table. (denormalize kinda...)
MegaRefTable:
id | value | refType
variant a)
id is primary key and foreign keys from main tables references to id. ids
are resequnced in the
Knowing only tablename (schema_name.table_name) how to retrieve foreign keys
and related values. (using pg_catalog is preferred). I developing framework
for adobe flex (on php and postgresql).
Already figured out how to get primary key, not null columns and column
types, but kinda stuck here.
I
It seems that query_to_xml function ignores Datestyle settings?
Is this correct? If yes, is there any workarounf except
to_char(date,'dd.mm.');
set datestyle = 'German';
select current_date;
select QUERY_TO_XML('select current_date',true,false,'');
Postgresql 9.0 on Ubuntu 10.04 Server
I would recommend Ubuntu Server 10.04 LTS (long time support - 5 years for
ongoing bug security fixes, and such).
Also, Ubuntu is in focus now, has great community and a most of recent books
on Linux target Ubuntu (which is valid factor for educating people on new
platform).
Ubuntu is great for