nesdev.com
http://forums.nesdev.com/

NES Cart DB down again
http://forums.nesdev.com/viewtopic.php?f=5&t=14335
Page 4 of 6

Author:  zzo38 [ Thu Jul 14, 2016 7:02 pm ]
Post subject:  Re: NES Cart DB down again

OK, then make it as CSV (although using tabs to separate would probably be better than using commas, I think).

Author:  Sik [ Thu Jul 14, 2016 7:25 pm ]
Post subject:  Re: NES Cart DB down again

zzo38 wrote:
(although using tabs to separate would probably be better than using commas, I think).

Until somebody does something dumb that results in tabs being replaced by spaces =P Although it's feasible I suppose.

Author:  tepples [ Thu Jul 14, 2016 7:44 pm ]
Post subject:  Re: NES Cart DB down again

My day job involves "plumbing" (data interchange engineering) for a local R/C car shop's online presence. Amazon prefers tab-separated files, while eBay prefers comma-separated. I've noticed three practical differences between the two:

  1. In order to store a value containing the delimiter, you have to quote the value. This involves replacing all instances of " with "" and then surrounding the value with " on each side. Tab-separated files need far fewer fields to be quoted than comma-separated because a comma appears in things like product titles and manufacturer names more often than a tab. Mainland Europe often uses semicolon-separated files so as not to need to quote a decimal comma.
  2. File associations in GUI file managers differ. If the user has a spreadsheet app installed, double-clicking a comma-separated file is more likely to open in the spreadsheet app, while tab-separated files are more likely to open in a text editor. One often has to manually associate .txt with LibreOffice Calc or Microsoft Excel in the "Open With" menu, while .csv gets associated by the spreadsheet app's installer.
  3. But spreadsheet apps use tab-separated data on the clipboard, meaning data in a tab-separated file can be copied and pasted between a text editor and a spreadsheet. This allows, for example, using RDP's clipboard support as crude file transfer.

I've made some of my tools work with both by reading column headings from the first line of the file, counting commas, semicolons, and tabs in that line, and assuming the delimiter is what there are the most of. Then it reads the rest of the file using that delimiter.

As for SQLite, even when it makes incompatible changes to its C API, Python's import sqlite3 somehow seems to paper over these changes.

Author:  mimeoNES [ Fri Jul 15, 2016 9:26 am ]
Post subject:  Re: NES Cart DB down again

tepples, yes I can have the results open in a separate page via query string or something. That way you can pull up the results without having to re-do your search. Thanks for the feedback. Will keep you posted on when this update is made.

Author:  Myask [ Fri Jul 15, 2016 9:39 am ]
Post subject:  Re: NES Cart DB down again

Being able to search by board name, mapper chip name, and mapper number are the use-cases I tend to have most, not game name. (They're also mostly the ones the wiki uses.)

Author:  mimeoNES [ Fri Jul 15, 2016 4:54 pm ]
Post subject:  Re: NES Cart DB down again

@tepples, I have changed the results to show on a separate page so you should be able to bookmark and direct link now. After selecting the game from the search page, it will redirect to the new page. For the Wheel of Fortune example:

http://mimeones.com/nescartdbdonorlist? ... bile=false

@Myask, I will add more search options where you can search by any of the fields listed as well.

Thank you for the feedback!

Author:  tepples [ Fri Jul 15, 2016 5:10 pm ]
Post subject:  Re: NES Cart DB down again

Is there an issue tracker for http://mimeones.com/nescartdb? Should I report issues here, in a new topic, or somewhere else?

Author:  mimeoNES [ Fri Jul 15, 2016 9:44 pm ]
Post subject:  Re: NES Cart DB down again

tepples wrote:
Is there an issue tracker for http://mimeones.com/nescartdb? Should I report issues here, in a new topic, or somewhere else?

Hi @tepples, you can send me a PM or email me at mimeones@gmail.com and I'll be more than happy to take a look. I will also open up a new thread for feature requests, enhancements and bugs.

@Myask, I have added some additional search filters under Advanced Search. The only other field that's left from the database is iNES mapper number. If that is helpful, I can add that too.

Thanks!

Author:  FARID [ Tue Aug 02, 2016 9:39 pm ]
Post subject:  Re: NES Cart DB down again

Still it is down?

Author:  HVC-Man [ Fri Aug 12, 2016 11:24 pm ]
Post subject:  Re: NES Cart DB down again

Any updates? There's a NesCartDB-shaped hole in my heart. :(

Author:  Ice Man [ Thu Aug 18, 2016 12:48 am ]
Post subject:  Re: NES Cart DB down again

Same here, that hole has to be filled again. Hope it's going to be up again and running one day. :(

Author:  sk8ersublime [ Fri Aug 19, 2016 11:44 am ]
Post subject:  Re: NES Cart DB down again

mimeoNES's page is a great alternative and helped me with my first at making a few games. Thanks for doing that mimeoNES!

Looking forward to the return of the old site :)

Author:  Ben Boldt [ Fri Aug 19, 2016 11:51 am ]
Post subject:  Re: NES Cart DB down again

Thanks for telling us about mimeoNES - that's very helpful.

Is there any way that we could get the original nescartdb database in downloadable form? I didn't realize how heavily I rely on it when I am on the hunt for donor carts for various projects. It is really useful to be able to see inside of the carts and how much extra room is inside, and if there is W-RAM present. I have no idea any other way to tell if W-RAM is present, as the iNES header does not accurately provide this information.

Author:  tokumaru [ Fri Aug 19, 2016 12:43 pm ]
Post subject:  Re: NES Cart DB down again

Ben Boldt wrote:
I have no idea any other way to tell if W-RAM is present

For US releases, you can look up the board names here, and then check the specific page of each board.

Another way to check for the presence of WRAM is to open the game in FCEUX and set up a breakpoint for accesses to $6000-$7FFF, which is the range where WRAM is mapped when present. If the game constantly writes to and reads from that space, its cartridge certainly has WRAM.

Author:  Skrybe [ Fri Aug 19, 2016 2:20 pm ]
Post subject:  Re: NES Cart DB down again

I haven't checked too thoroughly, but archive.org seems to have most of bootgod's DB backed up, save for the most recent uploads. Search doesn't work, though.

Still want the original back, I have stuff to upload!

Page 4 of 6 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/