Databases #6

Open
opened 2025-08-16 18:18:02 -07:00 by swee · 1 comment
Owner

Used for NickServ, ChanServ, etc.

  • SQLite Local file sqlite_local
  • Cloudflare D1 cfd1
  • Firebase (NoSQL)
  • MySQL
  • PostgreSQL
Used for NickServ, ChanServ, etc. - [x] SQLite Local file `sqlite_local` - [x] Cloudflare D1 `cfd1` - [ ] Firebase (NoSQL) - [ ] MySQL - [ ] PostgreSQL
Author
Owner

The passwords should probs be encrypted using bcrypt Argon2

Nickserv table

Account (First nick) Modes Password (Encrypted) E-Mail
test iw hash nova_S_cat@sweeux.org

Nickserv group table

Nickname Owner
foo test

Chanserv table

Channel name Modes Mode params Owner User auto-mdes User optional modes
#foo n (none) owner owner +o goodguy v\nanothergoodguy v
The passwords should probs be encrypted using ~~bcrypt~~ Argon2 ## Nickserv table | Account (First nick) | Modes | Password (Encrypted) | E-Mail | |---------|---------|---------|---------| | test | iw | hash | nova_S_cat@sweeux.org | ## Nickserv group table | Nickname | Owner | |---------|---------| | foo | test | ## Chanserv table | Channel name | Modes | Mode params | Owner | User auto-mdes | User optional modes | |---------|---------|---------|---------|---------|---------| | #foo | n | (none) | owner | owner +o | goodguy v`\n`anothergoodguy v |
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: swee/IRCat#6
No description provided.