db-to-sqlite
csvs-to-sqlite
db-to-sqlite | csvs-to-sqlite | |
---|---|---|
1 | 4 | |
334 | 859 | |
- | - | |
0.0 | 0.0 | |
about 1 year ago | 5 months ago | |
Python | Python | |
Apache License 2.0 | 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.
db-to-sqlite
-
Show HN: I built an open-source data copy tool called ingestr
I was surprised to see SQLite listed as a source but not as a destination. Any big reasons for that or is it just something you haven't got around to implementing yet?
I've been getting a huge amount of useful work done over the past few years sucking data from other systems into SQLite files on my own computer - I even have my own small db-to-sqlite tool for this (built on top of SQLAlchemy) - https://github.com/simonw/db-to-sqlite
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?
db-benchmark - reproducible benchmark of database-like ops
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.
q - q - Run SQL directly on delimited files and multi-file sqlite databases
dotfiles - 💻 my personal dotfiles: no more, no less