Mayfly is an in-memory SQL implementation for unit testing. It is fast on small data sets and you can create or destroy a database as easily any other Java object.
Flat-file SQL (fSQL) is a set of classes available in PHP and Perl that allows users without SQL database servers to select and manipulate flat-file data using SQL queries. fSQL is designed to support as many SQL queries and features as it can.
A tool which transforms a CSV file into another CSV file using a SQL statement.
Also converts CSV to JSON.
Many tools spit out CSV, or are able to as one of output options. Also, in hudson, you can very simply log any values you get into bash like echo " $val2, $val2" >> data.csv, for each
... [More] build or part of a build. So it can be kind of integration tool.
Then you can do quite complex queries – from a flat table, you can actually do subselects and then left joins, which gives you very powerful tool to process the data into something what is ready for plotting as-is – that means, data filtered, cleaned, aggregated, converted, aligned, sorted, etc.
Example:
crunch input.csv output.csv "SELECT AVG(duration) AS durAvg FROM (SELECT * FROM indata ORDER BY duration LIMIT 2 OFFSET 6)"` [Less]
ThinkSQL is a cross-platform RDBMS. Compliance with the SQL standard means it supports transactions, sub-selects, views, set operators, and referential constraints. It has a multi-versioning engine and native ODBC, JDBC and Python drivers.
A non-SQL, truly relational database management system and programming language, based on the principles laid down in the book "Foundation for Future Database Systems: The Third Manifesto" by C. J. Date and Hugh Darwen.
This site uses cookies to give you the best possible experience.
By using the site, you consent to our use of cookies.
For more information, please see our
Privacy Policy