Show HN: Restapp.io – SQL Data Modeling Tool in No/Low Code

[BXScore]

https://os.restapp.co/signup

Hey all!

We've been working on RestApp V1 and this is our first time posting it on HN.

It's an No/Low Code data modeling tool that enables you to build & maintain data pipelines with a visual programming interface. We don't store your data but we compute them through Apache Spark for query speed & efficiency.

Here's some features:

`Connectors: Connect to any source and destinations (DB, DWH and SaaS Applications). We currently support MongoDB, Snowflake, BigQuery, MySQL, MSSQL, SFTP (JSON, txt, csv, excel files supported), Hubspot, Stripe, GDrive (JSON, txt, csv, excel files supported).

`Pipeline: Visual Programming Interface where you drag-and-drop SQL, NoSQL & Python functions instead of writing them to create a query and debug it easily.

`Automation: You can automate your data pipeline (Job) through a scheduler.

`Domain: Think of it like a workspace in which you can share securely your connectors and pipelines to specific users (colleagues, partners, clients...)

We've designed this because as a data team member, we were writing a lot of long SQL queries with bad performances and we were getting headaches by debugging them.

Now you can build, monitor and debug any kind of data pipelines with just Drag-and-drop built-in SQL functions to save you tremendous amount of time & effort.

We're working on this continuously so we're keen to hear any feedback. Feature requests and critique are more than welcome.

Try it out for free (30min of computing time offered each month): https://os.restapp.co/signup

The Getting Started docs are here for anyone who wants to check this out: https://documentator.io/d/documentation-restapp and https://restapp.io/blog/how-to-build-data-pipelines-in-no-co...

[freecodyx]

The landing page should show me what i can expect, not to sign up to discover the product

[BXScore → freecodyx]

Yes, we're working on it but How can we protect ourself to spend too much money on processing if you're not creating an account? By the way, you can test with temp mails

[calrain → freecodyx]

Yup, when I see a demand to register then I just close the window.

I suppose I've been conditioned by those news sites that refuse to show content unless you register/subscribe.

[BXScore → calrain]

Yes I agree but if you feel to test it, try to register with a temporary mail!

[mandeepj → freecodyx]

Exactly! It’s a big turn off

[BXScore → mandeepj]

You can try this product with a temporary email (https://temp-mail.org/fr/)

[hp_hovercraft84 → freecodyx]

No info about how the product works, immediate close.

[BXScore → hp_hovercraft84]

You can just use a temporary email (https://temp-mail.org/fr/), it's free in any case

[borbulon → freecodyx]

hard agree

[BXScore → borbulon]

You can just use a temporary email (https://temp-mail.org/fr/)

[tryithard]

>> we were writing a lot of long SQL queries with bad performances

How your tool makes sure the queries are performant?

Seems this tool connects to cloud DB's only right? how can I access my on-premise DB?

[BXScore → tryithard]

Thanks for the feedback!

The tool is computing the Data pipeline into Apache Spark to rebuild the best way to compute the pipeline and then execute it. No matter how you build your pipeline, Apache will find the best way to compute it. Better performance and efficiency at the same time.

At the moment, it's just cloud DB's only.

[tluyben2]

I am testing it now a bit! I like that I can rearrange the menu items.

[BXScore → tluyben2]

Thank you!

We try to think of it like an Operating System and soon you'l be able to transform data in one screen and see the output in another screen. Saving tremendous time when building/transforming your data pipeline!