Main Restorations Software Audio/Jukebox/MP3 Everything Else Buy/Sell/Trade
Project Announcements Monitor/Video GroovyMAME Merit/JVL Touchscreen Meet Up Retail Vendors
Driving & Racing Woodworking Software Support Forums Consoles Project Arcade Reviews
Automated Projects Artwork Frontend Support Forums Pinball Forum Discussion Old Boards
Raspberry Pi & Dev Board controls.dat Linux Miscellaneous Arcade Wiki Discussion Old Archives
Lightguns Arcade1Up Try the site in https mode Site News

Unread posts | New Replies | Recent posts | Rules | Chatroom | Wiki | File Repository | RSS | Submit news

  

Author Topic: Database project  (Read 1412 times)

0 Members and 1 Guest are viewing this topic.

Generic Eric

  • Trade Count: (+2)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 4520
  • Last login:July 15, 2024, 09:18:25 pm
  • Restore! Don't maim for MAME, build from scratch!
    • forum.arcadecontrols.com/index.php/topic,143226.0.html
Database project
« on: February 28, 2014, 03:21:17 pm »
I'm looking for some hints on where to get started. 

Parameters
I have a project of digitizing a register of over 85,119 things with with several attributes.
1 of 2 particular attributes                  
1 of 100 or more attributes,                      
1 to 53 or more attributes,                  
1 to 55 or or more attributes,               
1 to 260 or more attributes,               
1 to 18 or or more attributes, made of 1 to 6 or more attributes that have 3 subsets unique to them.   
For one or more durations of time,
within periods of time,
during time
8 digit number
9 digit number

 
Background:

I read about a book about rational databases.  I've heard XML is where it is at. I think I'll need mysql.  Can anyone point me somewhere to start?  Hardware? Primers, white pages, books?  I failed miserably at access and I can't use excel to do anything but sum a column and look exactly like I want it to.  Thanks.

The most unique computer things I have done were slipstreaming XP cds so I wouldn't have to download drivers each time.  Compile MAME
run an apache server on my 3rd generation ipod to share files to share on a corporate network.  I only mention that because with the exception of the slipstreaming (easy interface) the others were up hill climbs.

ark_ader

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 5645
  • Last login:March 02, 2019, 07:35:34 pm
  • I glow in the dark.
Re: Database project
« Reply #1 on: February 28, 2014, 03:47:28 pm »
You could get a way with using  Access 2003+, but I would look at using MySQL.

As long as your images are low res I'm sure Access will be your huckleberry.

Heck you could write an app in C sharp for the front end.
If I had only one wish, it would be for three more wishes.

jdbailey1206

  • Trade Count: (+1)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 2656
  • Last login:March 11, 2023, 01:32:56 pm
  • No. It's your top score on Pole Position.
Re: Database project
« Reply #2 on: February 28, 2014, 03:56:08 pm »
Congrats to you if you can find a copy of 2003.  I had a heluva time finding 2010.  But yes Access is a neat little program.  I would try to find something comparable that is free.

ark_ader

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 5645
  • Last login:March 02, 2019, 07:35:34 pm
  • I glow in the dark.
Re: Database project
« Reply #3 on: February 28, 2014, 04:50:25 pm »
Congrats to you if you can find a copy of 2003.  I had a heluva time finding 2010.  But yes Access is a neat little program.  I would try to find something comparable that is free.

Free to me (including Access 2012) with my MSDNAA account.  If my memory is right TinyXP has Access 2003 as a plug-in.  But I didn't say that.  ;D

You can try the 1 month trial to see if Access fits the bill.
« Last Edit: February 28, 2014, 05:04:14 pm by ark_ader »
If I had only one wish, it would be for three more wishes.

Generic Eric

  • Trade Count: (+2)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 4520
  • Last login:July 15, 2024, 09:18:25 pm
  • Restore! Don't maim for MAME, build from scratch!
    • forum.arcadecontrols.com/index.php/topic,143226.0.html
Re: Database project
« Reply #4 on: February 28, 2014, 07:53:01 pm »
was replying when my laptop overheated.  Pearls of wisdom are lost in limbo.

Anyway.  I'm gonna go ahead and give Access a shot.  I can truncate the project by reducing one of the variables to one.

Coincidentally, that is one of my midpoint goals anyway.

I have access to Access.