|
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 |
|
Jan
7 |
|
asked | Schema-less/flexible + ACID database? |
