Linux$ gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so Compile it: Mac$ gcc -fno-common -dynamiclib extension-functions.c -o libsqlitefunctions.dylib.Fetch the source code for the extension here.Luckily, this is possible in SQLite through a simple extension. Working with my data in a relational database I found that there were only one piece of functionality that I was missing, and that was the possibility to select out both an average _and_ the standard deviation of a data set. "When are you coming to the stdev part!", you say? Calm down, I'm getting there. All other questions about the data, and how the different test results relate to each other, can thus be formulated in simple SQL instead of through increasingly complex Python scripts. So instead of writing a lot of data handling scripts, this time I have written only one - a script that imports the log data into an SQLite database. This small relational-database-in-a-file is excruciatingly easy to use from almost any programming language you could think of. I have done this a thousand times before. Normally I would be logging such data into flat files, collecting some giga bytes of log files that I would then need to write a handful of Python, Perl, or Ruby scripts to make any sense of. At the moment I am collecting data - hoards of data - my test suite is a veritable cornucopia of boring data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
August 2023
Categories |