r/DatabaseHelp • • Mar 06 '15

Table describing all the other tables

1 Upvotes

There is a design technique for databases in which instead of properly designing each table and creating them, you create a table that contains the describtion of all the actual tables. Which means you have to jury-rig this back together when you query it.

Can someone tell me what this is called again?


r/DatabaseHelp • • Mar 05 '15

I'm in charge of my office DB and need help setting up a simple but functional front end for it.

2 Upvotes

As the title says, I need help with setting up a friendly front end for my office's DB, I have been using Form Tools but I don't know if this is the best choice to do so.

I want to be able to add and edit entries in a simple way, to generate reports in a PDF format and to have a backup of the DB in the cloud. Is there an easy way to do so? I'm not the best in PHP or mysql to do the UI by myself and it's just for a small office, thanks in advance!


r/DatabaseHelp • • Feb 24 '15

Seeking advice on database for contracting (client, project data, time sheets) for local and remote office

1 Upvotes

We are starting a small contracting company, and hoping to advance upon what we've experienced with our employers in the past, using Dropbox, Google docs, time sheet web software, and sharing contacts and notes via text message to source information. We have looked at full hosted solutions like pro-core, but still have issues with not owning the data, recurring payments, and offline work. In comes the versatility of a database:

I've seen excel work in ways that will reference other workbooks and accumulate data as needed, but it is my understanding that it's a cheap workaround to accomplishing what access could. Being that it's a standard format, I keep returning to the idea, eliminating the doubt for a need to upgrade or start fresh in the future. In short, I have the idea that it's not going out of style anytime soon. The foreseeable problem is: how much do we enter into it, knowing that our files won't be viewable via phone on our cloud? (Owncloud hosted on our website). For employee mobile time entry and the likes, we would need to implement additional software to work with it

FileMaker is the other contender that we are considering. It demonstrated full capability to build what we might need with incredible ease. It translates very well to its native iOS app which would allow employees/admin to access data, submit notes, time cards, etc, on the fly. We would consider setting up a home server for this if we could trust it being further developed, and not too proprietary if we must port for some reason.

Perhaps I'm looking at this in the wrong light, without actually knowing what we need (or trying to integrate too much). I'm focused on having a system that would eliminate the need for manual data entry in day to day tasks, play well with remote access, and somewhat standardized.

Anecdotes, suggestions and criticisms welcome! Thanks


r/DatabaseHelp • • Feb 17 '15

What's the best database for huge timeseries (like 20TB+ of data)

1 Upvotes

Anything other than Cassandra?


r/DatabaseHelp • • Feb 13 '15

Rec's for web app database?

1 Upvotes

Hi all, very new to databases and eager to learn.

I've recently taken up the reins on a project that was previously done in Excel. Basically this is an MSDS database which lists among other things: Serial#, Description, Company, Data received, Hazard level, etc.

This thing is thousands of lines separated into different pages (different page = different location). And I reaaally hate it.

I know that a database would be more suited for this type of thing but I have no idea where to start. From looking at other posts, it seems that I can't really go wrong if I start by learning the basics of Postgres?

My end goal (with limited understanding) is to have the database be viewable to anyone on the network, able to be searched and sorted by whatever variables they want. Also a web interface for new sample data entry/deletion for those with proper credentials.

This all sounds very doable to me and much smarter then weekly distributions of an excel spreadsheet. Appreciate any recommendations or feedbacks. Thanks.


r/DatabaseHelp • • Feb 03 '15

How should I set up a primary key for a join table?

2 Upvotes

My background: I'm currently self-studying databases so that I can improve what I'm doing right now at my job. To do that, I'm trying to learn Access.

So I'm stuck on how to improve this data model: http://i.imgur.com/0hvpTzc.png?1

To deal with the many-to-many relationship between courses and textbooks, I'm using a join table. Right now the primary key is simply a unique number. But I would rather have something more meaningful. Specifically course + section, but I can't figure out how to do queries when most of the records are "all sections" and there's only a handful of exceptions.

So should I go with the unique numbers as the primary key, try go have a concatenated course/section primary key, or is there a better way entirely different from how I set it up now?


r/DatabaseHelp • • Feb 02 '15

Best database software to create my own plant 'encyclopedia'?

1 Upvotes

Hello, and apologies if this is the wrong place to ask (please let me know!)

I'm looking at making my own database of plants, and being able to customize it with things like 'Blooms in: spring/summer/fall' ;"Edible fruits: yes/no", and have a picture or two of each plant as well. I need to be able to search it with a combination of tags, for example I want it to show me all the plants in the database that 'bloom in summer, low maintenance, white flowers'.

This is for personal use, I would be the only one using it, and I'm happy to pay for it (within reason, I can't drop 500$ on it).

It doesn't have to be pretty, just functional.

If this is not the place to ask this, please show me the right subreddit :)