search

meteor / postgres-packages

Early preview of PostgreSQL support for Meteor (deprecated, here for historical reasons)
http://meteor-postgres.readthedocs.org/
159 stars 25 forks source link

Design efficient schema for accounts #4

Open stubailo opened 8 years ago

stubailo commented 8 years ago

Right now, there is a super hacky schema for Accounts in the example apps. Since I am not a SQL expert, I don't know what the best schema design would be - how expensive are joins in this case, etc?

It would be awesome if someone who knows more about SQL schema design could give some pointers.

laran commented 8 years ago

Where are the migrations or whatever creates the schema? I saw bits of bookshelf and knex but didn't find a schema or migrations anywhere.

So glad you guys are working on postgres support!

stubailo commented 8 years ago

We're currently working with the Rocket.Chat team to design a working schema and decouple accounts from mongo. I'll link to the right place once we have some code up.