More reliable database connection. #60
Closed
opened 2023-03-28 14:17:53 -04:00 by imcompiling
·
5 comments
No Branch/Tag Specified
main
renovate/ghcr.io-astral-sh-uv-0.x
renovate/python-3.x
renovate/actions-checkout-7.x
renovate/docker-login-action-4.x
refactor-submit
90-00-in-score
86-group-in-thread
82-group-message-after-deletion
reorganize-file-structure
41-editting-commands
70-sqlmodel
69-convert-submissions-to-slash-command
66-update-build-process
56-timeout-in-remove_user_submission
57-submission-table
61-guild-active-in-database
44-limit-autofill-choices
62-dm-on-join
58-guild-name-in-database
59-gitea-action
35-show-leaderboard-command
52-remove-highscore-references
49-help-setup-command
8-make-into-docker-container
21-allow-users-to-modify-tablescategories
45-sql-connection-timing-out
13-use-a-database
1-add-more-administrative-commands
29-update-commands-to-slash-commands
37-submission-timeout
28-change-register-command-to-use-subcommands
33-create-classes-for-message-map-and-submission-objects
38-time-submissions-broke
25-data-class
22-removing-broken-submissions
14-score-entries-as-dictsjson-objects
30-rich-presence-update
31-single-digit-second-format
24-keep-all-scores
26-remove-leading-0-in-time-format
27-developer-delete-command
19-regex-passes-when-only-part-of-the-string-matches
2-multi-server-support
18-remove-boss-message-map
15-format-messages-to-look-cleaner
16-regex-for-score-submission
7-submission-ui
10-allow-picture-and-score-to-be-separate-messages
12-edit-submission-accepted-message-to-also-say-who-accepted-it-in-verification
4-user-score-update
9-formatting-issue-kill-time
on-message-listener-fix
register-command
submission-ui
button-submission
score-verification
help-command
monospace-message
simple-score-command
post-scores-modify-existing-message
post-highscore-messages
v4.3.2
v4.3.1
v4.3.0
v4.2.0
v4.1.0
v4.0.3
v4.0.2
v4.0.1
v4.0.0
v3.0.7
v3.0.6
v3.0.5
v3.0.4
v3.0.3
v3.0.2
v3.0.1
v3.0.0
v2.4.0
v2.3.2
v2.3.1
v2.3.0
v2.2.1
v2.2.0
v2.1.1
v2.1.0
v2.0.2
v2.0.1
v2.0.0
v1.1.0
v1.0.7
v1.0.6
v1.0.5
v1.0.4
v1.0.3
v1.0.2
v1.0.1
v1.0.0
Labels
Clear labels
bug
documentation
duplicate
enhancement
good first issue
help wanted
invalid
question
wontfix
Something isn't working
Improvements or additions to documentation
This issue or pull request already exists
New feature or request
Good for newcomers
Extra attention is needed
This doesn't seem right
Further information is requested
This will not be worked on
No labels
bug
Milestone
No items
No Milestone
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: imcompiling/agon#60
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
I should have better database connection. If the connection is refused, the bot fails to start. I should at least have a certain number of re-connection attempts before failing to start.
Also want to have the bot create the database if it doesn't exist. It should never not exist, but this is just best practice I think.
Also should inform me when the database hasn't been connected to.
Maybe should switch to mariadb.
I think I want to at least update all of my packages. I can't connect vscode extensions to my sql database. It might be because I'm using an old version?
I'm wondering if I should just migrate to sqlite for now. Its not like I have a very large user base to support... It would make things easier and still would be able to change back easily if needed. That's the beautiful part of using the sqlalchemy connection.
I haven't seen this issue in a long time.