I'm starting a commercial web site. I doubt it will make money for a long time, and maybe it won't make any at all, but I'd like to give it a try for the hell of it. It will be a rating site, similar to epinions and I want to store the info in a database; mysql wants $600 a year for licensing which is simply too much. Is there another suitable DBMS that would work with PHP or Perl? If there are no free database packages out there, how might I get around the need for one?
Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR. [more inside]
I need to capture data from an HTML form into a database, then use that data to populate a template. The template, however, is of a certificate of accomplishment, and must be in the form of a printable PDF. What's a good software/middleware/whateverware package to automatically take the data and inject it into a PDF like this? More inside. [more inside]
My wife is an art history professor who uses a mac, and has a large collection of scans of images. She needs an orderly way to organize the scans for sensible, easy retrieval. [more inside]
Dealing with no-records cases in Access [more inside]
Are there any comprehensive sites which catalog the original sources of audio later sampled in songs? [more inside]
Where can I find a citation database for OS X (and am I using the right term)? [more inside]
I am in charge of a custom installation of a web calendar application (ORS) that is feeling the strain of too many users and the consequences of some unusual policies. I need some advice on how to get better performance out of this application. [more inside]
I'm working on a website for my band, and I would like to have a section on the main page which lists news items. I don't want to have to edit the html file every time I want to add an update though. I'd like it to run from a database or something, so can I set something up to display the 5 most recent database entries on my website? [more inside]
Infuriating Microsoft Access questionfilter: I have a database that I inherited in which queries are set up to pull records which have dates of birth between certain dates. It works right in one database but is not working right in another, for a very particular reason.. [more inside]
How can I print multiple MS Access Snapshot files (.SNP) in Windows 2000/XP at the same time? [more inside]
Could someone recommend a Database Software package that is less complicated than Microsoft Access. I just need a package for entering customers' addresses and phone numbers and have six or seven fields that can be sort. As you can see, a very simple database; yet one that is effective. Thank you!
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]