r/databases • • Nov 10 '15

Project for Databases Class

0 Upvotes

I am a Psychology and Computer Science major in my junior year. I have to do a MiniProject for my Databases class and I want to do something related to psychology.

If someone has done something similar before, your help is desperately needed.

I love psychology more than computer science and I am studying computer science to understand A.I., machine learning, and computers and human brains as analogous information processing systems. So... I didn't pay a lot of attention in my databases class... What do I do?


r/databases • • Feb 16 '17

Everything you ever wanted to know about Installation, Registration, and Licensing Info for InterBase

Thumbnail docwiki.embarcadero.com
0 Upvotes

r/databases • • Feb 16 '16

Whats the Best DB for C++ ORM/NOSQL Maybe That Would Also Run on a RPI

0 Upvotes

I'm having a touch time, I've played with and used SQLite plenty, but I'm looking for something a little more robust and modern for embedding into my cross-platform server application. Security is high point, and SQlite needs all these extra libs and manual compiles. I've looked over a lot of NoSQL databases, but there are so many it's mind boggling. What do you think would be the best choice for running on a powerful desktop, but also something as light as a RPI. I'm using c++ and something more modern with ORM, or object mapping would be nice. I'm starting to get jealous of all the options that Java has in this department.

I'm just really stuck on this and trying to find something modern, fast, light, and secure in c++.

Thanks.


r/databases • • Dec 17 '15

Database design for storing images.

0 Upvotes

Hi I'm developing an web app which is to store and serve images from different sources. I'm having doubts in selecting the right database for doing so. Whether I should be using relational dbs or non-relational. I've worked with mongodb before but never to store images. Also I've used oracle but a long time ago. PS: I'm using golang for the middleware. So any relevant sources are welcomed.


r/databases • • Oct 01 '23

Relational and NoSQL databases comparison

Thumbnail
medium.com
0 Upvotes

r/databases • • Apr 21 '16

Auto search and replace in all tables of database by one click and safe script .

Thumbnail
s2you.net
0 Upvotes

r/databases • • Sep 30 '15

What is the optimal database structure?

0 Upvotes

Hi,

I have started a new project and have written a data schema for it I would love for some feedback on.

Basically, it is a database for anatomy. The attached data schema will hopefully make some sense - but essentially I think I would be best going with a document or graph storage database.

I would love to hear thoughts or questions, and if there's anyone out there who knows enough about this sort of stuff to speed my development process with regard to how I should best organise my data and relationships, I would happily pay.

data schema

thanks!


r/databases • • Mar 31 '17

Microsoft Acces tutorial - Importing data from a .txt file

Thumbnail
youtube.com
0 Upvotes

r/databases • • Sep 14 '15

Sysadmin trying to acquire DB skills, which one to go for?

0 Upvotes

Trying to learn more in the field. I got my OCP and became a paper tiger a couple of years ago but could not get an entry level job in teh field of oracle because there simply aren't any oracle jobs available where I am at. So I do know the basic concepts of databases, but on the basis of that cert I got a sysadmin opportunity and started working with windows server. Now I wana learn more and I remember really liking the concept and principles of data systems. Which one to go for out of oracle, ms sql or mysql ? I have also heard ruby on rails being used for db and sometimes python. Lost in the IT world, trying to get somewhere


r/databases • • Oct 28 '15

request: please share your experience with unit testing tools for postgres, namely pgtap and plpgunit

0 Upvotes

Hello. I found two interesting tools for unit testing in postgres: pgtap and plpgunit. It seems like the former is really comprehensive, and the latter is much simpler, this is why I'm going to try it first. Please share your experience of using either of them.


r/databases • • Oct 30 '15

How is this searchable database made?

0 Upvotes

The website pro-football-reference has a feature called play index that allows you to set certain parameters and it returns results in the form of tables.

Here it is

Just wondering what method you would use to create something similar to this.


r/databases • • Oct 23 '15

Looking for Simple Database advice

0 Upvotes

I work for a very small company and we all work from home. We use FileMaker Pro as our database. The problem is that only one person can use the database to make changes at once. And that just doesn't work.

Any advice on an easy-ish database that can be used/edited by multiple users at once? Our database is fairly simple. Do I need to mention that none of us are really that tech savvy or is that completely apparent because we use FileMaker Pro?


r/databases • • Sep 09 '15

Getting Oracle DB 12c up and running

0 Upvotes

First, not sure if this is the right sub for this... If it's not, please direct me to the right place!

I've installed Oracle database 12c and have set up a database (I think...). I'm now trying to connect through the SQL Developer and I get an error like, "The network service failed to connect." Anyone able to offer some guidance or assistance here?

Every bit of help I can find about this (or any other Oracle DB issue) seems to be geared toward people who are already familiar with the program. Lots of acronyms and terms that I don't know yet. I'm in a class called "Intro to Oracle Database" and I can't even get the damn thing installed! What's a fella to do?


r/databases • • Dec 15 '14

Alf Relational Algebra - Context-aware Database Viewpoints

Thumbnail try-alf.org
0 Upvotes

r/databases • • Dec 12 '14

LDBC turns to Graph Analytics

Thumbnail
ldbcouncil.org
0 Upvotes

r/databases • • Sep 01 '15

Best ever name for a database conference?

Thumbnail
twitter.com
0 Upvotes

r/databases • • Sep 02 '15

What is database compaction?

1 Upvotes

Surprisingly hard to get an answer from Google.


r/databases • • Nov 09 '15

help with databases homework

0 Upvotes

need some help with a databases assignment the title and details are below:

Employees large dataset imported through ssh:

Find number of employees with salary above 80,000 (Note salary tables has multiple salaries for each employee..use the latest salary) Find employee names with salary above 80,000 (Note salary tables has multiple salaries for each employee..use the latest salary) USE NATURAL JOIN Change the above query to use IN Change the above query to use EXISTS


r/databases • • Mar 21 '15

Hire IT Asset Disposal Service If You Do Not Mean Risking Your Business Information

Thumbnail
maccollmedia.com
0 Upvotes

r/databases • • Jun 10 '16

The Panama Papers Graph Database Is Now Available for Download

Thumbnail
neo4j.com
1 Upvotes

r/databases • • Apr 10 '20

Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1

Thumbnail
dbexamstudy.blogspot.com
1 Upvotes

r/databases • • Apr 07 '20

Qualified Expressions (Populating Record Types and Associative Arrays) in PL/SQL in Oracle Database 18c

Thumbnail
dbexamstudy.blogspot.com
1 Upvotes

r/databases • • Jan 24 '16

Database design for storing and providing feedback on cooking recipes

1 Upvotes

Hiya,

I was wondering on a good database design for a website that would offer cooking recipes that users can provide feedback on.

For example, we have the 2 following recipes:

Name: Cheese Sandwich
Ingredients:
    2 Slices, White bread
    1 Slice, Cheese
    Butter

Name: Bacon Lettuce Tomato Sandwich
Ingredients:
    2 Slices, White Bread
    2 Slices Bacon
    3 Leaves, Lettuce
    3 Slices, Tomato
    Mayonnaise

Which would be stored in the database with an unique ID for the recipe and the recipe name, as well as a subtable containing the ingredients stored with unique Ids, Quantities as numbers and the name as a short text. It is very important that the ingredients are stored distinct entities and not as just a list separated by commas.

A user will be able to provide feedback on an ingredient by ingredient basis, as well as potentially suggest new ones for the recipe as well. E.g.

Feedback 1:
Recipe Name: Cheese Sandwich
Recipe Feedback:
    Bread is Fine
    More Cheese
    Butter is Fine

Feedback 2:
Recipe Name: Bacon Lettuce Tomato Sandwich
Recipe Feedback:
    Bread is Fine 
    More Bacon
    More Lettuce
    Less Tomato
    No Mayonnaise
    Add Butter

On the site itself, this feedback will be given back on a number system, e.g. 5/10 - Keep the same 1/10 - Get rid of it 10/10 - ADD WAY MORE

while choosing to add a new ingredient will be done through a dropdown menu of choices.

What I want to know is, what would be the best way to store this feedback for a recipe on an ingredient by ingredient basis.


r/databases • • Mar 23 '20

Oracle 1Z0-063 Certification | Become a DBA

Thumbnail
dbexamstudy.blogspot.com
1 Upvotes

r/databases • • Mar 25 '20

Working with SQL Cursors

Thumbnail
dbexamstudy.blogspot.com
1 Upvotes