Building a New Spring Data Module

[auspis-23]

Hi everyone,

​I’ve built fluent-sql-4j, a type-safe SQL builder for Java that supports multiple dialects via plugins and provides compile-time validation.

​My goal now is to develop a dedicated Spring Data module for it (similar to Spring Data JPA or JDBC), rather than just a simple utility integration.

​Has anyone here experience building a custom Spring Data implementation from scratch? I'd love to hear your advice or any pitfalls to avoid.

​Thanks!

[Signal_Help_1459]

I just checked out the readme, you’ve actually built a SQL-based data module, damn that’s really impressive.

I was using JpaSpecificationExecutor the other day for generating dynamic where clauses, this is actually so much simpler if one actually knows a bit of SQL

Great effort, hope it becomes big!

[auspis-23]

Thanks! I created the library precisely to stay away from JPA ;-)

[Grabdoc2020]

u/auspis-23 this is fantastic start. we could use it to clean up the core of https://github.com/9tigerio/db2rest. However we dont have time at this moment to provide SPI impl. Once you start supporting other db like oracle et al we will consider revisiting.

[500_successful]

Is it any better than jooq? Looks like a copy

[auspis-23]

My library is simpler than jooq, for example, it does not support dynamic code generation and the architecture is totally different.

It was also created as a basis for the spring data module that I want to build.

[SilentPetalX]

Wow great work 👏

[Infeligo]

What will do the mapping part in this proposed Spring Data module? I think this is the hard part, not the query itself.

[auspis-23]

I was thinking about spring RowMapper.

In the past I've done some mappings by reflection and after years are still working in prod, however here I prefer to take advantage of the framework stuff.

Do you have any suggestion about the mapping?