SQL Components

SQL Components is an open source persistenace framework for moden java apps which helps to build the robust and high performing applications.

High lights of SQL Components

• Compile time ORM
• Write less, do more - Autometic code generation
• Supports major RDBMS and adding many more
• Type Safety - Captures the defects at as you write code with compile time type safety.
• SQL knowledge is the only requirement to use this.

Use in other Maven projects: add the org.sqlcomponents:maven-plugin plugin and a sql-component.yml; see docs/maven-plugin.md. Publish to Maven Central: docs/maven-central-hosting.md.

#sqlbridge

Large

Offload DB Techniques Validation Batch Optimize Dialects Cache

Fantastic 4

SQL Preventive - Wrong Queries Functions (String)

• Build Time
• Startup
• Runtime
• JDBC

Clean Code = Opensource / Checkstyles/ Documented

reference

1. https://dev.mysql.com/doc/index-other.html
2. https://blog.timescale.com/blog/why-sql-beating-nosql-what-this-means-for-future-of-data-time-series-database-348b777b847a/
3. https://blogs.oracle.com/oraclemagazine/deliver-oracle-database-18c-express-edition-in-containers
4. https://www.tutorialspoint.com/jdbc/jdbc-data-types.htm
5. https://www.progress.com/blogs/jdbc-tutorial-extracting-database-metadata-via-jdbc-driver
6. http://techdoc.kvindesland.no/java/docs/guide/jdbc/getstart/mapping.doc.html
7. https://www.progress.com/tutorials/jdbc/designing-performance
8. https://jdbc.postgresql.org/documentation/81/geometric.html
9. https://jdbc.postgresql.org/documentation/head/escapes.html#escape-use-example
10. https://github.com/bwajtr/java-persistence-frameworks-comparison
11. https://engineering.fb.com/2021/07/22/data-infrastructure/mysql/
12. https://mariadb.com/resources/customer-stories/dbs-bank-oracle-to-mariadb/
13. https://www.infoq.com/news/2022/04/red-hat-releases-hibernate-6/
14. https://www.youtube.com/watch?v=ykoUBctblno
15. https://www.youtube.com/watch?v=XaC1rQZ_LKs
16. https://medium.com/@jerolba/persisting-fast-in-database-1af4a281e3a
17. https://medium.com/@jerolba/persisting-fast-in-database-jdbc-76912ec2ef42
18. https://medium.com/@jerolba/persisting-fast-in-database-load-data-and-copy-caf645a62909

Related

1. https://github.com/schemacrawler/SchemaCrawler
2. https://github.com/kyleconroy/sqlc
3. https://github.com/facebookincubator/CG-SQL
4. https://github.com/diesel-rs/diesel
5. https://github.com/smootoo/freeslick
6. https://business.jooq.org/growth-is-not-the-only-goal/ - focus on this to reach to this product first
7. http://querydsl.com/
8. https://scala-slick.org/
9. https://github.com/antoyo/tql - rust

From Directory sqlcomponents

On JDK 8 it will not work Min JDK needed is : 11 Max JDK Tested is : 18

docker compose up -d [launch in docker postgres on port 5432] docker compose down --volumes [optional only when sql error is seen to recreate the default tables] mvn clean package
mvn clean package -Dmaven.surefire.debug -Dmaven.failsafe.debug verify
mvn clean package -Dmaven.test.skip=true
mvn versions:use-latest-releases
mvn help:active-profiles

How to Publish Maven Plugin in a way that is awailable to others to use it to generate SQL Java Classes?