2 ms·
> with the exception of spreadsheets and formulas You may want to check Oracles MODEL clause. Not as powerful as a spreadsheet but you can already do a lot of
by arkh 10y ago
> with the exception of spreadsheets and formulas
You may want to check Oracles MODEL clause. Not as powerful as a spreadsheet but you can already do a lot of things in the middle of your SQL.
- danso 10y agoThanks for the tip, hadn't heard about it before but any SQL feature that inspires articles like "Using the SQL MODEL Clause to Generate Financial Statements" [0] is generally the mix of practicality and code that I'm looking for. I suppose one major roadblock is the use of Oracle SQL. Not the language but the database software. I used to teach MySQL and SQLite before settling on solely the latter. First, SQLite can easily handle any database that students have to deal with, which at max are in the gigabyte range (and usually much much smaller than that). Second, there's far fewer moving parts. I mean, they still have to deal with the idea that SQLite is a database, and that something like DB Browser for SQLite [1] is a client, but it's much less of an obtrusive detail than installing MySQL, a MySQL GUI, and then checking to see if the MySQL daemon is running on their personal laptops. [0] http://www.orafaq.com/node/69 http://www.orafaq.com/node/69 [1] http://sqlitebrowser.org/ http://sqlitebrowser.org/