Just for fun, gonna see if i can make a port of my booru to sqlite

Follow

@hideki Sqlite is really great. Unless you use weird SQL features it shouldn't be a big bother but will make it much simpler for anyone not doing large scales

What's your DB like currently?

· · Web · 1 · 0 · 0

@applejack right now i have these tables:

.deleted -> to save the md5 of deleted files that i do not want to be re-added again if the software comes across them
.media -> to store data of the images, like md5, size, extension, etc
.tags -> to store the tags and their type, etc.
.tagpost -> to relation each post to their tags
.groups -> relational, to create groups of related media

Sign in to participate in the conversation
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.