Sapper VS datasette

Compare Sapper vs datasette and see what are their differences.

Sapper

The next small thing in web development, powered by Svelte (by sveltejs)

datasette

An open source multi-tool for exploring and publishing data (by simonw)
Our great sponsors
  • Activeloop.ai - Optimize your datasets for ML
  • Scout APM - A developer's best friend. Try free for 14-days
  • Nanos - Run Linux Software Faster and Safer than Linux with Unikernels
Sapper datasette
26 51
7,154 5,514
0.1% -
7.0 9.3
24 days ago 7 days ago
TypeScript Python
MIT License Apache License 2.0
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

Sapper

Posts with mentions or reviews of Sapper. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-10-07.
  • How I Redesigned My Website With SvelteKit
    dev.to | 2021-10-07
    So after using Sapper for some time, I decided to move my website to SvelteKit. I remember saying that I would not move to SvelteKit till they hit version 1 but the framework looks too promising. It had features which I needed and those features weren't in Sapper.
  • Journey to Svelte (through Gatsby)
    dev.to | 2021-09-22
    By that time, we had some troubles with virtual dom itself in our custom rich text editor that we based on slate - it was getting a bit laggy when creating huge financial documents (they usually have enormous tables and a lot of infographics) -so we were already thinking about other options and that’s where svelte comes into the light - especially sapper which was de facto default framework to be used with svelte at that time (SvelteKit wasn’t even announced).
  • Deploying Sapper application to Deta.sh
    dev.to | 2021-09-03
    Sapper is a framework for building web applications of all sizes, with a beautiful development experience and flexible filesystem-based routing. It is the predecessor of Sveltekit.
  • Conheça o que são as siglas CSR, SSR e SSG
    dev.to | 2021-08-27
    Sapper - ecossistema Svelte
  • I'm building a web app that aims to combine features from CodePen, Reddit, Medium, Dev.to, and Stack Overflow
    reddit.com/r/webdev | 2021-07-10
    Lol I won’t, and to answer your question, it’s built using sapper: https://sapper.svelte.dev
  • Sveltekit - to use or not to use?
    reddit.com/r/sveltejs | 2021-07-09
    I maintain a Svelte Starter Kit and all I had to do between several updates is change the layout file names, simplify the hooks, and convert the config file extensions. If you're learning Svelte in 2021, you shouldn't miss learning it, as it's "the missing CLI" and the svelte team's favoured project structure, to build full-stack server rendered and static sites, with File/Folder based routing, focus on server-less with adapters, API routes, and good baked-in conventions and constructs to support common web app needs. It's a successor to Sapper which served the aforementioned needs, with exception of adapters, which is special/unique(with no officially provided parallels in Next.js/Nuxt ecosystems yet) way to make vendor-agnostic, server-less first deployment concern a seamlessly integrated part of the framework.
  • Javascript's import vs require?
    dev.to | 2021-05-28
    Since Node v12, ES modules has been enabled by default. Hence my use of '.mjs' to run my file including a node module. Another way to resolve this issue is to use import with Node.js, you have to edit the package.json to 'type':'module'. However, using this caused my Sapper server to crash since it wasn't supported, as the rollup file outputs the format to commonjs Explained in (this GitHub issue).
  • planning to learn svelte for front-end, need advice
    reddit.com/r/sveltejs | 2021-05-23
    I am not sure whether or not they help you, but both svelte.dev and sapper.svelte.dev are open source. both of those projects are built on sapper, not svelte-kit, but a quick look at kit.svelte.dev/migrating should be enough to see what changed. (both of those make heavy use of markdown files so I don't know how helpful they are, also if you need help translating something from sapper to svelte-kit just reply and I'll probably be able to help)
  • Difference between SSR, SSG, CSR and SPA
    reddit.com/r/nextjs | 2021-04-11
    SSR (Server Side Rendering): the process of receiving a request from the client, e.g: a user goes to https://example.com to load the homepage, and returning a rendered version of the webpage with all the needed info and data to load it as fast as possible. Examples of this are [NextJS](https://nextjs.org), [NuxtJS](https://nuxtjs.org/), [Angular Universal](https://angular.io/guide/universal), [SvelteKit](https://kit.svelte.dev/) (currently in Beta) and [Sapper](https://sapper.svelte.dev/) (currently going deprecated);
  • Getting my SvelteKit website on Netlify
    dev.to | 2021-04-10
    But wait a minute? The local version is not working anymore? Apparently, Vite, the local build tool, did not like it when I moved the packages. After trying several things, I gave up. As SvelteKit is still in beta, community resources are scarce. I did found a few Sapper examples, the predecessor of SvelteKit, using the adapter-static. Success! Well... kind of.

datasette

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-10-21.
  • Turning database into a searchable dashboard?
    This is perfect use case for Datasette, let's you publish your Data & explore it and it will let your users execute SQL queries as well. https://github.com/simonw/datasette
  • 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.

What are some alternatives?

When comparing Sapper and datasette you can also consider the following projects:

SvelteKit - The fastest way to build Svelte apps

duckdb - DuckDB is an in-process SQL OLAP Database Management System

awesome-svelte-kit - Awesome examples of SvelteKit in the wild

nocodb - :fire: :fire: :fire: Open Source Airtable Alternative - powered by Vue.js :heart:

docsify - 🃏 A magical documentation site generator.

openapi-generator - OpenAPI Generator allows generation of API client libraries (SDK generation), server stubs, documentation and configuration automatically given an OpenAPI Spec (v2, v3)

sql.js-httpvfs

Alpine.js - A rugged, minimal framework for composing JavaScript behavior in your markup.

hotwire-rails - Use Hotwire in your Ruby on Rails app

Papercups - Open-source live customer chat

ra-data-hasura - react-admin data provider for Hasura GraphQL Engine

vite - Next generation frontend tooling. It's fast!