3 ms·
Why the camel cased columns?
by vhost- 10y ago
Why the camel cased columns?
- koistya 10y agoGood question. This db schema is supposed to be used by web developers. With camelCase columns it might be easier for developers to query the database directly from the code (unless they use an ORM, in that case snake_case should also work well).
- yeukhon 10y agoHow so? It doesn't really matter. With uppercase you now have to put quote in SQL, I am not sure other drivers, but in psql you do. Just saying.
- koistya 10y agoBTW, there is also a PostgreSQL flavor of this schema. That one is using snake_case convention for column names: https://github.com/membership/membership.db/tree/master/postgres https://github.com/membership/membership.db/tree/master/post...
- HNSucksAss 10y agoWhy not? How else would you name columns? The real question is why you'd name a key column "id." I call mine "ID." But maybe this guy's a big fan of Jung or something.