Follow
Just for fun, gonna see if i can make a port of my booru to sqlite
@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?
@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
@orekix don't tempt me!
seems to be going good for now, i just need to find a replacement for SQL_CALC_FOUND_ROWS