Database Software

CouchP

I am a software developer as well as a coin collector, Are there any good applications out there that may be in the public domain? I would be interested in building a system that could be public domain.

Any other developers out there interested in doing one? That is, if there isn't one already.

I code in C# and use SQL server for my primary datrabase system.

Thanks

Paultjuno

Heck that might be a fun application to write. I'm primarily a VB.NET and SQL Server 2000 developer. I always thought it would be fun to write it as a web based application for anyone to use. I have done some minor C# development, but nothing enterprise class. Might be fun just to tinker with C#. PM me and maybe we can work on something.

crito

I do most of my coding in SQL. The server spits out a new web page when data changes. wastes a lot less bandwidth and CPU time that way. No point in 100 users running the same query when they're all going to get the same result set back. Ad hoc queries aren't usually allowed on a production box anyways... I have some web apps (which don't require data entry from web) that don't connect to the SQL Server at all, data is 100% secure that way too.

CouchP

I am talking mainly of a system to track personal coins. Especially one that would value coins using PCGS or another service.

crito

There was a browser based app someone posted here that looks up prices while surfing eBay auctions. Looked pretty slick, I never installed it tho. would be nice to have a public place on web to upload pics and cert #'s of stolen coins... much better chance a fellow collector will spot them, than the cops recovering

ursabear

You could definitely stretch the C# skills to use traditional Java for the front end, and you can use MySQL on the back end to do the data if the amount of data is extensive.

Similarly, if the database is not going to hold more than about 1000 blobs of objects, you could also use an XML database (that is, files in the filesystem), set up with relationally-enabled XML files and DTDs (very lightweight, very fast, no cost or licensing issues.)

If you wanted to host it on the web somewhere, most ISPs have Servlet/JSP-enabled packages for a little more money than plain hosting. If you're going to host it as an app on desktop, your choices abound greatly because you are not chained to someone's server.

TWODOGS

HUH???

crito

MySQL doesn't even support foreign keys, it's not really relational. Good way to get an unmanageable mess. Might as well use a flat file IMO, weak implementation of language anyways.

CouchP

I concur crito, open source is not just for the Java. Personal SQL server is going to be ubiquitous in a short while, and we have not seen the tip of the .NET iceberg.

All that aside, Java developers should be able to assist in a project such as this, in fact, they would be more than able to make a huge contribution.

dingodog

CouchP,

Welcome to the group!

You might want to check out our program. It is not public domain but I am giving it away free - at least for the time being. You can download it at http://download.coinweb.org/ (or at least you should be able to - server is down right now but should be back up after 08:30 Monday Dallas). If you can't download it (total download is about 90 mb), email me your mailing address to janrschwenk@attbi.com and I will send you a cd-rom, no charge.

Our software is currently in Access 2002-XP and SQL but is partly written in Microsoft.NET (various languages), and when it is finished will be fully "Dot Net". I run a small SW development firm that writes large scale ERP, now almost exclusively in "Dot Net".

We've been developing this for three years now and have some rather extensive plans for it. We intend to invite qualified programmers to work with us as local projects develop.

Rgds
Jan

nwcs

Sound like my kinda guy. I'm a .NET SQL 2000 person myself. Specifically C# these days.

rainbowquarters

Hi All,

I've developed a database application for myself....VB6 and SQL Server 2000. Nothing fancy, allows me to enter the coins I collect, and I also enter auction and retail data. This allows me to check "reference data" for a particular coin or series and I've tied in the PCGS population reports.

When I was collecting Washington Quarters, I had over 4000 reference entries, could tell you the lowest and highest prices paid and when and the current PCGS pop. It's time consuming to enter all the data, but it's worth it, having all this reference data in one spot.

However, I couldn't figure out how to get it on the web. If anyone wants, I could email an executable, but I guess you need to have a SQL Server backend for it to work properly.

dingodog

Don,

Very interesting! Please send your executable to me at janrschwenk@attbi.com. Thanks! Have you seen our COIN Inventory software - free for download at http://download.coinweb.org/ or email me your mailing address and I will send you a cd-rom. We are doing for all U.S. coins what you did for quarters.

Heck, maybe we could even help you get some coin programming work if interested.

Rgds
Jan