Datasette Alternatives

Similar projects and alternatives to datasette

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better datasette alternative or higher similarity.

Suggest an alternative to datasette

Reviews and mentions

Posts with mentions or reviews of datasette. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-09-26.
  • Is Data Warehouse just a denormalized data of a database?
    reddit.com/r/SQL | 2021-09-27
    Yes, but you can build one in SQLite if you wanna, see https://datasette.io/ for example
  • I need to find large CSV files of 10k + records for a class, any good websites?
    There are also a lot of example datasets on the Datasette website: https://datasette.io/
  • Hello guys, I have a question and I hope this doesn’t sound too stupid. I’m sorry if it does. I’m going to make the database of a company (not a big company) and I’ll be using SQL but what should I use for the employees and employers to view it?
    reddit.com/r/Database | 2021-09-23
    My https://datasette.io/ project is good for providing read-only access to a SQLite database, but SQLite may not be the right tool for you.
  • JupyterLab Desktop App now available
    news.ycombinator.com | 2021-09-22
    I'm working on an open-source desktop app [0] similar to Jupyter but more oriented toward non-data-science developer workflows like querying/joining data from multiple databases and scripting and graphing for internal reporting.

    Another similar tool is Simon Willison's Datasette [1].

    [0] https://github.com/multiprocessio/datastation

    [1] https://github.com/simonw/datasette

  • Why is Confluence Wiki Search so bad?
    news.ycombinator.com | 2021-09-20
    The good news here is that the Confluence API is actually really good, and very easy to integrate with.

    I wrote a custom search engine that worked by running on cron, pulling in all of the content from Confluence and writing it into a SQLite table with SQLite full-text search enabled (using https://sqlite-utils.datasette.io/en/stable/python-api.html#...), then sticking a https://datasette.io/ interface in front of it.

  • General guidance on developing a first database
    reddit.com/r/Database | 2021-09-14
    My https://datasette.io project is designed to help solve exactly thus kind of problem: publishing an interactive database online. You might find that building this using Datasette on Glitch is a useful option - documentation on how to do that is here: https://docs.datasette.io/en/stable/getting_started.html#getting-started-glitch
  • sqlite-utils - my Python library and CLI tool for manipulating SQLite databases
    reddit.com/r/Python | 2021-08-24
    I've been working on this for 2.5 years now. The initial goal was to make it as quick and easy as possible to load data from any source into a SQLite database (so you could explore it with my Datasette tool), but over time it has evolved into more of a Swiss army-knife for working with SQLite.
  • Schema on write is better to live by
    news.ycombinator.com | 2021-08-21
    To be honest it's mostly for fun, and to help me dogfood https://datasette.io/ and come up with new features for it.

    But just a moment ago I was trying to remember the name of the Diataxis documentation framework - I was sure I'd either tweeted about it or blogged it, so I ran a personal search in Dogsheep Beta and turned up this tweet: https://twitter.com/simonw/status/1386370167395942401

    Someone asked me the other day who they should follow on Twitter for Python news, so I searched all 40,000 tweets I have favourited for "Python", faceted by user and told them the top four users.

  • GitHub Issues-only project management
    news.ycombinator.com | 2021-08-21
    "Issues are independent. Properly broken down, work in a project has dependencies"

    A trick I use a lot is to open a "tracking issue" and then link to it from other dependent issues by mentioning its #ID in those issue's descriptions.

    The tracking issue automatically shows the open/close status of those other issues, which means I can see at a glance if all of the dependent issues have been completed.

    Here's an example: https://github.com/simonw/datasette/issues/1105

    It's not nearly as sophisticated as what you're looking for in terms of date estimates and critical paths, but it does work well for light-weight dependency tracking.

  • It's Time to Retire the CSV
    news.ycombinator.com | 2021-08-18
    One of my goals with https://datasette.io is to offer a better alternative for publishing data than sharing a link to a CSV file.

    The trick is that if you compile data into a SQLite file and then deploy the Datasette web application with a bundled copy of that database file, users who need CSV can still have it: every Datasette table and query offers a CSV export.

    But... you can also get the data out as JSON. Or you can reshape it (rename columns etc) with a SQL query and export the new shape.

    Or you can install plugins like https://datasette.io/plugins/datasette-yaml or https://datasette.io/plugins/datasette-ics or https://datasette.io/plugins/datasette-atom to enable other formats.

  • A Future for SQL on the Web
    news.ycombinator.com | 2021-08-12
    Highly entertaining and informative article/project - thanks for taking the time to write about it.

    This is really cool, I wonder if it could be built into something like https://datasette.io/ - without the need for a python runtime.

  • CALISHOT 2021-08: Find ebooks among 403 Calibre sites
    If you really want to please me, consider sponsoring Simon Willinson the author of the framework I'm relying on .
  • How to create a frontend that allows users to filter through a large dataset (MongoDB) with asynchronous data fetching (Flask)?
    reddit.com/r/webdev | 2021-08-04
    possible option for analytics and fixed data set - https://github.com/simonw/datasette
  • Open source products which turn SQL database into API with web UI (think Airtable and Google Spreadsheet alternatives). Low code.
    reddit.com/r/mysql | 2021-07-23
    Does https://datasette.io/ meet your need?
  • Show HN: Work with CSV files using SQL. For data scientists and engineers
    news.ycombinator.com | 2021-07-18

Stats

Basic datasette repo stats
50
5,495
9.3
7 days ago

simonw/datasette is an open source project licensed under Apache License 2.0 which is an OSI approved license.

Find remote Python jobs at our new job board 99remotejobs.com. There are 10 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.