XLSX would be the same workflow with "save as" CSV and then push it into SQLite.
My personal take is, yes, it's possible in multiple other ways, but I just like having a well-designed GUI app do it for me. Just how TablePlus does for Database Management.
MSSQL/SSMS supports this with some fancy techniques.
> This wizard was created to improve the current import experience leveraging an intelligent framework known as Program Synthesis using Examples (PROSE). For a user without specialized domain knowledge, importing data can often be a complex, error prone, and tedious task. This wizard streamlines the import process as simple as selecting an input file and unique table name, and the PROSE framework handles the rest.
> PROSE analyzes data patterns in your input file to infer column names, types, delimiters, and more. This framework learns the structure of the file and does all of the hard work so users don't have to.
https://learn.microsoft.com/en-us/sql/relational-databases/i...
So I guess I can see how not having to do the conversion for quick one-time analysis could be beneficial.
Powershell can query excel files in various ways and there's a module for native powershell excel work: https://www.powershellgallery.com/packages/ImportExcel/5.4.2
It reminds me of Log Parser Studio [1] on Windows. Using SQL to query text and log files is a great idea.
[1] https://web.archive.org/web/20170710212920/http://gallery.te...
I suspect the vendor is going to regret that, further down the line.
Fairly common. JetBrains started that way too. Will they one day have a major version that's using a subscription model? Perhaps. But they will likely not regret this too much.
Where does it say that?
That is common and it is the model I use for my own software. But that isn't what I understood from their website.
Home page: "Pay Once, Use Forever. We hate needless subscriptions as much as you do. TextQuery comes with a perpetual license with free updates."
Pricing page: "Perpetual license Lifetime updates"
Which strongly implies every update is free, forever.
I hate the subscription model but I do recognize if they continously update the software, they'd like to get paid to do so.
gkbrk•6h ago
shubhamjain•6h ago
Yes, even DuckDB has UI now, but I didn't find it to my taste. There's no table view, filters are a bit weird, and not exactly keyboard accessible. TextQuery also has Visualize feature to quickly create charts and tabs to run things in parallel. Again, it's personal preference, but there are advantages in being a desktop-first app.