I'm moving to a style of programming where instead of using serde_json, I use rusqlite/diesel, and store all state in Sqlite3.
I now have a number of tasks of the form "take this file which has a bunch of data in an ad-hoc, ill-defined, sorta-specified format ... and convert them into a Sqlite3 table."
Because there isn't a Context-Free-Grammar defined upfront, the work involves alot of: read some data, print it out, try to parse it, get some error, etc ... (i.e. 99% of the battle is defining the types that one would derive JSON encode/decode on)
-- because of the above, alot of the work is: repl oriented, exploring the data to see how it's structured.
If you have run into problems similar as the above, what language / setup do you use for converting "structured but no formal grammar" to "nice SQL tables" ?
I've ran into a bottleneck in my program with sqlite, which is basically single threaded. I was able to easily parallelize most of my code to get 8x speedup, and all the perf tricks for sqlite maxed out at 1.5x-2x or so. So beware. Use postgres or some other storage.
I'm not sure how bad your grammar is. In the worst case, the Rust regex crate is quite good and fast (but pcre available in other languages is fine too). If there are structured bits in the data, then nom is quite nice for making parsers.
I botched this question. The issue here is not how long it takes to run the ETL process, but the developer time it takes to write the ETL code.
So I have this situation where I have lots of random input data formats, I want a ETL process that, for each case, stuffs it into a nicely formatted Sqlite3 Table (which I can then use Diesel with).
The issue is -- what is a good workflow for writing lots of one-off ETL processes.
Oh I see. Rust probably isn't the best choice for write-once-run-once code. You don't need speed, you don't need security, you don't need maintainability.
Unless, you'd like to write some kind of framework for processing, essentially reinventing a Perl interpreter in Rust
Thanks for the "debugging" help. Now that I've rephrased the specs, it's pretty clear that this isn't a Rust question (and Rust isn't the right answer).
For this sort of once-off thing I'd normally either hack together a quick bash script or sed/awk/grep pipeline (for simple transformations) or write it in Python using some sort of interactive interface like a Jupyter notebook.
Normally it's more effort than it's worth to write a Rust program for this. You'd spend a lot of development time getting the types in order, properly handling errors, and getting everything to compile than actually getting anything done. Unfortunately that's one of the disadvantages of using a statically typed language.
Amazon Turk or some freelancer. If there is enough data, you can combine this with machine learning later.
If I'd really have to do it myself, I'f go with some interactive process: go through what parses, for the rest open text editor and fix data or parser, try to apply fixed code for remaining data.
Python Pandas or R dataframes or Julia DataFrames package. DataFrames packages are written specifically to deal with exploratory or ad-hoc data tasks like this where you need to take poorly type specified data, give it structure, map-reduce or groupby or split-combine-apply, and process it in some way initially for later downstream processing. R and Pandas are the industry standard.