#
# ChangeLog for trunk/db.go in code
#
# Generated by Trac 1.6
# Jun 8, 2025, 6:54:16 PM

Fri, 11 Feb 2022 18:41:46 GMT delthas [781]
	* trunk/bridge.go (modified)
	* trunk/db.go (modified)
	* trunk/db_postgres.go (modified)
	* trunk/db_sqlite.go (modified)
	* trunk/doc/read.md (added)
	* trunk/downstream.go (modified)
	* trunk/upstream.go (modified)
	* trunk/user.go (modified)

	Add support for the wip soju.im/read capability and READ command
 ...


Wed, 17 Nov 2021 14:58:19 GMT contact [712]
	* trunk/cmd/soju/main.go (modified)
	* trunk/db.go (modified)
	* trunk/db_postgres.go (modified)
	* trunk/db_sqlite.go (modified)

	Add Prometheus instrumentation for the database


Sun, 07 Nov 2021 17:33:59 GMT contact [674]
	* trunk/db.go (modified)
	* trunk/upstream.go (modified)

	Fix upstream USER command when both username and nick are empty


Tue, 02 Nov 2021 22:33:17 GMT contact [664]
	* trunk/db.go (modified)
	* trunk/db_postgres.go (modified)
	* trunk/db_sqlite.go (modified)
	* trunk/downstream.go (modified)
	* trunk/service.go (modified)
	* trunk/upstream.go (modified)

	Make Network.Nick optional

	Make Network.Nick optional, default to ...


Mon, 18 Oct 2021 17:15:15 GMT contact [652]
	* trunk/cmd/sojuctl/main.go (modified)
	* trunk/contrib/znc-import.go (modified)
	* trunk/db.go (modified)
	* trunk/db_postgres.go (modified)
	* trunk/db_sqlite.go (modified)
	* trunk/downstream.go (modified)
	* trunk/server.go (modified)
	* trunk/server_test.go (modified)
	* trunk/service.go (modified)
	* trunk/upstream.go (modified)
	* trunk/user.go (modified)

	Add context args to Database interface

	This is a mecanical change, ...


Mon, 11 Oct 2021 13:21:04 GMT hubert [620]
	* trunk/cmd/soju/main.go (modified)
	* trunk/cmd/sojuctl/main.go (modified)
	* trunk/contrib/znc-import.go (modified)
	* trunk/db.go (modified)
	* trunk/db_postgres.go (added)
	* trunk/db_sqlite.go (modified)
	* trunk/doc/soju.1.scd (modified)
	* trunk/go.mod (modified)
	* trunk/go.sum (modified)
	* trunk/server_test.go (modified)

	PostgreSQL support


Tue, 05 Oct 2021 17:31:06 GMT contact [607]
	* trunk/db.go (modified)
	* trunk/db_sqlite.go (modified)
	* trunk/service.go (modified)

	Add DB stats


Fri, 25 Jun 2021 18:33:13 GMT contact [568]
	* trunk/db.go (modified)
	* trunk/db_sqlite.go (modified)
	* trunk/doc/soju.1.scd (modified)
	* trunk/downstream.go (modified)
	* trunk/service.go (modified)
	* trunk/upstream.go (modified)
	* trunk/user.go (modified)

	Add per-user realname setting

	This allows users to set a default ...


Wed, 26 May 2021 08:51:02 GMT contact [542]
	* trunk/contrib/znc-import.go (modified)
	* trunk/db.go (modified)
	* trunk/db_sqlite.go (modified)
	* trunk/doc/soju.1.scd (modified)
	* trunk/downstream.go (modified)
	* trunk/service.go (modified)
	* trunk/user.go (modified)

	Allow networks to be disabled


Tue, 25 May 2021 14:35:39 GMT sir [531]
	* trunk/cmd/soju/main.go (modified)
	* trunk/cmd/sojuctl/main.go (modified)
	* trunk/contrib/znc-import.go (modified)
	* trunk/db.go (modified)
	* trunk/db_sqlite.go (added)
	* trunk/server.go (modified)

	db: refactor into interface

	This refactors the SQLite-specific bits ...


Tue, 27 Apr 2021 07:22:44 GMT yyp [509]
	* trunk/db.go (modified)

	db: match placeholders with columns

	Soju inserts 9 columns but only ...


Tue, 13 Apr 2021 16:15:30 GMT contact [497]
	* trunk/db.go (modified)
	* trunk/user.go (modified)

	Store last internal msg ID in DB when detaching

	References: ...


Wed, 31 Mar 2021 16:04:13 GMT contact [489]
	* trunk/db.go (modified)
	* trunk/upstream.go (modified)
	* trunk/user.go (modified)

	Save delivery receipts in DB

	This avoids loosing history on restart ...


Tue, 09 Mar 2021 17:55:34 GMT contact [457]
	* trunk/db.go (modified)
	* trunk/upstream.go (modified)

	Add Network.{URL,GetUsername,GetRealname}

	Just a bunch of helpers ...


Mon, 14 Dec 2020 19:54:02 GMT delthas [434]
	* trunk/db.go (modified)

	Introduce Channel.{RelayDetached,ReattachOn,DetachAfter,DetachOn}
 ...


Sat, 24 Oct 2020 13:47:53 GMT contact [422]
	* trunk/db.go (modified)

	Switch to sql.NullString

	Not really better than what we had before, ...


Sat, 24 Oct 2020 13:14:23 GMT contact [421]
	* trunk/contrib/znc-import.go (modified)
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)
	* trunk/service.go (modified)
	* trunk/user.go (modified)

	Switch DB API to user IDs

	This commit changes the Network schema to ...


Sat, 24 Oct 2020 12:52:55 GMT contact [420]
	* trunk/db.go (modified)

	Add id column to User table

	We used rowid before, but an explicit ...


Mon, 07 Sep 2020 09:40:18 GMT hubert [416]
	* trunk/db.go (modified)
	* trunk/user.go (modified)

	Make DB.DeleteChannel take the channel ID

	... to allow the caller ...


Mon, 17 Aug 2020 22:26:59 GMT dan.shick [393]
	* trunk/db.go (modified)

	Fix store user query values


Tue, 11 Aug 2020 08:26:42 GMT contact [382]
	* trunk/db.go (modified)

	Add User.ID

	For now it's just a new field that'll be useful to ...


Mon, 03 Aug 2020 16:43:39 GMT contact [375]
	* trunk/db.go (modified)

	Add DB.DeleteUser


Thu, 09 Jul 2020 09:23:51 GMT contact [356]
	* trunk/db.go (modified)

	Fix deadlock in DB.Close

	This method was calling itself, instead of ...


Mon, 08 Jun 2020 20:30:09 GMT delthas [327]
	* trunk/db.go (modified)

	Add an admin flag to users

	This is preparatory work for letting ...


Mon, 08 Jun 2020 09:59:03 GMT contact [324]
	* trunk/cmd/sojuctl/main.go (modified)
	* trunk/db.go (modified)
	* trunk/user.go (modified)

	Introduce User.Created

	For Network and Channel, the database only ...


Tue, 02 Jun 2020 09:24:22 GMT fox.cpp [307]
	* trunk/db.go (modified)
	* trunk/doc/soju.1.scd (modified)
	* trunk/downstream.go (modified)
	* trunk/service.go (modified)
	* trunk/upstream.go (modified)

	Implement upstream SASL EXTERNAL support

	Closes: ...


Fri, 01 May 2020 13:18:14 GMT contact [284]
	* trunk/db.go (modified)
	* trunk/doc/soju.1.scd (modified)
	* trunk/downstream.go (modified)
	* trunk/upstream.go (modified)
	* trunk/user.go (modified)

	Add support for detached channels

	Channels can now be detached by ...


Thu, 23 Apr 2020 14:36:20 GMT contact [267]
	* trunk/db.go (modified)
	* trunk/upstream.go (modified)
	* trunk/user.go (modified)

	Add network.channels, remove DB.GetChannel

	Store the list of ...


Thu, 16 Apr 2020 15:38:47 GMT delthas [263]
	* trunk/db.go (modified)
	* trunk/service.go (modified)
	* trunk/upstream.go (modified)

	Add support for custom network on-connect commands

	Some servers use ...


Fri, 10 Apr 2020 20:45:02 GMT contact [255]
	* trunk/README.md (modified)
	* trunk/db.go (modified)
	* trunk/schema.sql (deleted)

	Set up DB migration infrastructure

	The database is now initialized ...


Fri, 10 Apr 2020 08:09:02 GMT admin [251]
	* trunk/cmd/sojuctl/main.go (modified)
	* trunk/db.go (modified)

	Add ability to change password


Wed, 01 Apr 2020 15:34:22 GMT contact [207]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)

	Fix SQL error logged on JOIN

	Closes: ...


Wed, 01 Apr 2020 13:40:20 GMT contact [202]
	* trunk/db.go (modified)
	* trunk/service.go (modified)
	* trunk/user.go (modified)

	Add "network delete" service command

	And add all the infrastructure ...


Fri, 27 Mar 2020 21:38:38 GMT contact [173]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)

	Stop accessing user data in downstreamConn.authenticate

	This ...


Wed, 25 Mar 2020 13:23:41 GMT contact [149]
	* trunk/db.go (modified)

	Correctly set Channel.ID in DB.StoreChannel


Wed, 25 Mar 2020 13:15:25 GMT contact [148]
	* trunk/db.go (modified)

	Error out when storing unsupported SASL mechanism in DB


Wed, 25 Mar 2020 10:54:08 GMT contact [146]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)
	* trunk/upstream.go (modified)

	Add support for channel keys


Wed, 18 Mar 2020 23:06:48 GMT delthas [118]
	* trunk/db.go (modified)
	* trunk/schema.sql (modified)
	* trunk/user.go (modified)

	schema: add Network.name


Fri, 13 Mar 2020 17:13:03 GMT contact [98]
	* trunk/README.md (modified)
	* trunk/bridge.go (modified)
	* trunk/cmd/jounce/main.go (deleted)
	* trunk/cmd/jouncectl/main.go (deleted)
	* trunk/cmd/soju (added)
	* trunk/cmd/soju/main.go (added)
	* trunk/cmd/sojuctl (added)
	* trunk/cmd/sojuctl/main.go (added)
	* trunk/config/config.go (modified)
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)
	* trunk/go.mod (modified)
	* trunk/irc.go (modified)
	* trunk/ring.go (modified)
	* trunk/server.go (modified)
	* trunk/upstream.go (modified)

	Rename project to soju


Fri, 13 Mar 2020 14:12:44 GMT contact [95]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)
	* trunk/go.mod (modified)
	* trunk/go.sum (modified)
	* trunk/irc.go (modified)
	* trunk/schema.sql (modified)
	* trunk/upstream.go (modified)

	Add support for SASL authentication

	We now store SASL credentials ...


Fri, 13 Mar 2020 11:06:02 GMT contact [93]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)
	* trunk/schema.sql (modified)
	* trunk/upstream.go (modified)

	Add support for upstream PASS command


Thu, 12 Mar 2020 18:17:06 GMT contact [90]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)
	* trunk/server.go (modified)

	Store NICK changes in the DB


Thu, 12 Mar 2020 17:33:03 GMT contact [89]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)

	Update DB on JOIN and PART


Wed, 11 Mar 2020 18:09:32 GMT contact [85]
	* trunk/db.go (modified)
	* trunk/downstream.go (modified)

	Add support for PASS to downstream


Wed, 11 Mar 2020 18:01:03 GMT contact [84]
	* trunk/cmd/jouncectl (added)
	* trunk/cmd/jouncectl/main.go (added)
	* trunk/db.go (modified)
	* trunk/go.mod (modified)
	* trunk/go.sum (modified)

	cmd/jouncectl: new command

	Allows to create users.


Wed, 04 Mar 2020 19:15:38 GMT contact [81]
	* trunk/db.go (modified)

	Use a RWMutex for DB


Wed, 04 Mar 2020 18:23:24 GMT contact [79]
	* trunk/db.go (modified)
	* trunk/server.go (modified)
	* trunk/upstream.go (modified)

	go fmt


Wed, 04 Mar 2020 17:22:58 GMT contact [77]
	* trunk/cmd/jounce/main.go (modified)
	* trunk/config/config.go (modified)
	* trunk/db.go (added)
	* trunk/downstream.go (modified)
	* trunk/go.mod (modified)
	* trunk/go.sum (modified)
	* trunk/schema.sql (added)
	* trunk/server.go (modified)
	* trunk/upstream.go (modified)

	Add SQLite database

	Closes: https://todo.sr.ht/~emersion/jounce/9