736 posts tagged with database.
Displaying 1 through 50 of 736. Subscribe:

How should I create an awesome customizable searchable database in 2016?

Technology keeps changing and I know you guys are on top of it more than I am... so helllllpppp! We want to create a database of detailed text information, photos, videos, links, etc. (whatever I can find) that can be tagged and accessed easily when we're looking to provide a client answers on a topic. Before we compile and input it all, I want to make sure we're using the best possible resource to build it instead of just throwing it all into evernote or Excel without looking into other (possibly better, easier and more flexible) solutions. [more inside]
posted by miss lynnster on May 3, 2016 - 4 answers

rails database setup without sudo access

Can I set up a postgres db without access to root? If not, why not?
posted by city_park on Apr 3, 2016 - 3 answers

Database what?

I’d like to set up an online store of information, for a bunch of people. There would be specific fields – “Name”, “Reference Number”, “Date of Birth” etc.. There would also be specific files associated with each person – CV, photo etc.. There will only be about fifteen people, so there won’t be much data in total. Certainly no more than 100mb. [more inside]
posted by HoraceH on Mar 25, 2016 - 9 answers

MS Access SQL question

I think this should be simple, but I don't use Access very often and my brain isn't working tonight. [more inside]
posted by ctmf on Mar 22, 2016 - 14 answers

OPAC issues

What is the cause of errors in a small library OPAC? Technical services librarians and database experts, your wisdom is appreciated. [more inside]
posted by bad grammar on Mar 8, 2016 - 9 answers

You speak like a green girl / unsifted in such perilous circumstances.

I would like to create a database, using MS SQL, MySQL or SQLite. I would also really like to create some sort of user interface on top of the database so people can enter information in forms and be able to view reports where the information is sorted and filtered in various ways to make the important stuff a little more easily readable. [more inside]
posted by FiveSecondRule on Feb 11, 2016 - 13 answers

May the Salesforce be with you...

Any good Salesforce resources that get into more complex Approval Processes than the Force.com Workbook? [more inside]
posted by Caravantea on Jan 25, 2016 - 3 answers

Securing custom MySQL tables in Wordpress

I have personal tables I'm using within the Wordpress database for my own data storage and manipulation purposes. How can I protect these *most easily* from sql injections and/or whatever other evil lurks? [more inside]
posted by A Terrible Llama on Jan 8, 2016 - 5 answers

Word parts and/or rules for combining them (morphemes?)

I want to write a program to generate new, realistic-sounding and -looking words. I want to programmatically create strings like 'bik', 'clible', 'aunstic', and 'cranoak', (if these words don't already exist), and avoid strings like 'bblejkm', 'aunstrbl', and other things that don't look pronounceable. Looking for a database of word parts to feed into this program, possibly with a set of accompanying rules. English or any other language (ideally with phonetic representations). [more inside]
posted by amtho on Nov 21, 2015 - 19 answers

Help me become good at relational databases

I'm a fairly seasoned developer but not much of a relational database expert, though I know the fundamentals. I'm looking for resources to get to the next stage. [more inside]
posted by tempythethird on Oct 28, 2015 - 8 answers

Help me escape Excel hell

I need to build a database that's viewable on the web, but for internal use only, among friends. How to do this painlessly? Google spreadsheet is not exactly making it any easier. [more inside]
posted by pleasebekind on Sep 10, 2015 - 9 answers

Wordpress DB growing too large?

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]
posted by humboldt32 on Jul 21, 2015 - 13 answers

I want to build a digital catalog of my art collection.

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]
posted by Devils Rancher on Jul 18, 2015 - 7 answers

Starting a SQL Career at 32?

I am interested in a career in SQL databases. Is this worth it and how would I get started on it? [more inside]
posted by anonymous on Jun 17, 2015 - 14 answers

Is it difficult to integrate your website with your inventory?

I'm looking for some examples of e-Commerce / ERP inventory integration... [more inside]
posted by doomtop on Apr 17, 2015 - 9 answers

Specific training for senior management about the value of databases?

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?
posted by VeniceGlass on Mar 23, 2015 - 6 answers

Best way to put a small library database online?

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?
posted by stinker on Mar 9, 2015 - 8 answers

Problem with Access filters

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]
posted by sabotagerabbit on Mar 4, 2015 - 1 answer

Help Me Resurrect a Dormant Website

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]
posted by CollectiveMind on Mar 3, 2015 - 15 answers

Help Me Set Up a Database for Document Offers

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]
posted by hmmnathan on Feb 13, 2015 - 2 answers

What can I use my new personal library database for?

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]
posted by jefficator on Jan 21, 2015 - 5 answers

Help me hack my OPAC

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]
posted by Biblio on Jan 18, 2015 - 6 answers

How do I build database to organize my learning goals and lesson plans?

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]
posted by BrashTech on Jan 15, 2015 - 9 answers

Easy open-source database building software?

I'm looking for an easy-to-use, robust, free, cross-platform open source database building tool. [more inside]
posted by kristi on Jan 13, 2015 - 11 answers

Is there a database for the date when a piece of music was *recorded*?

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?
posted by jeremias on Jan 3, 2015 - 2 answers

Golf GPS Database

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]
posted by solmyjuice on Dec 16, 2014 - 2 answers

How best to present catalogue of data online?

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]
posted by Joeruckus on Dec 10, 2014 - 2 answers

Calculated field on LibreOffice database form?

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]
posted by tommasz on Nov 27, 2014 - 4 answers

Another "data management & research database for dummies" question

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]
posted by ladybird on Nov 27, 2014 - 5 answers

Should I go to school to be a SysAdmin?

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]
posted by anonymous on Nov 14, 2014 - 12 answers

Freely Accessible Etymology Database? Or tools to help create one?

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]
posted by symbioid on Oct 30, 2014 - 6 answers

Data Base Administrators: Please lend a hand to a new assistant DBA

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]
posted by snsranch on Oct 21, 2014 - 4 answers

Photo management?

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]
posted by showbiz_liz on Oct 13, 2014 - 14 answers

How to determine the quantity of physical pressings for an album?

I would like to know how many pressings for any given recording were produced (with ease). [more inside]
posted by swoopstake on Oct 4, 2014 - 3 answers

A list of food pluralizations?

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]
posted by bethnull on Oct 1, 2014 - 7 answers

Tracking reimbursements for employees

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]
posted by thefang on Sep 25, 2014 - 3 answers

Non-Developer Question: Drupal

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]
posted by Lescha on Aug 22, 2014 - 10 answers

Best resources for learning SQL for database newbies

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]
posted by JimBJ9 on Aug 20, 2014 - 15 answers

Technical skills for new position?

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]
posted by heavyp08 on Jul 31, 2014 - 0 answers

Help me get a Microsoft DB certification

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]
posted by Mrs. Pterodactyl on Jul 15, 2014 - 3 answers

My MySQL Kung Fu is not strong...

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
posted by keep it tight on Jun 24, 2014 - 9 answers

How to catalogue a collection and plan a rare book sale

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]
posted by peacay on Jun 9, 2014 - 7 answers

Need to create locally-hosted, searchable database of vendors--help!

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]
posted by erinsaurus on Apr 22, 2014 - 8 answers

Simple database options for non-profit

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]
posted by sabotagerabbit on Apr 22, 2014 - 20 answers

Collecting data via iPhone - regularly, quickly, securely, non-web-based

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]
posted by borborygmi on Apr 21, 2014 - 4 answers

What are the phases in website infrastructure development?

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?
posted by philosophygeek on Mar 13, 2014 - 4 answers

PHPBB Auto User Pruning - how do I undo it?

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.
posted by fake on Mar 3, 2014 - 5 answers

Tool for making pretty data models?

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]
posted by kamelhoecker on Feb 28, 2014 - 4 answers

How do I create a multivalue column from delimited text in Access 2010?

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]
posted by tsh on Feb 24, 2014 - 6 answers

SQL Trace: How to aggregate data by stored procedure without ClearTrace

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]
posted by UrbanEye on Feb 23, 2014 - 1 answer

Page: 1 2 3 4 5 6 7 8 ... 15