Posted under General
when the site was down there was a link to the twitter site.
And there was a link to the blog where the guy was talking about more efficient way of storing data in the database.
so im doing my own tagging database & im interested how should i store the data.
Dos someone know the link that leads to that blog?
Updated
kumarei said:
This one?
http://memo.donmai.us/post/show/1930
yup thanx
So inverted index, how would the databas look like? im little confused. CAn someone make a sample maybe?
Sample with this tag?
01247c6966d054061f75b7c4769cb187 - Bondage,School
http://www.itl.nist.gov/div897/sqg/dads/HTML/invertedIndex.html
Updated
gaastra said:
yup thanxSo inverted index, how would the databas look like? im little confused. CAn someone make a sample maybe?
Why don't you start thinking for yourself (and paying some attention to your spelling, while you're at it)? Everything you write is worthless babble because you can't be fucked to do even the smallest bit of thinking or research for yourself.
Ever since you came, the forum became a distinctly less interesting place, because every other thread gets contaminated with the endless stream of your requests or someone having to explain you the basics of something. Stop that. It's annoying and you're annoying. You contribute nothing of value, and take a lot of valuable time from clueful people.
I'm not exactly sure what you're asking for or even how much you know on the topic. My suggestion is start with the basics and learn what database indices are and how databases work in general. SQL is a must as well if you want to do anything with databases.
If you're curious on how danbooru does it, the source code is available here.
If you know any good documentation that explains how to store the data in the database so you can use inverted indexing feel free to share the info.
All the guides I found so far have proven to be useless gibberish that take a piece of info from hire & there & dont give any details how it should actually be done.
Good example is the mysql install that took me whole day until i finally found a guide & set it up in 3 minutes....
You cant figure it out if you dont know what to look for!
I know how to make md5 checksums of the images & put it & the tags into the database & take it out also. what I was asking is how do you organize the tags inside the database. cuz you seem to be smart in this area i thought someone may know.
As far as I understood danbooru does it in a not efficient way.
So far my logic is like this, but im not sure if it is a good way, it probably is not cuz you still need to make 3 queries: to get all tags connected to the hash
How would you do it?
1) get hash ID
2) use hash ID to find out wich tag_IDS have same Hash ID
3) return all Tags with same hash ID
$Table = hash_table
==========================
ID_Hash = 1 Hash = Fish
$Table = Tag_table
==========================
ID_Tag = 1 Tag = blue
ID_Tag = 2 Tag = yellow
ID_Tag = 3 Tag = green
ID_Tag = 4 Tag = red
$Table = ids_hash_tag
==========================
ID_Hash = 1 ID_tag = 1
ID_Hash = 1 ID_tag = 2
ID_Hash = 1 ID_tag = 3
ID_Hash = 1 ID_tag = 4
EDIT: There are many topics in this forum i do not like, for example I dont give a damn about how you guys discuss about fansub vs. subtitled tag or zipped & unzipped, as a mater of a fact I find all this more than #¤&$$€$€
But I do not go around & bitch, how I do not like it.
My policy is: if you like it, if this interests you for god sake, go ahead. And I do not laugh & think what an &%/¤/%&/are arguing about those trivial things. I understand, all ppl are different. Their interests are different. There is no point of me going to tell them what to do.
Updated
gaastra said:EDIT: There are many topics in this forum i do not like, for example I dont give a damn about how you guys discuss about fansub vs. subtitled tag or zipped & unzipped, as a mater of a fact I find all this more than #¤&$$€$€
You have a really bizarre concept of what this forum is for, then.
gaastra said:
EDIT: There are many topics in this forum i do not like, for example I dont give a damn about how you guys discuss about fansub vs. subtitled tag or zipped & unzipped, as a mater of a fact I find all this more than #¤&$$€$€
They are on-topic however. Your threads aren't. This is not a "DB for idiots" forum. Either you start posting things that are at least remotely relevant, or you will be evicted.
I came hire & found out about tagging. I thought its a good idea. Lets make a fully portable database + GUI interface & 1 click import & export support for users to fast & easy store their tags in the database. In case some good app is developed you can easily import all ur tags.
I was planning to share it with you guys once I have finished making it. But it seems you are not interested. My bad, I wont post a word regarding this anymore.
