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 -
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.
me restore these users from my database backups or via some other method.
posted by fake
on Mar 3, 2014 -
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 -
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 -
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.
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 -
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!
posted by assasinatdbeauty
on Feb 19, 2014 -
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]
posted by odinsdream
on Feb 12, 2014 -
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]
posted by adverb
on Feb 3, 2014 -
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?
posted by sdis
on Jan 26, 2014 -
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]
posted by anthill
on Jan 22, 2014 -
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]
posted by sparklemotion
on Jan 4, 2014 -
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]
posted by rabu
on Dec 6, 2013 -
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]
posted by dylan_k
on Dec 3, 2013 -
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]
posted by StopMakingSense
on Dec 3, 2013 -
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.
posted by contemplativenapper
on Nov 24, 2013 -
What can I do to become a database administrator or developer if I'm starting basically from zero? [more inside]
posted by anonymous
on Oct 28, 2013 -
After an unexpected departmental shuffling last week, I was laid off from my database admin job of four years. My DB knowledge is largely self-taught, and pertains mostly to a number of niche applications that have little direct use to your average employer. I need to learn how to translate my skills into those that are actually in demand in today's job market and I need to do it quickly. Details below the fold. [more inside]
posted by a box and a stick and a string and a bear
on Oct 10, 2013 -
Is there a database of insect scientific names and their taxonomy available somewhere for free? For example Streptocerus speciosus - Family: Lucanidae - Order: Coleoptera. I'm hoping to avoid downloading wikipedia and crawling through it.
posted by Memo
on Oct 2, 2013 -
Is FileMaker Pro right for this? If so, please help me understand the costs/benefits of setting FMP up for certain project-specific functions. [more inside]
posted by sakahane
on Sep 29, 2013 -
I'm working on a book to Microsoft Word. Every time that I go to do a figure (which gets added in the actual page layout process), I have to repeat the figure call out three times.
Once in the text, once in production directives, and once in the caption. Some chapters have as many as 60 figures. Meaning if I want to rearrange things, that life becomes very painful, and fraught with mistakes.
It seems like word has the ability to put in to track of this, but not triplicate. Hopefully, someone reading this will have expertise to tell me how this is done. I'm using word 2011 on Mac.
posted by filmgeek
on Sep 14, 2013 -
We have four departments and each has their own way of managing their student lists, I'd like to find one solution to rule them all. [more inside]
posted by monocultured
on Aug 28, 2013 -
What's a good way to keep track of information about images of paintings I've downloaded (artist, title, year, museum, and so on)? [more inside]
posted by kristi
on Aug 20, 2013 -
I'm looking for a good online database app thingy that would let 50 teachers and 200 students easily and quickly input sentences in two languages *as well as pictures* and be easily searchable by all participants in the future. Any ideas? [more inside]
posted by sdis
on Aug 19, 2013 -
I'm looking for a publication ready recipe/photos to buy and share on a site for a food brand I'm working with. Unfortunately time rules out working with our own team and recipes. I've found snapandstir.com
which is perfect but pricey - is there anything else out there? A large archive would be ideal!
posted by teststrip
on Aug 7, 2013 -
This is a simple thing to ask, but how do I capture input data through a form on mobile phones / tablets / laptop in a database? More details in... [more inside]
posted by jassi
on Aug 2, 2013 -
I remember coming across a game that represented rows in a database as stars in a galaxy, and gave the player visual feedback for the queries they entered. What was that called?
posted by phrontist
on Aug 1, 2013 -
I work for a small nonprofit. Part of what we do is collect and share first-person, nonfictional stories. I've been asked to find a better way to organize and keep these stories. [more inside]
posted by cowboy_sally
on Jul 18, 2013 -
We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira
on Jul 17, 2013 -
I'm a fan of certain authors, critics, and academics whose taste and sensibilities are similar to my own. I'm currently looking for a way to search for books based on the blurbs or editiorial reviews about them from authors that I admire and trust.
Example: 1. Philip Roth's recent assessment of Jonathan Franken's writing was prominently blazed on the latter's most recent book.
2. Warren Buffett has referred to Dale Carnegie's book "How to Win Friends and Influence People" as one of the few books that changed his life.
3. Charlie Munger, Buffett's partner in arms, referred to John Cialdini's book on influence as one having a permanent influence on his thinking on that topic.
4. Harold Bloom, the critic, has impressive recommendations on Henri Cole's newest volume of verse.
Is there a database that I can use to help me scour who's been recommending what and how.
posted by RapcityinBlue
on Jul 12, 2013 -
My friend is looking for a resource that will identify by states buyer contact information for large retail companies.
She is a "key account representative" for a national company with a presence in half of the states in the US, and wants to find information regarding buyers for large national retailers.
Years ago there was publication called "Contact Influential" that supplied this sort of info. I'm marginally familiar with Hoover's, and believe it is along these lines. Does the hive have any other suggestions?
posted by ecollie
on Jul 10, 2013 -
So I've been using Evernote for a while now to organize research, projects I'm working on, collecting articles, recipes, etc. I've used Backpack in the past to organize projects and plan trips. I'm curious about possibly upcoming/newer solutions that are in this similar vein that might be more robust, have better search capabilities, etc for collecting and organizing all the information in your digital life.
What do you guys use? What comes after Evernote? What is the precursor to "Computer.. pull up all recipes that involve chicken, cheese, and cilantro." or "Computer.. all articles on Ruby on Rails relating to PostgreSQL databases." or even... "Computer.. all guitar tabs I've collected by Modest Mouse" (Who knows, maybe I just have to wait for Evernote to advance) [more inside]
posted by walka
on Jun 21, 2013 -
Are there ways to "cross" or "join" data results in Google Analytics? Just as a for instance, I have a list of Referrals and a list of audience Location demographics. Is there a way to join those two lists, so that I know where site referrals are visiting from? (Generally, are there resources which list "pro tips" for getting the most out of Analytics?)
posted by Blazecock Pileon
on Jun 18, 2013 -
is there a database of riddles searchable by answer, such as "post office" or "police officer" or "a zoo"?
posted by parmanparman
on Jun 11, 2013 -
Tomorrow morning I'm meeting with someone to talk about implementing a local scheduling/database application. Most everything I know about the project suggests it's something I could do in my sleep. Thing is, I desperately need the money, I don't know how much to "bid," and I have a long history of undervaluing my work. How much should I ask for? [more inside]
posted by JHarris
on Jun 10, 2013 -
I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob
on Jun 9, 2013 -
I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
posted by nosila
on May 30, 2013 -
I'm developing a proposal to overhaul the way my company thinks about communication. One of the major components that would allow this to work is the creation of what is essentially a "wire service". What software already exists to do this? (lots of details inside) [more inside]
posted by dadici
on May 15, 2013 -
If I were to set up my own online book store, is there a provider that I can subscribe that will provide me with images of sample pages of books? [more inside]
posted by applesurf
on May 7, 2013 -
I'm looking for a simple, cloud based database to keep track of production contacts (Cast and Crew) and location information for a medium sized production company. The database should be able to be used simultaneously from computers worldwide and feature tagging and photo uploading. Also, we should be able to change the basic fields when needed. Do you know of a good service/tool for this use? [more inside]
posted by sdsparks
on May 3, 2013 -
My oldest cousin is job-seeking and solicited my help to find an app or website that will help her track and manage the versions of resumes and cover letters she sends out to employers. The best advice seems to be that you do a customized resume (and obliviously a custom cover letter) for each job applied for - so how to track those?
She tells me that it's important to be able to match the resume version to the job ad when the recruiter does make contact (I guess so you can get the various little white lies straight!). And also to know what version you sent to the same company previously when they have new or a multitude of vacancies.
I can't find anything out there.
Any advice please? Any apps or websites that do this?
What do other job seekers do to manage this problem? (spreadsheet? or something better?)
posted by Xhris
on May 1, 2013 -
I am a beginner in information technology, and I need to learn HTML5.
For me to start learning HTML5, I need to know what languages/codes that I should know to start working in HTML5.
I know HTML5 are used for webpages, mobile, games, and others.
For example, I knew that I should be familiar with CSS3
So what are other basic information and skills needed to learn before starting with HTML5?
posted by omaralarifi
on Apr 25, 2013 -
I tried to search a database at the place I volunteer with REGEX, but it didn't work. The database interface has some built-in options to search, so I have been messing with those trying to figure out what conventions it will allow. Can you tell me what this is? [more inside]
posted by Nattie
on Apr 23, 2013 -
I am putting together a small contact database in LibreOffice Base for a friend. I am trying to figure out how to do input validation on data like phone numbers, postal state abbreviations, and ZIP codes. It must be possible to set this up, but I can't find any helpful documentation. Can the hive mind fill the gap?
posted by philosophygeek
on Apr 23, 2013 -
I'm compiling an Excel spreadsheet full of personal data. What my employer would like to do is add that information to their existing website and make it searchable and filterable, so that researchers can filter out all guys who were born in year X or town Y, search for all guys named Cohen, etc. [more inside]
posted by Palindromedary
on Apr 16, 2013 -
Is there a joke wiki or humor wiki database? I'm looking for a professional level no-nonsense jokes database. [more inside]
posted by Muirwylde
on Apr 1, 2013 -
As part of my dissertation, I want to look at the research output of a small research center. I'd like to do some bibliometric analysis but am not sure where to start. Where can I look for tools and techniques? In particular, I'm interested in tools that help me wrangle their Endnote database into something easy to analyse. [more inside]
posted by col_pogo
on Mar 28, 2013 -
Please recommend easy online solutions to transition our "Student Directory" from a printed booklet to an online applications that parents can log-in to. Bonus points for parents being able to update their information (but with moderation/approval), or add notes (such as "lives with Dad on weekends") This seems like something that would exist as an out-of-box application. Additional details inside. [more inside]
posted by dadici
on Mar 11, 2013 -
My customers will sign up for weekly, bi-weekly or monthly shipments of a product. After I've processed their payment, what are some online customer database solutions for managing my current customers and generating things like shipping labels and order forms so that each week I can pack my boxes full of product and ship them? [more inside]
posted by jrholt
on Mar 10, 2013 -
We're doing a project that provides info for business owners on who they should talk to for every city and county in California for local permits and regs. Aside from calling each and every one to get their updated info, is there any OTHER way to do it? Isn't there someone who does this for local government the way that other services do for specific industries? We're willing to pay for it, we just don't know WHO to pay. Thoughts?
posted by rileyray3000
on Mar 8, 2013 -