paulbares

7 ms·

1. 1.▲
   by paulbares 3y ago

   I am building a SQL like query engine with a typescript query builder. It aims to provide multidimensional query capabilities (think about olap cube). The query engine is compatible with several databases (sucks, clickhouse, bigqueryx, snow
2. 2.▲
   by paulbares 3y ago

   I found it too cumbersome, limited and not very intuitive to do it in SQL with the PIVOT operator so that I created my own API to be able to build a pivot table from a simple SQL statement https://github.com/squashql/sq
3. 3.▲
   by paulbares 3y ago

   I am building a sort of SQL query engine compatible with several databases (bigquery, snowflake, duckdb, clickhouse, spark) in order to add more power to the SQL query language bringing multi dimensional capabilities to SQL and more. The pr
4. 4.▲
   by paulbares 3y ago

   > MySQL to PostgreSQL is extremely rare in the real world. That's true, I agree. But we are mainly targeting software editors that build data analytics platform and let their customers choose where they want to store their data and
5. 5.▲
   by paulbares 3y ago

   I am building squashql-js for a slightly different use case (database agnostic SQL-like Typescript query builder among others) but Kysely and pypika (for Python) have been a great source of inspiration. https://github.com/sq
6. 6.▲
   by paulbares 5y ago

   I wrote a small library https://github.com/paulbares/spring-testcontainer that provides integration between the Spring (Data JPA) testing framework and Testcontainer library to easily test my application with different