#database

@java_sql_and_jooq How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ #Java #SQL #Database

@datomic_blog Implicit Partitions #Database #Data #Tech

@java_sql_and_jooq 3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 #Java #SQL #Database

@pganalyze_blog Postgres 16: Cumulative I/O statistics with pg_stat_io #Postgres #Database #Performance

@artsy_engineering Are you using the right Mongo geospatial query? #Database #Geospatial #DevOps

@the_dart_blog Introducing Realm for Dart & Flutter #Dart #Flutter #Database

@datomic_blog Query Stats #Database #Performance #Analytics

@java_sql_and_jooq Emulating Window Functions in MySQL 5.7 #SQL #Java #Database

@java_sql_and_jooq jOOQ's R2DBC LoggingConnection to log all SQL statements #Java #SQL #Database

@hookrace_blog Database Testing at Yugabyte #Database #Testing #Tech

@thomas_hunter_ii mig: The Universal Database Migration Runner #Database #Go #SoftwareEngineering

@pganalyze_blog Lock monitoring in Postgres: Find blocking queries in a lock tree with pganalyze #Postgres #Database #Performance

@peter_ullrich The Complete Guide to Full-text Search with Postgres and Ecto #Postgres #Database #Search

@java_sql_and_jooq LATERAL is Your Friend to Create Local Column Variables in SQL #SQL #Database #Programming

@kai_wern Some useful psql commands to know #PostgreSQL #Database #DevTips

@alexandru_nedelcu Building a Queue for Delayed Messages via a RDBMS (1): Design #Database #Programming #SQL

@david_winterbottom_tils That Postgres sequences aren't restored after a transaction rollback #Postgres #Database #SQL

@peter_ullrich Efficient Name Search with Postgres and Ecto #Elixir #Postgres #Database

@thomas_larock Pro SQL Server 2022 Wait Statistics Book #SQL #Database #Tech

@peter_ullrich Prevent overlapping time ranges with Ecto and Postgres #Elixir #Postgres #Database

@neil_panchal How to install PostgreSQL in a custom directory #PostgreSQL #Database #DevOps

@peter_ullrich Optimize Ecto's insert_all with Placeholders #Elixir #Database #Programming

@peter_ullrich The complete guide to Upserts with Ecto #Elixir #Programming #Database

@chris_kiehl How to Influence Query Planning in Postgresql #Postgresql #Database #Programming

@java_sql_and_jooq Using jOOQ's Implicit Join From Within the JOIN .. ON Clause #Java #SQL #Database

@java_sql_and_jooq How to Plot an ASCII Bar Chart with SQL #SQL #Database #Programming

@java_sql_and_jooq jOOQ 3.17 Supports Implicit Join also in DML #Java #SQL #Database

@java_sql_and_jooq The Many Ways to Return Data From SQL DML #SQL #Java #Database

@java_sql_and_jooq How to Integration Test Stored Procedures with jOOQ #Java #Testing #Database

@java_sql_and_jooq The Best Way to Call Stored Procedures from Java: With jOOQ #Java #SQL #Database

@java_sql_and_jooq 3.17.0 Release with Computed Columns, Audit Columns, Pattern Matching, Reactive Transactions and Kotlin Coroutine Support #Java #Kotlin #Database

@dba_stackexchange Changed Hostname of PC, MSSQL DBs no longer accessible when logged into Management Studio #SQLServer #Database #Troubleshooting

@java_sql_and_jooq How to Filter a SQL Nested Collection by a Value #SQL #Java #Database

@dba_stackexchange DBCC CHECKDB getting terminated abnormally #Database #SQL #Troubleshooting

@java_sql_and_jooq Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries #Java #SQL #Database

@pganalyze_blog How Postgres Chooses Which Index To Use For A Query #Postgres #Database #Performance

@david_winterbottom_tils You can't use Django's generic foreign key field with objects stored in a separate database #Python #Django #Database

@pganalyze_blog Postgres in 2021: An Observer's Year In Review #Postgres #Database #Performance

@pganalyze_blog The Fastest Way To Load Data Into Postgres With Ruby on Rails #Postgres #RubyOnRails #Database

@pganalyze_blog Understanding Postgres GIN Indexes: The Good and the Bad #Postgres #Database #Performance