ibis-datasette
csvs-to-sqlite
| ibis-datasette | csvs-to-sqlite | |
|---|---|---|
| 1 | 4 | |
| 11 | 859 | |
| - | - | |
| 0.0 | 0.0 | |
| over 1 year ago | 4 months ago | |
| Python | Python | |
| BSD 3-clause "New" or "Revised" License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ibis-datasette
-
ibis-datasette: Query datasette servers without writing a line of SQL
To help acquaint myself with more of the internals, I hacked up a new backend for querying [datasette](datasette.io/) servers. Datasette is a multi-tool for publishing and exploring SQLite databases. It's an excellent tool, I cannot recommend it enough.
csvs-to-sqlite
-
Turning database into a searchable dashboard?
Oh what's that you say, your data is in CSV and you don't want to write code to load them up into a database, well try this https://github.com/simonw/csvs-to-sqlite
-
Show HN: Work with CSV files using SQL. For data scientists and engineers
The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite
-
Datasette 0.58: The annotated release notes
There's csvs-to-sqlite which allows converting CSVs to SQLite (dumping part of another database to CSV should be more or less trivial). There's also Dogsheep, which can convert more esoteric data sources like GitHub and HackerNews to SQLite. Recently, Simon worked on Django SQL Dashboard, which brings a subset of Datasette to Django.
-
I made a regexp cheatsheet for grep, sed, awk and highlighted differences between them
And sometimes it's nice to throw csv files into a database. You can do that with https://github.com/simonw/csvs-to-sqlite
What are some alternatives?
twitter-to-sqlite - Save data from Twitter to a SQLite database
db-benchmark - reproducible benchmark of database-like ops
healthkit-to-sqlite - Convert an Apple Healthkit export zip to a SQLite database
octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
textql - Execute SQL against structured text like CSV or TSV
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
datasette - An open source multi-tool for exploring and publishing data
sqlite-utils - Python CLI utility and library for manipulating SQLite databases
datasette-graphql - Datasette plugin providing an automatic GraphQL API for your SQLite databases
superintendent - Write SQL on CSV files
cq - Query CSVs using SQL
xsv - A fast CSV command line toolkit written in Rust.