How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
SQL WTH: various examples given on websites and in a small stack of books don't work. [more inside]
Which database certifications would be most useful, from the point of view of employability? [more inside]
I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
Has anyone ever managed to use iTunes and COM to access the iTunes database and modify MP3 meta-data tags? I need to change the genre for every track by a certain artist and since I have a list of over 800 artists, it is not something I can do by hand. [more inside]
Access DB Filter: Help me figure out how to make a pretty report. [more inside]
Small database project: Should I use Access or SQL Database? [more inside]
We're outgrowing our 10 year old Progress database. We need some recommendations. [more inside]
I want to interact with my music library over a network and be able to add notes, links, etc. to each item. Looking for static or dynamic approaches . . . [more inside]
I have an SQL query that totals the number of students per grade. How do I get a grand total of the number of students? [more inside]
How can I import selected fields from one database into another database? [more inside]
A database by any other name ... [more inside]
MS Access XP: Say I have 3 tables. [more inside]
What is the best and/or most efficient website design software these days? [more inside]
What classical music databases exist? I'm not looking for lists or even data. I am looking for relational database DDL that describes/implements a structure sufficient to describe/model classical music. Or, if you don't know of such a database, classical aficionados, give me advice on how to implement such a database. [more inside]
I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports. [more inside]
Can anyone point me to a good documentation/samples for building an app using mod_python and cheetah? (and mySQL/DBUtils etc)? [more inside]
I'm making a contact database for the first time in Filemaker. I've got a field where I'm entering useful tags. I want to make a front end for this system in the form of a tag cloud. Since I'm so new to Filemaker, I don't know if this is useful or possible -- all I know is Google's never heard of such a thing. [more inside]
I want to build a comparative index of translations for a specific book of poems. How should I do this? [more inside]
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
Needed: a good clipart graphic representing a database (shape of a cylinder) for a quick powerpoint presentation. There has to be something decent in the public domain. Any links? Thanks!
What is the best alternative interface for an SQL server? [more inside]
What considerations should I use in determining file format and size with a digital database that will be available online? [more inside]
How do I write arbitrary SQL queries in Ruby on Rails? [more inside]
SQL: Virtual Grouping? [more inside]
How difficult is it to switch from MS Access programming to Delphi? [more inside]
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
I'm about to set up a database (pet science project) that has about 200 million records consisting of about 50 mostly-numeric fields. Is mysql up to this task? If not, what is? And since many fields are null, how can it be optimized to consume the least possible disk space? I'm worried about bloat eating up my 100 GB drive.
I need help with what I hope is a fairly simple mySQL query question. [more inside]
MySQL Hell: I've spent most of my vacation trying to figure out why MySQL has gone nuts. It's part of a Movable Type install with tons of posts, comments, and log entries, and it's always run smoothly before. The problem is that it'll bomb on random queries, seemingly every minute or two, since status queries always show uptime in tens of seconds. Repairing the larger tables and restarting the server has done nothing, and no major changes have been made. What's wrong? Is this a *nix issue, a MySQL issue, or an MT issue? And how do I go about telling the difference, or fixing any of them? [more inside]
I need to get MySQL working with Visual Studio 2005. I come from the PHP world, and while I know C, C# is a new language to me. [more inside]
I was recently hired as a work study at school to work on a project and I'm having some trouble deciding how to organize the information... [more inside]
I need to become a database-design expert ASAP! [more inside]
How do I import data into a table in an Access database in such a way that the new table will retain all of the relationships currently extant in the database? Is there a way to make a new table and overwrite the old table (say the table is called 'users') and preserve the relationships?
We're looking for a way to keep track of employees, clients, suppliers. Ideally, I'd be able to link to reference files (images, PDFs, spreadsheets) on the hard drive, print compact lists of entries, labels for contacts, and so on. [more inside]
My website is hosted by Dreamhost. It primarily consists of a Movable Type weblog that I keep for family and friends. A few others have weblogs on my MT installation. I use the Berkely DB option and MT 2.661 (for licensing reasons). Suddenly today I am unable to login. Comments result in an odd error. When I attempt to recover my password, I get an 'invalid username' error. To me, it appears the database has become corrupt. HELP! Can the database be saved? Does anyone have experience with a similar blogtastrophe?
I want to create an online document database containing text, video, audio, and image files searchable by category (Such as War > Vietnam > Napalm Footage), keywords (Such as grainy, color, etc.) and, for text, a full-text search. And I'd like to be able to define a number of other custom fields (such as Source, Date, etc.), with the ability to search as many or as few fields as I'd like. And I would also like the ability to browse by category. Anything out there that meets these standards, preferably using PHP and MySQL?
What are my options in slick, open-source database frontends? [more inside]
I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail - and contains other fields, like "notes". My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM? [more inside]
Is there any program that runs natively on OS X that would allow me to work with a Microsoft Access database? Or am I doomed to run SoftPC? [more inside]
The FEC is extremely useful in figuring out who is giving money to politicians. Is there a similar database of which corporations are being awarded contracts from the government?
So, I'm writing this book, and I need some software advice for making a computerized version of my mental rolodex. (DIT) [more inside]
Can someone please help me understand how a database for a site like 43 Things (www.43things.com) works? There are users, tags for categories, user comments (for categories), and comments that can be associated with other comments. I understand that you would need a user table, a comments table, and a tags table but how do you create a schema for a site like this that works effectively? What kind of table structure is needed and how do the tables interrelate?
Routers: This may seem rather silly to some folks, but I need a little help in figuring out what my network problem is. (I tried to google around, but i am not even sure what the term is that I should be searching for) The problem is, I am hosting my own web-server and MySQL DB for development purposes, and I have a domain name that points to it. When I am outside my own network I can hit my URL just fine. But when I inside my network, it always try to go to the routers configuration page. Any ideas as how to make sure the router is forwarding the ports correctly INSIDE my network?
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
I need to create a phone number directory on CD. I could just create an alphabetical directory with anchors in html, but I would love have a search function with dynamic pages. Is there a straightforward way to do this on CD?
I'm looking for information about home prices that have recently sold. Specifically, I'd like to find some sort of database that can make it easy for me to get comparables for any given property. Even more ideally, if it could compare a resource of available properties, and flag when their comparable value is under the market, that would be fantastic. Any thoughts on this, or how I could put this together?
I'm planning on creating a web-based program allowing employees of the auditorium where I work to sign up for shifts online. What programming language and database system should I use? [more inside]
I am running in a graphics environment (pagemaker) and would like to extract the information to a database. Does anyone know of a program that can export this to a format that excel or access can use.
A two-part question on accessing scholarly library materials from abroad. [more inside]