I have a wordpress site running WooCommerce. I'm getting a couple dozen notices from Webfaction each day saying that a mysql query has taken longer than a minute and has been killed. [more inside]
Software suggestions for the Mac? I have simple needs. I want a catalog number, date of origin, artist name, and a photograph of each piece. Sorting, filtering and searchability required. [more inside]
I am interested in a career in SQL databases. Is this worth it and how would I get started on it? [more inside]
I'm looking for some examples of e-Commerce / ERP inventory integration... [more inside]
We have a group of practitioners in our company who rely on Excel way too much, both for data that's too large and data that's too complex for it. At the same time we roll out SQL training to the practitioners, we wanted to explain the value and capabilities of database work to senior management so we could set the right tone. Any suggestions for online training, a set of articles or other resources that don't dive into SQL coding, but for which the attendees will still get the right message?
I am responsible for a library of about 1200 books, which I've cataloged in a database. I'd like to put the database on our website so that readers can search for a book without having to visit the library. I have experience with Python and to a lesser extent, MySQL. What is the best way to create a searchable database online using these tools or something else that's relatively easy to learn?
I've built a simple database in Access, with a form function for the people who are inputting data. But the forms are acting very strange and I'm not sure how to fix it. [more inside]
I hired a developer to build a retail website for me in 2011. He did it, but I moved and the MyPhP account he established for me expired. At the time, knowing how life situations can change, I asked him for a copy of the code, which he gave me although he protested because he though I would allow him to host it on his site. We also had a falling out about quality which later, made me glad I had asked for a copy of the code. I know nothing about coding. [more inside]
I'd like to set up a web-based system that will allow me to enter document records and make them available to multiple groups of logged-in users on a set schedule so they can select documents they are interested in. After all is said and done, I want to be able to access a sorted list of the documents so I can get them where they need to go easily. [more inside]
I've just finished adding all of my owned books into a personal database app. Now what can I do with that information? [more inside]
I am looking for a way to generate lists of library books from my library's catalog and have them display on a different webpage. [more inside]
I need to organize my lesson plans and learning goals. I have a list of learning goals. I have a list of "activities," each of which addresses one or more learning goals. I want to be able to switch easily between listing activities chronologically and grouping the activities by learning goals. What miracle software should I be using? [more inside]
I'm looking for an easy-to-use, robust, free, cross-platform open source database building tool. [more inside]
For example, Night Fever by the Bee Gees was recorded in April 1977 and released in 1978. Is there a website that lists (and allows you to search for) recording dates for other musicians?
Databases of standard golf course information (address, scorecards, etc) are available from providers such as US Golf Data. However I am wondering how companies are able to provide GPS maps of the courses (as can be seen in apps like GolfNow, MobiTee, and GolfShot). These all appear to be separate companies, did they really each do the mapping themselves (isn't this a huge amount of labor?) or is there a known licensor of GPS golf maps? [more inside]
We've surveyed 80+ organisations, to build something like a database of their answers to questions that we know our members want to know. But how best to share the results? You guys know this stuff and have good ideas about it: please share! [more inside]
Since Bento for the Mac is no longer supported, I converted a Bento database I use for keeping track of beer brewing to a LibreOffice database. The only thing that didn't work was a calculated field I had that used the Original Gravity and Final Gravity fields to come up with the ABV. How can I do this in LibreOffice? [more inside]
I'm undertaking a research project in which I'm evaluating several different organizations based on specific yet qualitative criteria, e.g. "promotes outreach", "reports on progress", etc. I need to able to capture the information and then display the results in some sort of meaningful way so that it can be incorporated into a report. [more inside]
I can't find work in my field and am increasingly desperate. I need to find some kind of path to employment and have been looking at my options in my local community college. Can you all help me make sense of IT as a career option? [more inside]
I have an idea for a project that would require the ability to search a dictionary of words and find the year of it's known introduction (as close as possible). I am aware of etymology-online (love that site), but since, as far as I'm aware, it's just a site, and the compilers don't have a publicly accessible database, I was wondering if anybody knows of any site that actually WOULD have a freely available database (either query via an API through the web, or downloadable to self-host)? [more inside]
Quick question about using MS ACCESS. Can you direct me to an online tutorial that quickly illustrates how to create or edit/manipulate and an existing report from excel data? I do have an existing report that can probably be modified, but I've never used access before. [more inside]
I need a photo management system that allows me to tag and search photos, but I'd rather it NOT be web-based. I don't really know what to look for. [more inside]
I would like to know how many pressings for any given recording were produced (with ease). [more inside]
I'm involved with a project that involves a database of cooking ingredients. We have a great huge list of relevant nouns, so that's fine, but we're running into trouble with the differences in pluralizations of words. [more inside]
I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy. [more inside]
Do we need another database in addition to the CMS to accomplish this? Can you help a non-developer understand. Can you help me explain it properly? [more inside]
I am making a transition from an Excel-based reporting analyst to a database-oriented role in which SQL will be the primary necessary skill. I have next to zero database experience. I'm looking for resources that would be effective at teaching me what I need to learn. More within… [more inside]
I have had experience with Salesforce and Microsoft CRM, I am now entering a position managing Oracle CRM what do I need to know? [more inside]
I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
I need a script for a MySQL table. The table has multiple fields but one ENDDATE will be populated as a Date/time value. When I am 90 days from that date, I need to update the field STATUS with the value of "email" Work your magic hive! thanks
I'm looking for general advice about how to bring a garage collection of many hundreds of valuable books to market. Part of this process will likely involve software choices. [more inside]
I maintain for my company a spreadsheet that contains a list of vendors and their associated information: address, contact(s), service area(s), service(s), website, and so on. It's becoming rather unwieldy as a vendor might have up to 5 different services, 2 addresses, 3 contacts each with their own email and phone number, etc. The information's all there, it's just very annoying to use. I had the idea of creating an "intranet" type website that staff could use to filter vendors by name, service area, service type, and so on, with the results displaying in an easy-to-read format (easier than a mile-long Excel sheet, anyway). I am open to solutions like Wordpress and Joomla, just not sure how best to implement. Any ideas? [more inside]
My organization is currently using a very bloated Excel spreadsheet to track a bunch of data about our clients. I'd like to build us a really simple database with a nice form input to make it easier for staff to enter all of the information we need to track, but I'm not sure what my options are for software. [more inside]
We're going to have some folks filling out the same simple form on a regular basis. Is there an app-based solution where they can enter the data and upload it securely to a central repository at the end of the day? A web solution may have been easier, but we're worried connectivity might be an issue during parts of the day. We want users to tap an app and be able to fill out a bunch of forms, then upload them all (securely) at the end of the day. A simple, elegant, fast interface would be a real plus. [more inside]
I am curious about the process of scaling a website from a small, shared hosting site all the way up to "one of the biggest 10 sites on the Internet" scale. I've heard terms like "dedicated hosting," "sharding the database" etc., but I'm sure there's a lot more that I haven't heard about. What changes on the backend through this process, and is there a typical order that those changes occur?
I run a forum where we discuss open source book scanning technology. Many users visit only occasionally. In a recent update, PHPBB enabled a feature called "Auto User Pruning", and it deleted users who had not logged in for 24 months. Two Thousand Users were deleted. It did not delete their posts, and their account names are still attached to their posts. Please help me restore these users from my database backups or via some other method.
I'm looking for a simple way to textually describe data models, and can then produce something visual (an SVG, a PNG, etc.) An analogy would be how "Markdown" is a markup language that allows you to write something in plaintext, that can be converted to HTML. [more inside]
I want to take a comma delimited list of values e.g. "bacon, sausages, eggs" stored as a single text field and store these as selected values in a single multi-value lookup field. [more inside]
I'm trying to put together an automated SQL server monitoring and diagnostics solution, including SQL Trace data. I want to be able to group RPC:Completed event data by stored procedure. Unfortunately, the formatting and parameter values in each specific call make this kind of aggregation impossible. For instance "Select * From qryLinksByNewsletterID Where NewsletterID=19" and "Select * From qryLinksByNewsletterID Where NewsletterID=234" would be considered different remote procedure calls. ClearTrace does that for you. But, ClearTrace can't run as an automated SQL job. Some kind of script would be ideal, and someone by the name of Andrew Zanevsky made a post describing one back in 2004, but the link to the actual script is dead. I could create my own with Regexes and such, but it seems like someone out there must have done it already. [more inside]
Hello Mefites! I'm looking for a reliable online service to pull population numbers by zip code, and while I know there are tons out there, I need one that isn't just plugging in one zip code at a time. Ideally, I'd like to be able to just download a database list of zip codes and their corresponding populations for the country, or state by state, to a CSV or XML file. Does this exist? The "reliable, up to date (as much as possible) source" part is important, as this data will be used as part of a franchise sale package. Thank you in advance!
I have a database that contains many thousands of time-stamped events each of which has a geographic location. What visualization projects could I use to explore this data? [more inside]
I'm looking for a cloud-based database solution with a web front end. The idea is that you could upload an Excel spreadsheet or CSV file (or Access export), and then customize a front end query that will bring back results. [more inside]
After a crazy Kickstarter adventure, I suddenly find myself with ~65 products to create, 2000 customers to send them to, and loads of information (names, email addresses, shipping details, order selections, order fulfillment status, funds donated) from 4 different sources (Kickstarter surveys, Surveymonkey.com, paypal.com, private emails). I need some way to keep track of all of it, so that I can easily find and export information (Who ordered product X? Who ordered product Y and hasn't yet had that order fulfilled), easily change entries (Customer B: Can I switch from product X to Y?) and easily add entries (New customer C). What's my best bet?
Web developers: My university research lab wants to drag our website out of 1998 to a more easy-to-maintain and attractive design. We're tending towards using Wordpress, mostly for its large install base and plugin market. However our website won't follow the typical blog page/post format that Wordpress seems to support by default - it's more like a library with inter-related content types. Something like this is beautiful but probably out of our budget. Those with Wordpress experience, what default features should we try to use? Or is there a plugin / theme that does what we want already? [more inside]
How do you keep track of your friend's babies/children? I'm looking for some kind of system to remind me of names, ages, and birthdates for the small humans that my large human friends have brought into the world. [more inside]
Hi, my company has an online photo database I normally login with Chrome to view. I can't see any of the image preview thumbnails today for some reason and it's making me crazy. I've tried some different things and I'm out of ideas. Maybe you can help? [more inside]
Is there such a thing as a Document-Oriented Database for Non-Programmers? I've been searching the web for several days and I'm quite confused so I thought to post here. [more inside]
Working on an old version of Filemaker Pro (7) in Windows, I created an alias (shortcut) of the main database, opened it and lost everything. Help? [more inside]
I've got a kid enjoying high school theater, and I'd like to help. My skills do NOT run to hammers or sewing machines, but I can work Chrome / Google Docs / databases like a pro. The costume designer is wishing for a way to track student measurements, costume notes, and pictures / photos in some sort of online / app format for going to fabric stores and keeping track of sewing progress. She's coveting an iPad mini to use with it, so I guess an app would be fine. I'd prefer a Chrome / Google Doc option, because I'm cheap. LOVE to hear from costume designers / wardrobe coordinators who've figured this out. Extra credit points for people who know how to create a costume database for completed costumes after the shows.
What can I do to become a database administrator or developer if I'm starting basically from zero? [more inside]