Working with Databases and Groovy
summary
Shows Groovy SQL usage from sql.newInstance variants through prepared statements that prevent SQL injection, and demonstrates executeInsert returns generated keys, executeUpdate row counts, batching with a configurable batch size, and transactions working across a single DB. Introduces datasets lazy evaluation that composes multiple find/sort filters into one SQL only when materialized. Covers GMongo document inserts and queries (example dataset ends up with four athletes and five runs) and Neo4j node/edge modeling plus compact Gremlin traversals for relationship queries.
AI-written summary · about
chapters (14)
- 0:00Introduction to talk
- 1:10Groovy SQL library basics
- 10:55Creating SQL instances
- 21:52SQL execution and injection
- 33:18Stored procedures in Groovy
- 41:31Advanced SQL operations
- 53:34Java-friendly SQL syntax
- 1:00:13Groovy DataSets explained
- 1:08:13DataSets queries and views
- 1:10:22Non-relational databases intro
- 1:12:07Working with MongoDB
- 1:19:35Graph databases with Neo4j
- 1:27:47Gremlin for Neo4j queries
- 1:28:30Summary and Q&A
related talks
01h 10mReal World Iterative Database Development
47mFun with BIG Data with various databases
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively
37mBuilding Database Applications with Database/SQL
29mNeo4j for Java Developers
27mMaking Relational Cool Again (or: JavaScript on ACID)
41mModern SQL: Evolution of a dinosaur
50mJOOQ Data Abstractions Without Distraction