Database as a service project on icp coming soon

General
1

I am building a project currently on icp to onboard web 2 developers easily to icp .
This project provides developers with an interface to choose the type of query language they are most familiar with and spawns a database canister that houses the database , this database canister can be interacted with the canister url

2 Likes
2

Sounds cool. Are there some query languages that you’ll be prioritising initially, and will you be aiming to implement the full feature set of a particular language, or just the main features? I can imagine the query engine being a lot of work!

3

I am presently implementing for sql , so I am using some sql parsers to parse the request strings into query structs which are then executed in a miniature implementation of SQLite

1 Like
4

With SQLite running inside a canister?

5

A miniature implementation of SQLite running in a canister

6

Cool, I wonder if you’ll run into issues with the non-deterministic functions that SQLite implements. I can imagine this being harder than it sounds.

Eitherway, sounds like a useful project :ok_hand:

7

Great idea. Curious what will be the connection protocol? Something like the pg protocol wouldn’t work well as ICP won’t support long-living connections. So just strings?

IMO, having a simplistic SQL engine that passes an (even small) number of SQL tests and that can be imported as a Rust module when building a canister would be a great first step.

1 Like