This was supposed to be the site where the creme de la creme, the best of the best, Silicon Valley stalwarts discuss the cutting edge of computer science. Now, before yinz flip out, you asked a question, and I will give you my honest answer.
The above "MS SQL Server solutions" are more complicated than a single SQLite file queryable with a zero-install Sqlite CLI utility.īut hey, offering up "alternative solutions" with a condescending tone is regular sport for HN so I guess we all roll with it. Now we're asking recipients to have MS SQL Server installed and ATTACH the mdf file. Option B: Let's export to single MDF file. You either have to re-import into another tool that can run SQL commands or import into Excel to play with filters. Ok, we now satisfied the single file property - and that's if we pre-join all relational tables into a diskspace-hogging output where columns repeat redundant denormalized data. Option A: Let's say we export to a single text CSV. So to entertain that suggestion, what single file would MS SQL Server export? Export to single file isn't nothing new." "I do exactly the same with traditional RDMS. its tone will also be perceived as condescending: I never downvote pjmlp's posts but the following type of comment isn't just opinionated. (2) the file is queryable (with SQL language) It's that his solution isn't even appropriate for the gp's scenario that had these 2 desirable properties: The issue isn't that he's mentioning a specific tool that a minority uses. >based on comments I see, MS SQL Server users are a minority here, to be relatively on topic, there were a ton of DBMSs that simply failed and others that started nice but created stinkers so awful that killed the entire company - see dBase as a great example for that) (and TBH i do not completely disagree with this view myself, though i do not see the point of repeating it everywhere, this train not only left the station long time ago but the station has long been converted to an Amazon warehouse - besides it isn't like the development tools of old were always that great. His comments basically follow out of this starting point so if you have that in mind they start to make sense.
#Sqlite command line based free
Pjmlp longs for the days when developers (and/or their employers) paid for their tools because he believes that this allowed them to create tools of higher overall quality than the free FLOSS stuff you find nowadays that may excel in one area which developers find interesting/fun but are awful in several others and largely proliferate not because of their quality but of their price.
0 kommentar(er)
