recentpopularlog in

databases

« earlier   
My Letterman Databases – The Donz Blog by Don Giller
“I’d like to know more about your Letterman databases, please,” said no one ever.
letterman  databases  tv 
yesterday by xr
statsd/statsd: Daemon for easy but powerful stats aggregation
Daemon for easy but powerful stats aggregation. Contribute to statsd/statsd development by creating an account on GitHub.
statistics  data  charts  databases  graphs  monitoring 
3 days ago by e2b
10 Common Mistakes Java Developers Make when Writing SQL
1. Forgetting about NULL
2. Processing data in Java memory
3. Using UNION instead of UNION ALL
4. Using JDBC Pagination to paginate large results
5. Joining data in Java memory
6. Using DISTINCT or UNION to remove duplicates from an accidental cartesian product
7. Not using the MERGE statement
8. Using aggregate functions instead of window functions
9. Using in-memory sorting for sort indirections
10. Inserting lots of records one by one
jdbc  java  sql  databases  lib  orm  jooq  performance  optimization  articles  documentation  code  programming  howto 
3 days ago by oscar-lopez
Documentation for the MariaDB Connector/J driver
The MariaDB driver is recommended for connecting to Aurora, because it correctly handles fail overs. It has some gotchas to be aware, though:

- We must set socketTimeout=0 in the connection URL
- Only the cluster endpoint is recognized as a valid connection URL
jdbc  java  sql  databases  lib  orm  performance  optimization  work  amazon  documentation  code  programming  howto  aurora  mysql 
3 days ago by oscar-lopez
What you Didn’t Know About JDBC Batch
The ultimate reference for inserting efficiently using batches with jOOQ and MySQL/Aurora. Yes, we still need to do INSERT ... VALUES with multiple rows, but the key point here is that we must enable rewriteBatchedStatements=true in the connection string for this to work!
jooq  java  sql  databases  lib  orm  performance  optimization  work  amazon  documentation  code  programming  howto  aurora  mysql 
3 days ago by oscar-lopez
NoSQL Workbench for Amazon DynamoDB
AWS is introducing NoSQL Workbench for Amazon DynamoDB, a free, client-side application available for Windows and macOS to help you design and visualize your data model, run queries on your data, and generate the code for your application.
dynamodb  nosql  ide  aws  amazon  tools  databases  articles  modeling  visualization  code  generators 
10 days ago by oscar-lopez

Copy this bookmark:





to read