721 posts tagged with database.
Displaying 551 through 600 of 721. Subscribe:

What database should I use?

Help me avoid Microsoft. I need a simple database programme, is there a good cheap alternative to MS Access out there? Can anyone recommend OOo base? [more inside]
posted by Touchstone on Jan 28, 2007 - 25 answers

Save me two weeks of manual labor, please

I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?
posted by schroedinger on Jan 26, 2007 - 9 answers

How do to update rows without a cursor?

How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted by apark on Jan 24, 2007 - 5 answers

Formatted movie data availability?

I'm working on a site that requires a movie database. Help me find formatted data! [more inside]
posted by null terminated on Jan 10, 2007 - 11 answers

I don't wanna be a cutter!

Is there an easier way to combine CSV files? There is a bit [more inside]
posted by keep it tight on Jan 9, 2007 - 9 answers

Help w/ importing flatfiles!

Flat file importing best practices? tips? ideas? [more inside]
posted by apark on Jan 2, 2007 - 20 answers

No database for the average Joe

Librarian type question: how on earth can I get access to the National Security Archive database by Proquest? I am writing some articles on the Cold War on Wikipedia and want to see some of the documents in this collection, but Proquest/Chadwyck doesn't deal with individuals. They even offer free trials, which I can't get because I'm not an individual. Am I out of luck? [more inside]
posted by zek on Dec 28, 2006 - 8 answers

What's the best approach to building a lightweight database app?

I have been asked to write a database application that will be running in a storefront situation and will allow the user to enter data on what is sold (in this case, bicycles and bicycle accessories and parts) and generate basic bookkeeping reports (i.e. end-of-day sales, quarterly sales, that sort of thing.) [more inside]
posted by evisceratordeath on Dec 20, 2006 - 8 answers

Where do they get all those wonderful data?

WhereTheHellDoTheyGetAllThatData Filter: When someone wants to start a site that requires huge amounts of data like IMDB or Pandora or Last.FM, where do they get the data? [more inside]
posted by jxpx777 on Dec 18, 2006 - 18 answers

From Mail to Filemaker?

How can I automagically parse the oddly-formatted text from the body of an email so that Filemaker can use it? [more inside]
posted by bink on Dec 17, 2006 - 12 answers

Music, sweet music, I wish I could caress and kiss and find ...

Help me find industrial-strength software to catalog an extremely large CD collection. [more inside]
posted by jbickers on Dec 15, 2006 - 6 answers

Open source media contacts/relations database suggestions?

I'm looking for a free (or nearly) solution for storing an existing list of media contacts. [more inside]
posted by Pacrand on Dec 14, 2006 - 2 answers

Selecting the MODE of a group of data in Microsoft Access

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 answers

How do I format raw data that will eventually be part of a database?

Complete database newbie. I have raw information in the form of text, numbers and photos. This stuff will eventually be fed to users on a web site. I am in the information-collection phase now. What's the best way to collect and format the data so it has the easiest possible path into a database that will serve the web site? [more inside]
posted by crosten on Dec 10, 2006 - 9 answers

School needs centralized site for lesson plans

I'd like to develop a searchable (by tags) database of leson plans for the 20 odd teachers at my school. Any ideas? [more inside]
posted by bronxteacher on Dec 7, 2006 - 4 answers

How to begin on this multi user PHP stats project?

How would you write an application in PHP that tracks multiple users, and the users' multiple sites? [more inside]
posted by gradient on Dec 5, 2006 - 7 answers

How to get mySQL to ignore "A, An, & The" when presenting alphabetized book titles

mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted by Wild_Eep on Dec 5, 2006 - 10 answers

+book +find +help

Where should I search in order to generate a list of all/most books published (in English, for the past 20 years or so) about a particular topic? I have a feeling that using Amazon plus my local library isn't giving me comprehensive results. Is there some kind of all-libraries database? Or all books that have been issued ISBN numbers?
posted by xo on Dec 2, 2006 - 6 answers

What are some database high-performance clustering options?

I need recommendations for affordable database solutions that provide high availability and high performance, preferably in a clustered environment. [more inside]
posted by SNACKeR on Dec 2, 2006 - 6 answers

How do I get the record with the most current date by a key field?

SQL question: How do I get the record with the most current date for each person's ID? Better explanation inside. [more inside]
posted by DakotaPaul on Nov 21, 2006 - 14 answers

Please help with an Access/Database question!

Help with MS Access needed please - I'm told it should be a fairly simple query to conduct, but I don't think I'm upto the task solo. Can the hive mind help? [more inside]
posted by dance on Nov 18, 2006 - 12 answers

Mysql... why won't you accept more connections?

Mysql5... why won't you accept more connections from a set of IP addresses? [more inside]
posted by ph00dz on Nov 16, 2006 - 12 answers

Sick of allmusic.com!

MusicResourceFilter: Are there any alternatives to allmusic.com that has as comprehensive a database for band discography, biography, and ratings, with an online presence that DOESN'T suck? [more inside]
posted by blastrid on Nov 10, 2006 - 10 answers

Best customer database for a small business?

Need to figure out the best kind of database for a small but growing business. MS Access isn't cutting it anymore. Of course there's [more inside]
posted by TayBridge on Nov 5, 2006 - 32 answers

MySQL import question

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

Using a Database for analysis of temperatures

I've got an interesting question about MS Acess. It involves using lat/long data... Anyone care to help? [more inside]
posted by dance on Nov 2, 2006 - 15 answers

SQLServer Express remote connection problems

SQLServer Express remote connection problems. Please hope me! [more inside]
posted by derbs on Nov 2, 2006 - 9 answers

mySQL table viewers?

Stupid database question: what are some quick "viewer" applications my customers can use to work with data I'm providing locally in a mySQL database? [more inside]
posted by hodyoaten on Nov 1, 2006 - 10 answers

Organizing software in an enterprise

Any good tips on managing approved software applications within an enterprise? [more inside]
posted by daHIFI on Oct 26, 2006 - 4 answers

Why no worky?

SQLServerFilter: Quick question about views and using "NOT IN". [more inside]
posted by SoulOnIce on Oct 21, 2006 - 4 answers

orthogonality isn't a SQL know-it-all after all, let's laugh at him

Help! Stumped by an SQL problem. [more inside]
posted by hangashore on Oct 21, 2006 - 21 answers

I need help with counting.

I got the job. Now I need a little help with it. Someone I briefly worked under while at this job has posed a Microsoft Access question to me. I understand a good amount of Access but this was immediately over my head. I told her that I would see what I could find out for her. [more inside]
posted by horseblind on Oct 18, 2006 - 10 answers

Bridging PHP and Python object serialization

Bridging PHP and Python object serialization [more inside]
posted by Blazecock Pileon on Oct 10, 2006 - 7 answers

Looking for an easy to use database interface

I need to collect a list of names and addresses at a trade show on a Windows XP Home Laptop. It needs to be setup in such a fashion that attendees walking past our booth can input thier information themselves. How can I do this? [more inside]
posted by trbrts on Oct 6, 2006 - 12 answers

Database for a small merchant

Help, business owners! I run a mail order business -- about 3-5 orders a day, with about 15 items in stock. For years I have used an Excel spreadsheet to keep track of orders. Is there a better way? [more inside]
posted by hodyoaten on Oct 2, 2006 - 5 answers

Bootleg Trading Software?

Are there any free PHP and MySQL based apps for setting up a bootleg trading site? [more inside]
posted by SansPoint on Sep 27, 2006 - 2 answers

MySQL performance tuning

How to improve MySQL (5.0.22-max-log, PPC) + InnoDB table performance? [more inside]
posted by Blazecock Pileon on Sep 24, 2006 - 9 answers

Help me explain this idiosycratic problem with FoxPro (v 6.0)

A direct copy of a database table (as in, right-click on file, select "copy" and "paste" in the same directory) resulted in data going missing. Then, the data mysteriously re-appear. What's going on? [more inside]
posted by parilous on Sep 20, 2006 - 2 answers

What's the best way to store hierarchical data?

What's the best way to store hierarchical information in a database, and what's the best way to retrieve it? [more inside]
posted by kirkaracha on Sep 6, 2006 - 11 answers

It's just a page with links on it...why is it so complicated?

What's the best way to save files from a website that requires authentication? [more inside]
posted by Sallysings on Sep 6, 2006 - 15 answers

Seeking Free Victorian to WWI-era Photos

Where can I find a large database of photgraphs like this that are in the public domain? I'm also looking for a large site with pictures from World War I that are free to use. [more inside]
posted by interrobang on Sep 3, 2006 - 9 answers

Finding longest sequence in a set of numbers

I have a question about finding the longest sequence in a set of numbers. [more inside]
posted by maxwelton on Sep 2, 2006 - 13 answers

Reproduction of this coupon is expressly prohibited

I am curious about the legality and feasability of starting a website/database where people just put in the barcode numbers of coupons to share them. [more inside]
posted by GregX3 on Sep 1, 2006 - 14 answers

How can I preserve Unicode characters in `mysqdump`?

How can I make backups of a MySQL database (via mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
posted by cmyers on Aug 28, 2006 - 8 answers

How can I build a database and interface for a book publisher's website?

I work at a small non-profit book publisher, and I need to build a database for our website. [more inside]
posted by mekanic on Aug 9, 2006 - 23 answers

How to determine if a record has a certain value at any given time.

I need some SQL Server/database design help. I have a custom built admin for an ecommerce site where we manage our orders. During the life of an order, it can have many statuses ... [more inside]
posted by SoulOnIce on Aug 4, 2006 - 12 answers

No, no—*million* with an M.

MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted by disillusioned on Jul 19, 2006 - 12 answers

The [Title] bone's connected to the [Lyrics] bone...

MySQL/PHPmyAdmin for a band: How do I easily create a repository of lyrics that can be brought in for multiple albums? [more inside]
posted by Brainy on Jul 17, 2006 - 8 answers

SQLFilter: Advancing Dates

How can I increment a value directly using SQL? [more inside]
posted by samstarling on Jul 17, 2006 - 3 answers

Converting Postrges-specific query to Mysql

I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted by mcstayinskool on Jul 14, 2006 - 14 answers

Page: 1 ... 8 9 10 11 12 13 14 15