Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom

Create a new demo project #1

Open
55 of 77 tasks
lukaseder opened this issue May 2, 2022 · 3 comments
Open
55 of 77 tasks

Create a new demo project #1

lukaseder opened this issue May 2, 2022 · 3 comments
Labels
P: Medium T: Enhancement
Milestone
Latest Version

Comments

@lukaseder
Copy link
Member

lukaseder commented May 2, 2022 •
edited
Loading

As a part of the jOOQ issue here: jOOQ/jOOQ#12984, and for near future jOOQ webinars with third parties:

It's important to have a working demo that helps showcase most jOOQ use-cases interactively.

The demo will be implemented in 2 steps:

  • Addressing the immediate needs of the above webinars
    • Based on the historic demo I used for the jOOQ talk: https://www.youtube.com/watch?v=knTwEqv2OXI
    • Working with the Sakila database
      • For CockroachDB
      • For PostgreSQL in general
    • Languages
      • Java
      • Kotlin
      • Scala
    • Execution models
      • JDBC / blocking
      • RS / nonblocking
      • Kotlin coroutines
  • Addressing all the demo needs
    • Functionality
      • Querying (including MULTISET, nested records, ad-hoc conversion, etc.)
      • Dynamic SQL
      • Functions
      • DML
      • Batch
      • Transactions
        • JDBC connection access
      • Parser
        • Interpreter
      • Import / export
      • DAOs
      • Stored procedures
      • Procedural language API
      • R2DBC
      • SPIs
        • ExecuteListener
        • VisitListener
      • DDL
      • Mocking
      • Diagnostics
      • QOM transformation
      • Code generation features
        • Generator strategies
        • Data type bindings and converters
        • Synthetic keys
        • Client side computed columns
          • virtual
          • stored
        • Embeddables
        • Audit columns
        • Readonly columns
        • Alternative code generation sources
          • JPADatabase
          • DDLDatabase
          • XMLDatabase
    • Building
      • with Maven
      • with Gradle
    • Integrating with Testcontainers
    • Database change management integration
      • Flyway
      • Liquibase
    • Languages
      • Java
      • Scala
      • Kotlin
    • jOOQ Editions
      • The jOOQ Open Source Edition
      • The commercial editions
    • Working with any RDBMS that we support the sakila database for: https://github.com/jOOQ/sakila
      • CockroachDB
      • Db2
      • MySQL
      • Oracle
      • PostgreSQL
      • SQL Server
      • SQLite
      • YugabyteDB

More work:

  • Integration tests
  • Documentation
    • Document how to set up the sakila database (no longer needed, it's testcontainer based now)
    • Make sure that any custom setup (e.g. different JDBC URL, etc.) is super easy to implement
@lukaseder lukaseder mentioned this issue May 2, 2022
Closed
@lukaseder lukaseder added this to the Latest Version milestone May 2, 2022
lukaseder added a commit that referenced this issue May 2, 2022
@lukaseder
[#1] Add draft demo project
f617bc1
lukaseder added a commit that referenced this issue May 2, 2022
@lukaseder
[#1] Add draft demo project
90be1cb
lukaseder added a commit that referenced this issue May 2, 2022
@lukaseder
[#1] Add draft demo project
5fc487d
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code
701ef94
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code
201a162
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: Add parser examples
232b0cc
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: Add import / export examples
918525f
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: Add initial kotlin demo code
69e39c2
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: More kotlin demo code
00f1f9b
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: More kotlin demo code
adb5b83
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: More kotlin demo code
d091e0b
lukaseder added a commit that referenced this issue May 3, 2022
@lukaseder
[#1] Continue adding demo code: More kotlin demo code
663af9e
lukaseder added a commit that referenced this issue May 4, 2022
@lukaseder
[#1] Added an explicit JDBC Connection access and transaction example
56864bf
lukaseder added a commit that referenced this issue May 4, 2022
@lukaseder
[#1] Added DAO examples
5524da1
lukaseder added a commit that referenced this issue May 4, 2022
@lukaseder
[#1] Added interpreter and parse meta lookup examples
380615d
lukaseder added a commit that referenced this issue May 4, 2022
@lukaseder
[#1] Added SPI examples
8da32bf
lukaseder added a commit that referenced this issue May 4, 2022
@lukaseder
[#1] Added QOM examples
0e19068
lukaseder added a commit that referenced this issue May 5, 2022
@lukaseder
[#1] Weird src/src path removed
6f8fe6d
lukaseder added a commit that referenced this issue May 5, 2022
@lukaseder
[#1] Fixed firstName / lastName
05ab45f
lukaseder added a commit that referenced this issue May 9, 2022
@lukaseder
[#1] Added an example of mapping a MULTISET into a nested Map
1d6353a 
See also: https://blog.jooq.org/how-to-typesafely-map-a-nested-sql-collection-into-a-nested-java-map-with-jooq/
lukaseder added a commit that referenced this issue May 25, 2022
@lukaseder
[#1] Move project to jOOQ-pro subdirectory
94db77c
lukaseder added a commit that referenced this issue May 25, 2022
@lukaseder
[#1] Use PostgreSQL instead
b4bc48a 
- The demo now uses PostgreSQL instead of CRDB (might be restored later)
- We're using testcontainers and Flyway to be independent of an actual installation
- The Sakila database has been added
- Code was re-generated
lukaseder added a commit that referenced this issue May 25, 2022
@lukaseder
[#1] Separate Java and Kotlin demo
783c401
lukaseder added a commit that referenced this issue May 25, 2022
@lukaseder
[#1] Updated README
a297e9c
lukaseder added a commit that referenced this issue May 25, 2022
@lukaseder
[#1] Updated OSS demo
05f880b
lukaseder added a commit that referenced this issue May 25, 2022
@lukaseder
[#1] Removed redundnat code
7ee33e7
@TheBestPessimist

This comment was marked as resolved.

# to view
@lukaseder

This comment was marked as resolved.

# to view
lukaseder added a commit that referenced this issue May 31, 2022
@lukaseder
[#1] Added reactive examples
6d35f57
lukaseder added a commit that referenced this issue May 31, 2022
@lukaseder
[#1] Added comment
2142318
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Added a reactive transaction example
fe31678
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] [jOOQ/jOOQ#9335] Use new jooq-kotlin-coroutines extensions
3eaa063
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Updated OSS edition
ed5c52a
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Added mocking examples
7c89d69
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Update README
a08a452
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Update README
89a0f87
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] main branch should use jOOQ 3.16
8e30bca
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Pro import removal doesn't work in demo yet
d8b6603
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] ParseListener only available in commercial editions
d5e5671
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Organized imports
d749416
@lukaseder
Copy link
Member Author

The main branch now uses a published 3.16.6 version for convenience. The version-3.17.0-branch will work with the 3.17.0-SNAPSHOT version, showcasing latest features. When a minor release ships, the branches will be switched.

lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Match jOOQ version numbering
4bec16c
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Pro import removal doesn't work in demo yet
2d8a1e7
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] ParseListener only available in commercial editions
7cdce30
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Organized imports
efe0e9a
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Fixed compilation error
dcc3e8c
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] Added exists/row/multiset convenience method examples
022e6e1
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] OSS edition should have commercial code commented out, not blank…
4bd9334 
…ed out
lukaseder added a commit that referenced this issue Jun 1, 2022
@lukaseder
[#1] OSS edition should have commercial code commented out, not blank…
b67c96a 
…ed out
lukaseder added a commit that referenced this issue Jun 3, 2022
@lukaseder
[#1] Convenience methods are experimental for now
23c0dd6
lukaseder added a commit that referenced this issue Jun 3, 2022
@lukaseder
[#1] Perhaps a bit more idiomatic, using 'it'?
3bc5cd5
lukaseder added a commit that referenced this issue Jun 7, 2022
@lukaseder
[#1] Feature prototype has been removed again
86f7d53
lukaseder added a commit that referenced this issue Jun 7, 2022
@lukaseder
[#1] Feature prototype has been removed again
2255fd7
lukaseder added a commit that referenced this issue Jun 7, 2022
@lukaseder
[#1] Fix also kotlin/scala examples
702bc86
lukaseder added a commit that referenced this issue Jun 30, 2022
@lukaseder
[#1] Added DDLDatabase examples
2d6a11b
lukaseder added a commit that referenced this issue Jun 30, 2022
@lukaseder
[#1] Added virtual client side computed column examples
67d465f
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
P: Medium T: Enhancement
Projects
None yet
Milestone
Latest Version
Development

No branches or pull requests
2 participants
@lukaseder @TheBestPessimist