LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-24-2016, 06:58 AM   #1
BruceV
LQ Newbie
 
Registered: Jan 2016
Posts: 13

Rep: Reputation: Disabled
Looking for a fairly small relational database for Ubuntu


Single user, including SQL queries. Doesn't need industrial strength, and table sizes under 1000 records of text-only data. Can anyone suggest something, everything I'm finding on the web is way too big for my requirements. TIA
 
Old 02-24-2016, 07:16 AM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 20,638

Rep: Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650Reputation: 3650
Check out the following.
SQLite http://www.sqlite.org/index.html
Firebird http://www.firebirdsql.org/en/start/
 
1 members found this post helpful.
Old 02-24-2016, 07:56 AM   #3
BW-userx
LQ Guru
 
Registered: Sep 2013
Location: Somewhere in my head.
Distribution: Slackware (current), FreeBSD, Win10, It varies
Posts: 9,952

Rep: Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147Reputation: 2147
did you try typing
Quote:
small relational database for Ubuntu
in google, then clicking on 'I'm feeling lucky', first?
 
Old 02-24-2016, 08:30 AM   #4
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1062Reputation: 1062Reputation: 1062Reputation: 1062Reputation: 1062Reputation: 1062Reputation: 1062Reputation: 1062
SQLite may do the job for you.

However, there are two DBMS' that may just do a better job over the long term -- and, yeah, they're industrial strength but like a lot of full-feature things you only need to use what you want to until you need to expand here or there and you don't bump up against the limit switches of limited features and are forced to switch to something else. It's one of those it's there if you need it but isn't going to bother you if you don't; off you can take, on you can't put sort of thing.

I'm talking about MySQL/MariaDB or PostgreSQL. They're free, you may already have one or both installed and, if you already speak SQL they're fairly easy to use without a lot of fooling around. You create a data base, define table(s) schema(s), load your stuff, query your stuff, life is good.

Personally, I lean a little more toward PostgreSQL although I have a number of data bases running in both MySQL/MariaDB and PostgreSQL. Easy to administer, easy to use, don't take up much resources (memory or processor) -- I have two data base servers, one of each, that sit in a closet and mumble to themselves until called on to do some actual work.

There are any number of applications available that require one or the other and you may find yourself growing into one or more of those; be nice to have the infrastructure available.

Hope this helps some.
 
  


Reply

Tags
database, ubuntu 11.04


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Relational interface/wrapper around SQL database? hydraMax Linux - Server 3 05-21-2011 02:24 PM
What is the best free relational database for ubuntu? tommytea Linux - General 10 09-24-2009 07:56 PM
LXer: Is the relational database now a commodity? LXer Syndicated Linux News 1 04-16-2007 07:32 PM
a good book for relational database design? kpachopoulos General 3 11-20-2004 09:14 AM
Relational Database on Linux Ronw Linux - Software 10 11-11-2003 03:40 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:28 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration