It is currently Fri Dec 15, 2017 7:22 am

All times are UTC - 7 hours





Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 84 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6  Next
Author Message
PostPosted: Thu Jul 14, 2016 7:02 pm 
Offline
User avatar

Joined: Mon Feb 07, 2011 12:46 pm
Posts: 941
OK, then make it as CSV (although using tabs to separate would probably be better than using commas, I think).

_________________
.


Top
 Profile  
 
PostPosted: Thu Jul 14, 2016 7:25 pm 
Offline

Joined: Thu Aug 12, 2010 3:43 am
Posts: 1589
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.


Top
 Profile  
 
PostPosted: Thu Jul 14, 2016 7:44 pm 
Online

Joined: Sun Sep 19, 2004 11:12 pm
Posts: 19347
Location: NE Indiana, USA (NTSC)
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.


Top
 Profile  
 
PostPosted: Fri Jul 15, 2016 9:26 am 
Offline

Joined: Tue Jul 12, 2016 4:57 pm
Posts: 6
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.


Top
 Profile  
 
PostPosted: Fri Jul 15, 2016 9:39 am 
Offline
User avatar

Joined: Sat Jul 12, 2014 3:04 pm
Posts: 950
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.)


Top
 Profile  
 
PostPosted: Fri Jul 15, 2016 4:54 pm 
Offline

Joined: Tue Jul 12, 2016 4:57 pm
Posts: 6
@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!


Top
 Profile  
 
PostPosted: Fri Jul 15, 2016 5:10 pm 
Online

Joined: Sun Sep 19, 2004 11:12 pm
Posts: 19347
Location: NE Indiana, USA (NTSC)
Is there an issue tracker for http://mimeones.com/nescartdb? Should I report issues here, in a new topic, or somewhere else?


Top
 Profile  
 
PostPosted: Fri Jul 15, 2016 9:44 pm 
Offline

Joined: Tue Jul 12, 2016 4:57 pm
Posts: 6
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!


Top
 Profile  
 
PostPosted: Tue Aug 02, 2016 9:39 pm 
Offline
User avatar

Joined: Wed Apr 07, 2010 1:14 am
Posts: 484
Location: Iran
Still it is down?


Top
 Profile  
 
PostPosted: Fri Aug 12, 2016 11:24 pm 
Offline
User avatar

Joined: Wed Nov 25, 2015 7:54 pm
Posts: 41
Any updates? There's a NesCartDB-shaped hole in my heart. :(


Top
 Profile  
 
PostPosted: Thu Aug 18, 2016 12:48 am 
Offline

Joined: Fri Jul 04, 2014 2:34 pm
Posts: 296
Location: Germany
Same here, that hole has to be filled again. Hope it's going to be up again and running one day. :(


Top
 Profile  
 
PostPosted: Fri Aug 19, 2016 11:44 am 
Offline

Joined: Tue Jul 19, 2016 6:47 am
Posts: 7
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 :)


Top
 Profile  
 
PostPosted: Fri Aug 19, 2016 11:51 am 
Offline

Joined: Tue Mar 22, 2016 8:27 pm
Posts: 16
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.


Top
 Profile  
 
PostPosted: Fri Aug 19, 2016 12:43 pm 
Online
User avatar

Joined: Sat Feb 12, 2005 9:43 pm
Posts: 10164
Location: Rio de Janeiro - Brazil
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.


Top
 Profile  
 
PostPosted: Fri Aug 19, 2016 2:20 pm 
Offline
User avatar

Joined: Sun Jun 11, 2006 2:52 pm
Posts: 32
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!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 84 posts ]  Go to page Previous  1, 2, 3, 4, 5, 6  Next

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group