grouparoo VS Baserow

Reverse ETL is on AirByte's roadmap under the "Future / Not prioritized" section. I wanted to use Grouparoo as a short term solution, but the repo was archived and I think they stopped taking new cloud customers (unknown if this is wrong/outdated).

There are other tools that we will have to adopt in the future but haven’t yet due to lack of necessity. Specifically, one category that is popular in modern data stacks is Reverse ETL (Hightouch, Census, or Grouparoo). We currently don’t have a usecase for piping data back into 3rd party tools but it will definitely come up in the future.

Reverse ETL: Grouparoo, Castled

Grouparoo, the open source Reverse ETL tool we are building, does all of these things. https://www.grouparoo.com

Ingestion / ETL: Airbyte, Singer, Jitsu Transformation: dbt Orchestration: Airflow, Dagster Testing: GreatExpectations Observability: Monosi Reverse ETL: Grouparoo, Castled Visualization: Lightdash, Superset

Grouparoo | Remote (US) | Remote-OK | https://www.grouparoo.com

Grouparoo is a venture-backed software company building open source data tools that make data reliable, accessible, and actionable. We’re empowering teams to make great customer experiences, driven by data. While engineering teams have gotten good at storing and generating data about their customers, it’s rare that this data is used to its full potential in external applications. Grouparoo makes these integrations easy by providing a framework for defining your customer data and reliably syncing it to external tools.

To learn more about who we are, our engineering culture, and whether this is the right place for you, read our Key Values profile: https://www.keyvalues.com/grouparoo

Here are our open roles:

- Senior Backend / Lead Engineer: https://jobs.lever.co/grouparoo/6ba485d1-a5a4-41f0-9fa5-920a...

- Developer Advocate: https://jobs.lever.co/grouparoo/5e1531b4-7ec8-4c10-8e52-fc23...

Tech Stack: TypeScript / Javascript / Node.js, ActionHero, React + Next.js, Postgres & Redis, and whole lot of third-party APIs!

Congrats on the launch! Hightouch looks great and this need is real. Things seem to be going well, so I don't think I'm taking too much away by mentioning that we have been been working on Grouparoo, an open source alternative that solves similar pain points.

A few differences: git developer workflow focused (branches, CI, PRs, etc), ability to self host, segmentation in destinations (tagging people in mailchimp based on rules, for example)

https://www.grouparoo.com

We are building Grouparoo. Obviously, it's a biased sample but we are seeing a few trends at play.

Has anyone heard or used of reverse etl or Hightouch or open sourced Grouparoo?

4. Baserow - 1.5k ⭐️

GitLab repository: https://gitlab.com/bramw/baserow.

💬 Follow us at @baserow on Twitter for staying in the known of all company updates and news. ⌨️ Join the Baserow community forum to chat with other developers and the Baserow team. ⭐️ Star Baserow on GitLab to show your appreciation of our work.

Check out the full roundup: https://baserow.io/blog/1-14-release-of-baserow. Test out Baserow 1.14: https://baserow.io. GitLab repository: Bram Wiepjes / baserow · GitLab.

Baserow

I'd also written an article on token authentication for django: https://www.spapas.net/2021/08/25/django-token-rest-auth/ using the REST Framework's TokenAuthentication.

This is simplest thing for most cases.

The session authentication that is proposed in the article is also great but has two problems:

* It will be hacky to implement for mobile apps (it should be possible but would not be something I'd like to do, I had tried in the past and remember that I needed to jump to a lot of hoops to "pick" that session cookie)

* The cookies can't be shared between different domains (cookies be shared the same domain or between a parent and child domain, i.e api.example.com can set/get cookies from .example.com).

So you can use the SessionAuthnentication if your frontend and backend share their domain and you know that your API won't ever be used for mobiles apps. On all other cases use TokenAuthentication.

I don't have experience with JWT Authentication, however I know it can be done and is used be various apps f.e baserow: https://gitlab.com/bramw/baserow/-/blob/develop/backend/src/...

Feel free to dig into https://gitlab.com/bramw/baserow repository, e.g. https://gitlab.com/bramw/baserow/-/blob/develop/backend/Dockerfile... There are docker compose files too.

Great idea! I've created an issue for it on the backlog https://gitlab.com/bramw/baserow/-/issues/1399.

Here is the full scoop on all new things: https://gitlab.com/bramw/baserow/-/releases/1.13.1.