Posted December 20, 2017
![Lexor](https://images.gog.com/d9403ce9903b32282e1e73e4a1f36c196ee10ae4cc3f2981f72056c3491920ed_forum_avatar.jpg)
Lexor
👽
Registered: Apr 2010
From Poland
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted December 20, 2017
high rated
![avatar](http://images.gog.com/7c363ae6ae7d1bfada6c3e88db1faf265850f735e49b1a348d25d86ec9344cd7_avm.jpg)
![avatar](http://images.gog.com/4a9c2a53dc2b65b58af73f6548da03780dd70ff88dd3eef09dc129fc90f12682_avm.jpg)
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted February 15, 2018
high rated
GOG DB has a new domain! I just switched the DNS entries over to the new server which should now automatically redirect you to https://www.gogdb.org. Nothing else changes, I just had the opportunity to save a few euros a month by switching to a new hosting model and though it's time to buy a proper domain as well. It's probably a bit risky to do this in the middle of a sale, but it's been prepared for about two weeks now and I didn't want to wait any longer. As always, please report bugs and thanks for following this project.
user deleted
New User
Registered: May 2013
From United States
Posted February 15, 2018
![avatar](http://images.gog.com/d7d8e3ed8ad2d9fd3557c83c4237a913b14e621c84e21fab594a9d961cd98fe4_avm.jpg)
Post edited February 15, 2018 by user deleted
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted February 15, 2018
![avatar](http://images.gog.com/d7d8e3ed8ad2d9fd3557c83c4237a913b14e621c84e21fab594a9d961cd98fe4_avm.jpg)
![avatar](http://images.gog.com/f3d332087a0b58c80ad6abf47272602a4b94db20f8c6c8f8b4333b30efb2bded_avm.jpg)
Edit: Should be fixed now, thanks for reporting.
Post edited February 15, 2018 by Yepoleb
user deleted
New User
Registered: May 2013
From United States
Posted February 15, 2018
Lol. xD
Anyway I been meaning to ask have you thought about changing the search feature to be more of a Live Search, using JQuery/AJAX or whatever? Like GOG's search bar, type a few characters and see all the products without a page refresh?
You could also add some more info to the home page like SteamDB does, like top 20 newest releases on GOG, total games in catalog, number of file changes today, etc... some basic information.
Just some ideas, I really like what you have done with the GOG DB. :)
Anyway I been meaning to ask have you thought about changing the search feature to be more of a Live Search, using JQuery/AJAX or whatever? Like GOG's search bar, type a few characters and see all the products without a page refresh?
You could also add some more info to the home page like SteamDB does, like top 20 newest releases on GOG, total games in catalog, number of file changes today, etc... some basic information.
Just some ideas, I really like what you have done with the GOG DB. :)
Post edited February 15, 2018 by user deleted
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted February 15, 2018
![avatar](http://images.gog.com/f3d332087a0b58c80ad6abf47272602a4b94db20f8c6c8f8b4333b30efb2bded_avm.jpg#Q&_^Q&Q/#USERNAME)
user deleted
New User
Registered: May 2013
From United States
Posted February 15, 2018
Cool no problem, I wasn't sure what more you could really add using the GOG API... it doesn't seem as fleshed out as Steams right now. More features would be nice though. :)
![Gede](https://images.gog.com/d4f99113f8c78fb939af08fc087b14a6e1b6fe09370786fc8e9f3e8d33c0e618_forum_avatar.jpg)
Gede
GNU/Linux user
Registered: Nov 2014
From Portugal
Posted February 16, 2018
This project is great! Lots of useful information. Thank you very much for your work.
Would it be possible to download the data for use in other projects in some way? I did not find any information regarding this on the website. Magog provided a convenient link.
Would it be possible to download the data for use in other projects in some way? I did not find any information regarding this on the website. Magog provided a convenient link.
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted February 17, 2018
I'll figure out a way to export the data when I set up an automated backup system, which should happen pretty soon.
![Gede](https://images.gog.com/d4f99113f8c78fb939af08fc087b14a6e1b6fe09370786fc8e9f3e8d33c0e618_forum_avatar.jpg)
Gede
GNU/Linux user
Registered: Nov 2014
From Portugal
Posted February 17, 2018
![avatar](http://images.gog.com/d4f99113f8c78fb939af08fc087b14a6e1b6fe09370786fc8e9f3e8d33c0e618_avm.jpg)
Would it be possible to download the data for use in other projects in some way? I did not find any information regarding this on the website. Magog provided a convenient link.
![avatar](http://images.gog.com/d7d8e3ed8ad2d9fd3557c83c4237a913b14e621c84e21fab594a9d961cd98fe4_avm.jpg)
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted February 17, 2018
high rated
First backup file is up https://www.gogdb.org/backups/
Edit: Some more information about the backup files:
They're created using the PostgreSQL \copy command from all the tables in the database. Output should be classic CSV format with strings quoted as necessary. If you want to know more about how the tables are connected, check model.py of the source code. To always get the latest version in a script, get filelist.txt first and download the file on the last line. New files are created every day at 00:00 CET.
Edit: Some more information about the backup files:
They're created using the PostgreSQL \copy command from all the tables in the database. Output should be classic CSV format with strings quoted as necessary. If you want to know more about how the tables are connected, check model.py of the source code. To always get the latest version in a script, get filelist.txt first and download the file on the last line. New files are created every day at 00:00 CET.
Post edited February 18, 2018 by Yepoleb
![Wirvington](https://images.gog.com/a17d8e11f331489c7b37088f9499693dbcbe4de75d8f8d63ba564d717d8fbbe6_forum_avatar.jpg)
Wirvington
Mon Oncle
Registered: Dec 2013
From Nauru
Posted February 17, 2018
Congrats Yepoleb, this is such an awesome work, I can't believe I'm discovering it now. Great usability and display of information, the changelog feature is great. Keep it up.
![HypersomniacLive](https://images.gog.com/fc4a1abc37a5fe68e4e7fe666d87976d9900b9f928128c087fa9bbdf2e3e4bc4_forum_avatar.jpg)
HypersomniacLive
The Reluctant Voter
Registered: Sep 2011
From Vatican City
![Yepoleb](https://images.gog.com/7609843934988522da291b49b951cbfa63b5495730daa349c29f5717b89c09b4_forum_avatar.jpg)
Yepoleb
GOG DB Developer
Registered: Dec 2015
From Austria
Posted February 18, 2018
![avatar](http://images.gog.com/1809a2512d620d4b959a2bd084834cf59f4a2389aba723f6c49c638fee5f408e_avm.jpg)
Thank you and everyone else who has left a nice comment. I don't usually respond to them because it would feel weird to have half of the thread filled with thanks, but I still appreciate them.