3 ms·
Frameworks / ORM are just specilized database user interface front ends designed to simplify how data can be used (displayed/inputted/manipulated). They can al
by sargstuff 2y ago
Frameworks / ORM are just specilized database user interface front ends designed to simplify how data can be used (displayed/inputted/manipulated). They can also display known databases/table, such that the user just has to select what's needed (or doesn't have to worry about tables/field -- just the display/forms to get results.
Database management systems usually provide a way of importing/exporting 'raw' data via sql statement(s) results. aka cvs, comma delimited, html formatted, json formatted.
Outside of a framework/ORM from command line / operating system shell; can do a command line sql query with 'html formatted output' and open results of file in a brower. Obvious catch of not using 'tools/environment' is gotta do all the data input cleanup/checks; output formatting for display/printing, such as only want 4 lines of output per printed page.
Note: will have to provide database(s) to access information from via databases specific method!
example programs that provide access to sql via command line:
postgres psql provides an interactive 'cli' environment for using sql
windows sql server - sqlcmd;
usql[1] provides something similar to psql for no-sql databases.
---
sqlc is sorta the equivalent of combining the command line shell & sql queries. The 'c' portion of sql, is c language. So, outside of sql, on own to write what ever 'shell' functionality needed using c.
SQLx rust is rust extention for handling 'sql from command line, just via rust language, instead of going through command line shell.'
except, rust language also handles the internet protocols/language extentions for doing rest crud / sql / rust in a single app.
There are program(s) usable from a command line shell (cli) that would provide 'rest crud'.
Different levels of packaging provide differing levels of control/amount of hoops have to jump through. (just raw data, data & usage, just usage)
Unlike databases, spreadsheets provide an interactive gui up front, with 'embedded language' providing the 'data manipulations' aka visual, python, etc. spreadsheet data can be retreived from / sent to a database.
----
[1] : https://github.com/xo/usql https://github.com/xo/usql