🌀 Airsequel 0.5 - Improved Spreadsheet UI, AI-Powered SQL Query Generation, and more!

Show and Tell
1

I’m excited to announce the release of Airsequel 0.5! :tada:

I’m posting this here, because our goal is to become the easiest to use backend for Elm apps. (Also, our complete frontend is written in Elm.) Check out the tutorial: How to build a todo app with Airsequel and Elm !

This is our biggest release yet with more than 500 commits! If you’ve been holding off trying out Airsequel, now is a good time to get your feet wet! :grin:

Here are some of the highlights:

Spreadsheet UI:

  • More column data types, including
    file, date, URL, color, phone, email, time, and more
    2023-03-28t154614_landing_page copy.png
  • Re-order columns and tables and insert new columns in specific locations
  • Export tables as CSV or JSON

SQL Workbench:

  • AI-powered SQL query generation via OpenAI
    Screenshot of AI prompt
  • Tabs for working on several SQL queries simultaneously
  • Support for editing views
  • Upgraded SQLite from version 3.38.5 to 3.41.0, adding support for RIGHT and FULL OUTER JOIN and the built-in unhex() function
  • Enforcing SQLite’s foreign key constraints by default

GraphQL API:

  • Support for requesting changed data with the returning keyword
  • Support for more comparison operators: neq, gt, gte, lt, and lte

Additional Settings:

  • Show separate tabs for “Tables” and “Views”
  • Button to regenerate read-only ID
  • “Template” database environment (can be cloned via its readonly URL)

For a full list of all changes, check out the changelog!

We also have a newsletter if you want to get to get any news right into your inbox: Airsequel Updates • Buttondown

We’re committed to making Airsequel the best tool for working with SQLite databases and using the data in production, and version 0.5 is a significant step forward in that direction. I hope you’ll try out these new features and improvements and let me know what you think! :blush:

9 Likes
2

These links in the todo app example lead to 404 pages:

I think it should be:

1 Like
3

Good catch and thanks for the heads up! I just fixed it! :blush:

4

This is amazing. I love seeing how Elm is used in production. Thanks for sharing. :slight_smile:

1 Like
5

Awesome!
Well done @ad-si!
I love seeing Airsequel evolve :smiley:

1 Like
6

Looks cool!

Does this run locally, or only in combination with the cloud service?

What is the license of the code? I can only use freedom-respecting software in my projects, but it’s really hard to tell if Airsequel is a Free/Libre/Open option from the current websites. I assume it’s proprietary?

7

Looks cool!

Thank you! :blush:

Does this run locally, or only in combination with the cloud service?

Airsequel is (and will stay) a single binary. So I have distributed it to interested persons as a binary and as a Docker image in the past. However, it makes more sense to run it as a cloud service. You can see the available options here: Airsequel

What is the license of the code? I can only use freedom-respecting software in my projects, but it’s really hard to tell if Airsequel is a Free/Libre/Open option from the current websites. I assume it’s proprietary?

Yes, currently it is proprietary. However, it’s very important to us to guarantee your data sovereignty and to not lock you in. I.e. all customer data is stored in 2 SQLite databases (one for the main data and one for metadata). You can download those databases at any time and move them somewhere els or e.g. build your own backend for them.

But we’ve also been thinking about releasing everything under the AGPL license. However, no decision has been made yet and it would also take some time since we’d have to clean up the code first …

1 Like
8

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.