Timeline for What are the pros and cons of adding SQL columns in run time, vs through a different design time architecture?
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 31, 2020 at 4:32 | comment | added | Manish M | Thank you, this is just the kind of feedback I was looking for! Sorry for the late acceptance of your answer. There is a separate windows service/engine which I believe does the database schema changes. However I've just documented a feature that lets 'admin' users craft full SQL queries directly on the web page to modify the resulting charts. At least they have to be part of a local (web server) AD group to be able to do this FWIW. Great point re performance. Definitely relevant to our app - typically 10-30 columns and sometimes over a million rows. Multi-user too. | |
| Aug 31, 2020 at 4:06 | vote | accept | Manish M | ||
| Aug 7, 2020 at 7:04 | history | answered | Mad Scientist | CC BY-SA 4.0 |