I'd like to run a FreeDB server on my Windows box at home so I don't have to stay connected to the internet to get the track listings for the CD's I want to upload into iTunes. However, although I can find a zillion FreeDB aware clients, I'm having difficulty finding a native Windows version of the server
. Does such a thing exist? [more inside]
posted by ralawrence
on Jun 6, 2005 -
I've been given 700 Word documents some
of which I'll need to edit, based on content. The values to be queried are stored in named fields in the documents. [more inside]
posted by punilux
on May 26, 2005 -
Part of my job is to get press coverage for clients, mainly in newspapers. I'd like to be able to store scans of these in a web-accessible database so that they can view them online. [more inside]
posted by blag
on May 10, 2005 -
Isn't there some simple way to list out all the fields in all the tables in an MS Access database? [more inside]
posted by jasper411
on Apr 28, 2005 -
I'm looking for a community-editable database. Philosophically similar to a Wiki, but with some webmail-like features, including the ability to sort and filter various things, show and hide columns when there are too many to fit on screen, and edit a single record by itself, rather than the whole massive body of text. [more inside]
posted by Myself
on Apr 25, 2005 -
There's a breed of software which you point at a database and which then generates an add/edit/delete web interface for all the tables. (examples a
) I've seen a four-letter acronym used to refer to it, but I can't come up with it and I'm spending way too much time surfing to find it. Help!
posted by Tubes
on Mar 27, 2005 -
I'd like to store people's postcodes and work out distances between them. I think I need a postcode-to-coordinates database, and then a way of working out the distances... [more inside]
posted by reklaw
on Mar 15, 2005 -
Is there a free, online database of lawsuits filed in the US? My Google-fu is no match for awesome super-powerful search engine spam... [more inside]
posted by stringbean
on Mar 13, 2005 -
I've taken on a little mini project and I think the best way to get the job done will be to use one of those little bits of software which can copy and then simulate mouse movements etc. [more inside]
posted by uk_giffo
on Mar 12, 2005 -
I need a few hundred to a few thousand general knowledge or trivia questions that I can integrate into a application I'm writing. [more inside]
posted by Mitheral
on Mar 11, 2005 -
Is there such a thing as a freely available database of Congresspeople? Names, districts, party affiliations, etc. Preferably easily loadable into a MySQL database. You'd think with the success of grassroots politics on the web someone would be offering one, but everything I've found wants me to pay a significant amount of money for one.
posted by crawl
on Mar 4, 2005 -
I have a client database with about 200K records in it. Addresses were fed in by a variety of people so there're tons of typos/missing information and not much in the way of standardization. I need to do some postal processing (CASS, DSF2, LACS and NCOA) on the file. Is that something that's mostly done in software and so could be done in-house, or does it require a lot of specialized human intervention and so something that it makes more sense to outsource? If it can be done in-house, where would I look for software to do it? If it should be outsourced, what should I expect to pay for a file with 200K records?
posted by willnot
on Feb 24, 2005 -
A long time ago, I was taught to store to currency values in databases as cents (or the local equivalent) to avoid rounding problems with floating point column types. Is this a sound practice, or a bunch of hogwash?
posted by alan
on Feb 9, 2005 -
Suppose you wanted to scrape information from a web page and dump it into a CSV file for use in a database - specifically a large table of contact information coded in HTML. Is there an application (I work in OS X, but have access to Windows machines) that will do this? Would it be possible to write up an AppleScript or something similar to do the job?
posted by aladfar
on Feb 7, 2005 -
fails: I'd like to research the development of news websites - specifically those established by traditional media companies (CNN, The New York Times, etc). While archive.org is a valuable resource, many of the sites I'd like to look at block the automated scripts (robots) that make archiving possible. What's more, some of the sites archived are woefully incomplete and are missing images, etc. Is there an alternative to archive.org or another resource that I might use? [more inside]
posted by aladfar
on Jan 22, 2005 -
Wine Databases (with barcode support):
Does anyone have any experience cataloguing their wine cellar? I have a friend (I wish it were me) with a rather expansive collection of wine and a barcode reader, yet the database that accompanied the reader is quite sparse. Can anyone suggest an alternate, more robust database with barcodes, or another solution out of personal experience? Google returns a mutlitude of dodgy-looking sites making dubious claims. Thanks!
posted by loquax
on Jan 19, 2005 -
I've searched and searched, but is there a database available to find general crimes in your neighborhood like burglaries? I know about the sex offender database, but I can't find anything but general statistics from the police department. I'm in Chicago.
posted by agregoli
on Jan 4, 2005 -
I'd like to build (or have built for me) a comparison engine like FetchBook
. Basically, a comparison engine that compares prices of books, and then if the user clicks over to buy the book from one of the affiliates, the program would append my account code, getting me a kickback on the referral.
I have no idea how to do this, or what it would cost to pay someone to do it. What would be the best way to figure this out? Are there any open source comparison engine scripts? If I had to pay someone to build something like this, what should I expect to pay? (I can do all the frontend work, just not the backend.)
posted by Alt F4
on Dec 22, 2004 -
I am looking for a resource, preferably online, that will give me historical real estate sales data for a particular city. Ideally I would like to see the average sales price by month from the year 1974 until the present. Any ideas?
posted by tirebouchon
on Dec 18, 2004 -
I have been given the task of looking up the year-of-release for a large number (~8000) songs. Many of these titles are European, Latin American, and South American. Allmusic.com is okay, but slow and not as comprehensive as I require--esp. for uncommon titles. I'd bet that I have to find some specialized databases. Anyone have a suggestion?
posted by mdpc98
on Dec 14, 2004 -
Any resources, online or print, that can give me a good grounding in Oracle databases - admin/design.
Need to gen up for an electronic records management system that my company wants to buy.
posted by the cuban
on Dec 14, 2004 -
I know how to make database-driven web sites using Windows servers, Access, IIS, and ASP.
I want to learn how to do the same using Linux, Apache, MySQL, PHP, and... whatever you use instead of Access.
Where do I start?
posted by Mwongozi
on Dec 10, 2004 -
Baseball/Hockey cards: Does anyone have any opinions about any of the software that purports to help with organization of sportscards? Does anyone still collect cards?
I'm looking more for personal experience and recommendations. If it helps, I'm looking to categorize and sort older cards (say, pre-1990 but after 1970), and almost exclusively hockey and baseball singles and sets. Thanks!
posted by loquax
on Nov 19, 2004 -
Does anyone know of a website that lists songs and the tracks they stole samples from? My googlefu has failed me.
posted by twine42
on Nov 19, 2004 -
Your favorite searchable free photo archive?
posted by mecran01
on Nov 17, 2004 -
As per this question
a couple of weeks ago, the insurance company paid up and I'm the owner of a brand new Canon 20D
. Unfortunately, the new camera didn't come wiht any database software like my old D60 did. Now I need a new way to keep track of all the photos. (MI)... [more inside]
posted by trbrts
on Nov 17, 2004 -
How do you figure out who owns the rights to something? Specifically, I want to know who owns the rights to an old movie ("Dead of Night
"). But I thought it might be useful to open the question up a bit more. Are there good databases out there where I can look up a book, song, movie, or whatever and find out if it's public domain or owned by someone -- and, if so, who owns it?
posted by grumblebee
on Oct 31, 2004 -
Any recommendations for simple and cheap Mac database software?
posted by ajr
on Sep 27, 2004 -
Does anyone know of a freeware or shareware database program that can read and edit .fp5 files? I know they're proprietary to filemaker. [more inside]
posted by Metametadata
on Sep 15, 2004 -
I know, I know -- not another
web photogallery AskMe question, but: I've actually settled on the gallery itself. I'm using JAlbum. Having made the choice, though, I'm left with two questions:
1. JAlbum makes nice galleries, but doesn't create a top-level index page. (I could hand-code it, but my wife will be doing most of the updating and I don't want her to have to go mucking around in HTML.) The easiest solution, I'd think, would be just to reformat the directory listing into something attractive -- all I really need to communicate to the user is descriptive folder names and upload dates, but I'd prefer to make something more handsome than the standard Apache page. Can anyone recommend a particular PHP file system manager or other solution?
2. JAlbum's auto upload is ridiculously slow -- better just to FTP it. When JAblum makes a gallery, though, it includes a lot of stuff I'm not using -- icon sets, borders, etc. It's not a ton of space, but I'm going to uploading a lot of these galleries, and it'll add up. Is there a programmatic way I can stop JAlbum from including all this, instead of weeding it out before each upload? (I'm using the BluPlusPlus skin.)
posted by blueshammer
on Sep 5, 2004 -
I need to set up a database-driven document archive of mostly text files and links. I want the archive to have a tree structure and allow the public to browse it without logging in. I want each file to have a description. I prefer PHP or Perl and need to use it on a shared hosting account. I would think something open source like this would be out there, but I can't find it. Any advice?
posted by johnnydark
on Sep 4, 2004 -
Does anyone know of any search engines that will also index non-plaintext documents (i.e. PDF's and Powerpoint)? Google has a search appliance, but we're looking to spend less than $2K.
posted by hobbes
on Jul 25, 2004 -
A pal of mine has asked me to help him build out a small shipping-and-fulfillment center serving an online store he started recently. Things are going well, but my part of the work will be most challenging. Advice? Recommendations? [the interior features the more.] [more inside]
posted by mwhybark
on May 19, 2004 -
I am a freelance journalist, and a document freak. But also I am very chaotic. I would like to use some sort of database to keep track of the articles, documents, web snippets, references, quotes, URLs, bibliography that I use in my work. But I have many questions and doubts [more].
Should I use a database that it is linked to the external documents (which I keep nonetheless), or should I go for a database that has all of these documents embedded? I work in a Windows / OSX environment (desktop PC and a G4 Powerbook), so this keeps me from going all the way to Access (which I hate) or Filemaker (which I don’t know very well). I’ve been thinking of keeping a MySQL database server, maybe powered with a modification of something like Everything
, and accessing the data via web browser, but I fear that the thing wouldn’t escalate well. (Keep in mind that I am not a programmer, I can install Movable Type or GeekLog in my webserver, and tinker a little with php files changing little things here and there, although I have friends that can help me)
I don’t know if there are built-in solutions for what I need, or if you can point me to a database template (for Access or FileMaker) already built for journalist research. The fact is that I have tons of information and documents (some of them already stuffed in CD and DVD backups), but I have a hard time keeping track of everything, and very often it is very difficult for me to retrieve information that I know I have saved but I can’t tell where it is.
posted by samelborp
on May 11, 2004 -
UI design question -- I have a Windows application, basically a frontend to a database, whose interface has mututated over the years, through various "enhancements," to the point that it's almost unusable by the non-technical people for whom it exists. Anyone have any recommendations of firms that do UI makeovers? What could I get for around $5,000?
posted by stupidsexyFlanders
on May 3, 2004 -
Can anyone remember the site which was a database of logins to subsription sites?
posted by Mr Ed
on Apr 22, 2004 -
Say I have a database
there is a table called
In this table is a field named
. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all. [more inside]
posted by Grod
on Apr 17, 2004 -
Sorting digital images. I went digital a year and a half ago and I still
haven't figured out a way to sort my pictures that really works for me (by which I mean edit, in the sense of going through and picking out the keepers and organizing them by merit, subject, whatever). Before I went digital I used to just get cheap 4x6 prints of everything on every roll and had a very efficient system for sorting through, editing and organizing them, is there anything software-wise which makes this intuitive and easy, or should I just start printing? I find moving images around in folders really counter-intuitive for this purpose. Any suggestions?
posted by biscotti
on Mar 7, 2004 -
Invoicing with MS Excel--squeezing relational database features out [MI]
posted by adamrice
on Feb 17, 2004 -
Suppose I wanted to build a web site on which a number of items was listed that were available for members of that web site to sign out. I would want the status of items (in/out) to be viewable by people looking to take out items in real time. What would I need to do this and who would I hire to do it? In addition, what would I expect to pay? What's the best way to find such a person?
posted by dobbs
on Feb 5, 2004 -
Is there a way, without constant human intervention, to (1) mine either Google News, Yahoo News, or the AP for new obituaries and (2) drop the name, age, blurb, and URL into a database? [more inside]
posted by PrinceValium
on Jan 23, 2004 -