0.0.7

What's Changed

• Show clients on coordinator as well by @nikifkon in #243
• Fix feature test action by @EinKrebs in #245
• Show backend connections and minor refactor by @reshke in #246
• Data transfer by @debebantur in #235
• regard loglevel case-insensitive by @reshke in #248
• Test recover after interrupting keyrange move by @debebantur in #249
• small log level fix by @Denchick in #251
• Make reuse-port configurabale by @reshke in #252
• Correct pre-route connections to spqr-console on router default port by @reshke in #256
• Statistics fix by @debebantur in #254
• Backup memqdb into json file by @nikifkon in #244
• Fix data race when router shutdown by @reshke in #257
• Make --console actually work. Check for simultaneous use of console… by @reshke in #258
• fixed data race in statistics by @debebantur in #261
• Coordinator tests by @diPhantxm in #253
• Simple unit tests for client package. Cancel Requiest test by @reshke in #263
• test writing to qdb by @debebantur in #250
• Cleanup mockgen. Move pgx tx/conn mocks to separate folder by @reshke in #264
• Fix release job by @EinKrebs in #247
• Create coordinator.md by @reshke in #225
• Run job on each feature tests by @nikifkon in #268
• Unite admin-console/psql-console pre-routing logic. by @reshke in #259
• Update Router.md by @reshke in #210
• fix init.sql + backup.json logic by @nikifkon in #262
• Coordinator Show clients/pools/backend_connections funcs by @debebantur in #265
• Show router status in SHOW ROUTERS command response by @reshke in #266
• Fix dataraces in memqdb by @nikifkon in #260
• fix double lock key range on router when moving data by @diPhantxm in #271
• fix lock/unlock key range wrong namespace in qdb by @diPhantxm in #270

Full Changelog: 0.0.6...0.0.7

0.0.6

What's Changed

• Collect time statistics by @debebantur in #217
• implement where for show clients in admin console by @nikifkon in #216
• Enhace lexer and parser by @reshke in #224
• Drop binary file by @reshke in #223
• Bump lyx by @reshke in #226
• Drop unneede type cast by @reshke in #228
• updated router doc by @debebantur in #227
• Add qparser tests by @reshke in #229
• Handle select target-list-only queries in router and route them to on… by @reshke in #230
• Feature tests infrastructure by @EinKrebs in #231
• Replaced sleep in regress tests with more accurate dependencies in docker-compose.yaml by @EinKrebs in #232
• Fix feature tests by @EinKrebs in #234
• Add GOMAXPROCS parameter to router by @Denchick in #237
• run unittests by @Denchick in #239
• Get rid of old logger, use zerolog everywhere instead by @Denchick in #241
• Show version in command-line and console by @Denchick in #240
• Enhance spqrparser by @reshke in #242

Full Changelog: 0.0.5...0.0.6

0.0.5

Summary

• Fix a lot of performance and leaking memory issues. The performance of the router has significantly increased.
• Enhance logging.
• Add more features in router's administrative console for debug and observability purposes.

What's Changed

• Copy config hosts to local variable to avoid data race by @reshke in #161
• Fix missing return by @reshke in #162
• Add spqrdump tool by @reshke in #164
• Refactor router proxy code, divide responsibilities between metadata … by @reshke in #165
• Add psql proto support to spqrdump by @reshke in #166
• Add tls support to spqrdump by @reshke in #167
• Add linters and stress tests by @Denchick in #163
• Add new tests by @reshke in #170
• Add regression tests local run script by @reshke in #171
• Send GSSAPI negotiation request in startup by @reshke in #172
• Include client id in error message by @reshke in #173
• Fix transaction status reply. Fix double begin transaction case handl… by @reshke in #174
• Refactor code by @reshke in #175
• Add query to error msg in logs by @reshke in #177
• Connection pooling limits for routes. Limit number of concurrent conn… by @reshke in #178
• Better logging by @reshke in #179
• Enhance logging in server connection logic and qdb by @reshke in #180
• fix typos, minor log fixes by @Denchick in #181
• Show clients basics by @reshke in #182
• Fix connection leak in multishard server and fix rw-check by @reshke in #183
• Add package building to release workflow by @EinKrebs in #186
• Discard unsync connections from pool by @reshke in #185
• Drop binary file by @reshke in #187
• Add show backend_connections command by @reshke in #188
• Fix concurrent map access by @reshke in #189
• ensure shard is not nil by @Denchick in #190
• Fix concurrent access to psql client backend connection by @reshke in #191
• Ppof fixes by @reshke in #192
• Cancel client backend requests under mutex by @reshke in #193
• wait for SIGUSR2 signal (pprof) by @gorl in #196
• protect vars from concurrent access by @gorl in #195
• Minor enhancement, show backend_connections command improved by @reshke in #197
• Bump golang to go 1.20 by @reshke in #198
• Add kill client command by @nikifkon in #184
• Refac by @reshke in #199
• Do not parse query twice by @reshke in #203
• Fix regression test by @reshke in #206
• Cache tsa check for a second by @reshke in #204
• Enable different passwords for shards by @debebantur in #205
• Fix typos in README.md by @EinKrebs in #209
• Use zerolog for router by @Denchick in #207
• Default auth rule by @debebantur in #208
• Update README.md by @EinKrebs in #211
• Show user and dbname on SHOW POOLS cmd by @reshke in #213
• Update Makefile by @reshke in #214
• moved auth tests by @debebantur in #215
• Implement SCRAM auth by @EinKrebs in #202
• Add console flag and cpu/mem profile settings distinguish by @reshke in #219
• Add hostname to SHOW POOLS output by @reshke in #220
• Hide router notice msgs under extended debug setting by @reshke in #212
• Get rid of expensive cgo calls by @reshke in #194
• Fix router main function fatal log msgs by @reshke in #221
• Update github.com/jackc/pgx to v5 by @Denchick in #218

New Contributors

• @gorl made their first contribution in #196
• @nikifkon made their first contribution in #184
• @debebantur made their first contribution in #205

Full Changelog: 0.0.4...0.0.5

0.0.4

What's Changed

• Refactor router frontend function. by @reshke in #127
• Fix yet another couple of log messages by @reshke in #128
• Refactor coordinator grpc services. Rename RoutersService to Topolog… by @reshke in #129
• Support add and list shards cmds in coordctl by @reshke in #130
• Delete router/protos directory by @reshke in #131
• User validation by @diPhantxm in #123
• Drop wal-g/tracelog usage by @Denchick in #132
• Enhance router TLS-related log messages. by @reshke in #133
• Change hostname in tls init to fix verify-full on server side by @munakoiso in #134
• Add comments to code, drop unneded config rats in config-example by @reshke in #135
• Implement insert from select query with constant by @munakoiso in #136
• Improve update queries routing by @munakoiso in #137
• Update pq query to v4 by @reshke in #138
• Accept and parse comments in queries to force-set shard to ruote by @reshke in #139
• Allow encrypted password for backend auth in config by @reshke in #140
• Add daemonize router feature by @reshke in #141
• Listen localhost in psql-proto by default by @reshke in #142
• Fix md5 auth for frontend and backend connections by @reshke in #143
• Route client to admin console on port psql port if dbname is "console" by @reshke in #144
• Add default_route_behaviour setting by @reshke in #145
• Route to shard with respect to client session attr by @reshke in #146
• Copy pgproto3 interfaces after Recieve() them by @reshke in #147
• Fix default target-session-attrs by @Denchick in #148
• Add transactions and target-session-attrs tests by @Denchick in #149
• Support cancel proto msgs by @reshke in #150
• Reload logger when getting SIGHUP SIGUSR1 signals by @Denchick in #151
• Check column name with rules while routing. by @reshke in #152
• Make SPQR tests independent by @Denchick in #154
• Add single shard join test and fixes by @reshke in #153
• Make console tests better: drop all objects created during test by @reshke in #155
• More logging by @reshke in #156
• Do not raise error if shard host is down by @reshke in #157
• Use client id in log record while routing and acquiring connections by @reshke in #158
• Even better logging by @reshke in #159
• More logging by @reshke in #160

New Contributors

• @munakoiso made their first contribution in #134

Full Changelog: 0.0.3...0.0.4

0.0.3

What's Changed

• Do not close connection with disabled ssl by @reshke in #86
• Fix simultanious access to qrouter parser by @reshke in #87
• Support sync messages in multi-shard setup by @reshke in #96
• fix regress tests by @Denchick in #100
• Fix docker stuff by @Denchick in #103
• Add keyspace abstraction to spqr topology by @reshke in #104
• add uuid support tests by @diPhantxm in #101
• add between condition support in router by @diPhantxm in #99
• Add infrasture code and changes to support Hash-based routing by @reshke in #105
• Allow dataspace create & list in local proxy router setup by @reshke in #106
• Group columns by its relations name, to properly route queries by @reshke in #108
• QDB refactoring by @Denchick in #109
• Add routing on insert from select statements by @reshke in #110
• Restrict routing of the complex from-clause queries by @reshke in #111
• Sort results of List request to qdb by @reshke in #112
• Simply router console pasring yacc tree by @reshke in #113
• remove annoying log messages by @Denchick in #114
• Add sanity checks on sharding rule create/modify ops by @reshke in #115
• Refactor routing logic by @reshke in #116
• Move MatchShardingRule call from deparse to routing phase by @reshke in #117
• Explain feature basics. by @reshke in #118
• Enable tables work in sharding rules by @Denchick in #120
• Automatically generate id for missing clauses in parse-time. by @reshke in #121
• Add cli option to coordinator to select running qdb implementation by @reshke in #125
• Refactor frontend AUTH and fix md5 password routines by @reshke in #126
• Sharding rules as table by @diPhantxm in #124

New Contributors

• @diPhantxm made their first contribution in #101

Full Changelog: 0.0.2...0.0.3

0.0.2

What's changed

Coordinator

• Router-side key range moves by @reshke (#29)
• Coordinator fixes by @reshke (#30, #47)
• Implement drop key ranges by @reshke (#31)
• Balancer console by @reshke (#33)
• Simple mover by @reshke (#39)
• Add sharding rules support in coordinator by @reshke (#48)
• Add drop sharding rules statement support by @reshke (#51)
• Add missing coordinator and router functionality by @reshke (#52)
• Fix bug with add key range using coordinator by @reshke (#53)

Router

• TLS config and router small refactoring by @Denchick (#38)
• Multishard feature by @reshke (#45)
• Simplify configs, add docs by @Denchick (#46)
• Fix json and toml config formats support by @Denchick (#54)
• Add simple COPY support by @Denchick and @reshke (#56, #58)
• Add target-session-attrs option to shard config by @reshke (#65)
• Online reload for router configuration by @reshke (#77)

Docs, tests

• Add regression PG-style tests by @EinKrebs by @Denchick @reshke (#43, #62, #67, #72, #73, #74)
• Add docs for coordinator, router and world by @Denchick (814622e, 6a77d9b, 2267506, #49)
• Add new test set with joins-relation queryies tests by @reshke (#63)