Apr
1
awarded Nice Question
Aug
4
awarded Teacher
Aug
3
answered Resources for learning Lisp
Aug
3
answered Getting started with LISP
Jan
9
comment Separate Schemas by Industry or by Application functionality?
filiprem: Thanks for the helpful answers. ((Somehow I am not able to @ your name :-). It disappears))
Jan
8
awarded Scholar
Jan
8
accepted Separate Schemas by Industry or by Application functionality?
Jan
8
comment Schema-less/flexible + ACID Database?
@DuncanPauly: Thanks for the pointers.
Jan
8
comment Separate Schemas by Industry or by Application functionality?
.@filiprem,Thanks for taking time to answer this. The searchpath definitely gets the schema qualifier out of the way, making easy to write sqls. But, as the schema are used as namespcaes in pgsql, for each schema I guess one set of table, db objects will be created. If I end up say having 'x' number of schema, will this take a) more space b) any performance impact? And also, are there any economic impact like increased cost due to more RAM or disk space etc., Thanks again.
Jan
8
comment Schema-less/flexible + ACID Database?
@DuncanPauly: Thanks for the insight. I understand from your answer that Postgresql allows 'online/live schema change'. But, when I google, I get mostly 'facebook online schema change' or 'pt-online...' etc., which pertain to MySQL. Would you know of a link or material which helps me understand live schema change for Postgresql? Appreciate your help. Thanks.
Jan
8
awarded Supporter
Jan
8
comment Separate Schemas by Industry or by Application functionality?
@Simon: I agree it is a valid concern. Based on what I read, in the SaaS land, many biggies including Salesforce.com use this "multi-tenant data being in single DB" approach (I might be wrong). With proper security measures, can't the data be co-located in a shared database? I am referring to this link. [MSDN article]: msdn.microsoft.com/en-us/library/aa479086.aspx
Jan
8
comment Separate Schemas by Industry or by Application functionality?
Thanks for the answer. I am pretty new to the SaaS multi-tenant arch.Based on what I read MSDN article, I liked the "Shared schema, Shared Database" (SSSD) approach with tenant-ids and view filters to isolate data access. It might be a separate DB as you suggested per app. But, do I really need a schema per customer? Can't I manage with a single schema per app. (discounting public)? I was thinking that Salesforce.com is running with this approach.(I might be wrong). What are the downsides of taking this approach? Or is it doable?
Jan
8
comment Separate Schemas by Industry or by Application functionality?
Thanks for the answer. I am pretty new to the SaaS multi-tenant architecture. Based on what I read and understood, e,g.,(), I was thinking of taking the Shared schema, Shared Database approach.
Jan
8
awarded Editor
Jan
8
revised Separate Schemas by Industry or by Application functionality?
Added quetion
Jan
8
asked Separate Schemas by Industry or by Application functionality?
Jan
8
comment Schema-less/flexible + ACID Database?
@COTW: Thanks for the detailed answer. One major thing I was concerned with was the "anticipated" change of schema, which I guess I have to think through and make it as much "pre-configurable" as possible upfront and avoid drastic schema changes later.
Jan
8
comment Schema-less/flexible + ACID Database?
@horse: Thanks...It's a good pointer. I've heard NoSQL plugins for MySQL . I was looking out similar for Postgres.
Jan
7
awarded Student
1 2