FWIW, a JSON dump of the BQ mirror is available in the Danbooru2017 torrent I released last month: forum #142978
Posted under General
FWIW, a JSON dump of the BQ mirror is available in the Danbooru2017 torrent I released last month: forum #142978
seems many people can't access the db queries- now you must use FROM `danbooru-data.danbooru.posts` instead of [danbooru-data.danbooru.posts]. And with this all simple request like image size can be written and applied. example for 1 special image :
SELECT id, parent_id, has_children, tags, image_width, image_height
FROM `danbooru-data.danbooru.posts`
WHERE (image_width =1024) LIMIT 10
or switch in 'More' - 'Settings' to old SQL dialect to use examples posted above.
(now Im looking for some help in this new dialect to make queries in posts tag.names. Would be glad to see example of " WHERE tag.name = 'some_tag' " here, thanks)
kex234 said:
seems many people can't access the db queries- now you must use FROM `danbooru-data.danbooru.posts` instead of [danbooru-data.danbooru.posts]. And with this all simple request like image size can be written and applied. example for 1 special image :
SELECT id, parent_id, has_children, tags, image_width, image_height
FROM `danbooru-data.danbooru.posts`
WHERE (image_width =1024) LIMIT 10
or switch in 'More' - 'Settings' to old SQL dialect to use examples posted above.
(now Im looking for some help in this new dialect to make queries in posts tag.names. Would be glad to see example of " WHERE tag.name = 'some_tag' " here, thanks)
You have to unnest the tags. For example:
SELECT count(*) as total, p.uploader_id as uploader_id FROM danbooru-data.danbooru.posts AS p, UNNEST(tags) AS t WHERE t.name = "scenery" GROUP BY uploader_id ORDER BY total DESC LIMIT 10;
I've also updated the opening post to explain how to select the new database.
Soberoatmeal said:
Is the BQ ever got updated?
querying from 'danbooru-data.danbooru.posts' got me 2021-10-05 as the latest post, while viewing gs://danbooru_public got updated till now.
what happened?
You need to query danbooru1.danbooru_public.posts, see the link at the top of the original post (I've made the first line bigger).
nonamethanks said:
What do you mean by "won't load"? Do you have a Google Cloud account? Are you logged in?
I do, and it only shows up like this when accessing it and just refuses to load
https://i.imgur.com/Vx5gk2c.png
fortunately, I can access the new database from BQ and can get the latest post.
Soberoatmeal said:
I do, and it only shows up like this when accessing it and just refuses to load
https://i.imgur.com/Vx5gk2c.png
fortunately, I can access the new database from BQ and can get the latest post.
try logging when your in Incognito, this resolved the issue for me a while back