LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > 2011 LinuxQuestions.org Members Choice Awards
User Name
Password
2011 LinuxQuestions.org Members Choice Awards This forum is for the 2011 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2011. This is your chance to be heard! Voting ends on February 9th.


Notices

View Poll Results: Database of the Year
MySQL 163 49.70%
PostgreSQL 83 25.30%
Percona 3 0.91%
Drizzle 1 0.30%
MariaDB 11 3.35%
Firebird 19 5.79%
sqlite 38 11.59%
Oracle 7 2.13%
DB2 3 0.91%
EnterpriseDB 0 0%
Voters: 328. You may not vote on this poll

Reply
 
Search this Thread
Old 01-16-2012, 04:45 AM   #31
Bazzaah
Member
 
Registered: Mar 2007
Distribution: Slackware64-current, Slackware64 14
Posts: 324

Rep: Reputation: 49

MySQL on my sites - but I've not tried any others, just not needed to!
 
Old 01-16-2012, 05:01 AM   #32
corp769
Guru
 
Registered: Apr 2005
Posts: 5,807

Rep: Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996
Well I use postgresql and sqlite for small projects, etc, and mysql on my server upstairs for my site and bigger projects.
 
Old 01-16-2012, 06:15 AM   #33
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 470

Rep: Reputation: Disabled
Quote:
Originally Posted by LauMars View Post
LibreOffice Base and Calc are not databases.

The former is a front end to a database (so you'd be hooking up to something like MySQL) and the latter is just a spreadsheet so functions no more like a database than a vi is a desktop publishing package.
I will let you off nicely....

I said "LibreOffice Base and Calc cover my database needs"

That is all....
 
Old 01-16-2012, 06:23 AM   #34
corp769
Guru
 
Registered: Apr 2005
Posts: 5,807

Rep: Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996
Quote:
Originally Posted by chrisretusn View Post
I will let you off nicely....

I said "LibreOffice Base and Calc cover my database needs"

That is all....
Do you import all of your data into libreoffice, or do you actually create your databases in libreoffice?
 
Old 01-16-2012, 08:01 AM   #35
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 470

Rep: Reputation: Disabled
Quote:
Originally Posted by corp769 View Post
Do you import all of your data into libreoffice, or do you actually create your databases in libreoffice?
I create the tables, queries, forms and reports first and then import the data, A lot of the imported data comes from spreadsheets I manually added data to, but want to do more that what I could with Calc.

Last edited by chrisretusn; 01-16-2012 at 08:25 AM.
 
Old 01-17-2012, 04:10 AM   #36
LauMars
Member
 
Registered: Sep 2007
Location: /root/
Distribution: Arch, CentOS, Debian, FreeBSD, Slackware, Solaris, SuSE (Open & SLES)
Posts: 115

Rep: Reputation: 25
Quote:
Originally Posted by chrisretusn View Post
I will let you off nicely....

I said "LibreOffice Base and Calc cover my database needs"

That is all....
I got that, but my point was:

1/ you're still using a database with LibreOffice. Like with Access, Base just hides the db engine. So saying LibreOffice covers your db needs is akin to saying phpMyAdmin covers your db needs; or any other db front end for that matter.

2/ and that Calc is out of scope because if you needed a database, then you wouldn't use a spreadsheet. Clearly you're not inexperienced on databases as you've stated you've used them before - so the only reason you'd have for not wanting to use a db would be because you don't need a db. Thus it cannot cover your db needs
 
Old 01-17-2012, 07:58 AM   #37
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 470

Rep: Reputation: Disabled
Quote:
Originally Posted by LauMars View Post
I got that, but my point was:

1/ you're still using a database with LibreOffice. Like with Access, Base just hides the db engine. So saying LibreOffice covers your db needs is akin to saying phpMyAdmin covers your db needs; or any other db front end for that matter.
First you tell me that LibreOffice Base is not a database
Quote:
Originally Posted by LauMars View Post
LibreOffice Base and Calc are not databases.
Now you are telling me I am still using a database;
LOL; phpMyAdmin, wouldn't even remotely meet my database needs.

Quote:
2/ and that Calc is out of scope because if you needed a database, then you wouldn't use a spreadsheet. Clearly you're not inexperienced on databases as you've stated you've used them before - so the only reason you'd have for not wanting to use a db would be because you don't need a db. Thus it cannot cover your db needs
Do you know what a database is?

A database is an organized collection of data that can be manipulated to produce a desired result.

I use a Calc spreadsheet to do exactly that. I use Base tables, queries, forms and reports to exactly that. Yes I could use MySQL to that too but why, when Base and Calc meet my database needs.

You are quite correct in that I am "not inexperienced on databases". I designed my first database back in 1982.
 
Old 01-17-2012, 12:12 PM   #38
ps_sabu
Member
 
Registered: Nov 2006
Location: Kerala, South India
Distribution: Ubuntu 12.10, Ultimate Edition 3.5, OZ Unity 3.0 Black Opal
Posts: 117

Rep: Reputation: 15
Talking

Hi

MySQL for me
 
Old 01-18-2012, 04:43 AM   #39
LauMars
Member
 
Registered: Sep 2007
Location: /root/
Distribution: Arch, CentOS, Debian, FreeBSD, Slackware, Solaris, SuSE (Open & SLES)
Posts: 115

Rep: Reputation: 25
Quote:
Originally Posted by chrisretusn View Post
First you tell me that LibreOffice Base is not a database

Now you are telling me I am still using a database;
Yes, that's right. Base is not a database - Base is a front end. You're still using a database when you use Base but the program itself is not a DBMS.

Quote:
Originally Posted by chrisretusn View Post
LOL; phpMyAdmin, wouldn't even remotely meet my database needs.
I really hope that's a joke

Quote:
Originally Posted by chrisretusn View Post
Do you know what a database is?
Yes, like yourself I've used them for years - both professionally as an Oracle DBA and recreationally for personal projects. So I've had exposure of everything from flat text files through to enterprise solutions.

Which is why I'm fully aware that there is a difference between the data, the management system and dumb front ends that many people use to interact with the DBMS.

phpMyAdmin and Base are equivalent of VNC. So your point is like arguing that a VNC / RDP sessions to a remote computer are actually running locally (eg in a virtual machine) just because the remote software and data is there locally to view - completely ignoring the fact that it's just images being streamed via TCP/IP from remote server.

Or another example is arguing that Firefox is a webserver because you can see web content on it when it's actually just displaying the content that a remote server as collated and served.

Base and phpMyAdmin are nothing more than platforms to inspect your data via the DBMS - they're not databases (in any sense of the term) themselves.

Quote:
Originally Posted by chrisretusn View Post
A database is an organized collection of data that can be manipulated to produce a desired result.
Yes, technically a database is the data itself. Which would mean that your data held on Calc is the database and not Calc itself. So either way, you're still wrong.

Plus given this poll is about SQL-based DBMS, i'd have thought you'd apply the same context to the definition as LQ have. If you want to argue that spreadsheets are your favourite No-SQL methods for managing databases, then please do so in the No-SQL poll rather than here.

Quote:
Originally Posted by chrisretusn View Post
I use a Calc spreadsheet to do exactly that. I use Base tables, queries, forms and reports to exactly that. Yes I could use MySQL to that too but why, when Base and Calc meet my database needs.
Again, Base is just a front end. It's not actually doing any of what you described aside forwarding your SQL instructions to an underlying RDBMS (eg Base can hook into MySQL).

Also, it's ironic that you state that MySQL could meet your needs (if you were inclined) yet phpMyAdmin cannot when the database management "part" of phpMyAdmin is MySQL. This is exactly what I was on about when I keep making the distinction between a front end to a database and the database itself. And, with the greatest of respect, I think this is where you are getting yourself confused when referring to Base as a database.

Quote:
Originally Posted by chrisretusn View Post
You are quite correct in that I am "not inexperienced on databases". I designed my first database back in 1982.
Impressive stuff, but as stated above you need to be aware of the distinction between a database and the interface (which in many cases are just "dumb" tools).

Last edited by LauMars; 01-18-2012 at 04:48 AM.
 
Old 01-19-2012, 08:43 AM   #40
xev
LQ Newbie
 
Registered: Aug 2011
Posts: 18

Rep: Reputation: Disabled
Just dealing with MySQL
 
Old 01-20-2012, 04:54 AM   #41
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 470

Rep: Reputation: Disabled
Quote:
Originally Posted by LauMars View Post
I really hope that's a joke
That "phpMyAdmin, wouldn't even remotely meet my database needs.". Nope, not a joke. It does not come close to meeting my needs. It a management tool.

Quote:
Yes, technically a database is the data itself. Which would mean that your data held on Calc is the database and not Calc itself. So either way, you're still wrong.
This is silly. That applies to Sybase, MySQL, Oracle as well. I really tried to not call you wrong and I will take the high road on that.

Quote:
Plus given this poll is about SQL-based DBMS, i'd have thought you'd apply the same context to the definition as LQ have. If you want to argue that spreadsheets are your favourite No-SQL methods for managing databases, then please do so in the No-SQL poll rather than here.
You started this. I simply made a statement, let me quote it again.
Quote:
Originally Posted by chrisretusn View Post
Surprised that my favorite, Sybase is not in the poll. Used it back in my working days. Ah those were the days...

I actually use none of the above now. LibreOffice Base and Calc cover my database needs now-a-days.
You felt obligated to try and educate me in the error of my ways. There is no error in my ways or my understanding of databases and the systems that manage them.

You seem to take some sort of exception that Base and Calc cover my database needs. They do! That is that.

Quote:
Also, it's ironic that you state that MySQL could meet your needs (if you were inclined) yet phpMyAdmin cannot when the database management "part" of phpMyAdmin is MySQL. This is exactly what I was on about when I keep making the distinction between a front end to a database and the database itself. And, with the greatest of respect, I think this is where you are getting yourself confused when referring to Base as a database.
Well that statement tells me a lot. There is only one confused soul here, it is not me.
 
Old 01-20-2012, 05:51 AM   #42
LauMars
Member
 
Registered: Sep 2007
Location: /root/
Distribution: Arch, CentOS, Debian, FreeBSD, Slackware, Solaris, SuSE (Open & SLES)
Posts: 115

Rep: Reputation: 25
Quote:
Originally Posted by chrisretusn View Post
That "phpMyAdmin, wouldn't even remotely meet my database needs.". Nope, not a joke. It does not come close to meeting my needs. It a management tool.
So you can tell the different then, yet you repeatedly mistake Base as being something other than the same.

In fact their own website verifies what Ive been saying the whole time: "Base is a full-featured desktop database front end"
So now are you going to argue that the developers of Base don't even know what they're talking about?

Quote:
Originally Posted by chrisretusn View Post
This is silly. That applies to Sybase, MySQL, Oracle as well.
Exactly my point. You argued that definition and thus I'm demonstrating the implications of your statement. If you want to refer to the collection of data then the application is completely out of scope. If you want to refer to the database management system, then Base and Calc are out of scope as neither are DBMSs. So either way, Calc and Base are out of scope.

Quote:
Originally Posted by chrisretusn View Post
I really tried to not call you wrong and I will take the high road on that.
I'm not wrong though and have given examples to back up why. If you can prove otherwise then I'd gratefully receive it.

Quote:
Originally Posted by chrisretusn View Post
You started this. I simply made a statement, let me quote it again.

You felt obligated to try and educate me in the error of my ways. There is no error in my ways or my understanding of databases and the systems that manage them.
"You started it" <-- how very mature

I was simply stating that Calc and Base are out of scope as neither are DBMS (as proven with the links above), let alone SQL-based ones (which is the entire point of this poll). This isn't a discussion about any and every application we use for data organisation and correlation. It's specific to SQL-driven DBMS. Nothing more.

Quote:
Originally Posted by chrisretusn View Post
Well that statement tells me a lot. There is only one confused soul here, it is not me.
Very constructive. Now care to explain which part of that quote you disagreed with rather than posting a generalised retort? Thus far you haven't given one piece of evidence to back up your claims where as I've given a number of examples as well as references to the developers own product page.

Also I'm sorry you feel attacked - I'm really not out to troll. You made a statement that was factually inaccurate and I (stupidly) corrected you. Granted I was being a touch pedantic, however if and when I make the same errors I appreciate the same response. The unfortunate thing is we're half a dozen posts along and you've still not substantiated your claims. So rather than turning this into a slagging match (which I really cannot be bothered with), please reference your points.

Last edited by LauMars; 01-20-2012 at 05:54 AM.
 
Old 01-21-2012, 11:38 PM   #43
chrisretusn
Member
 
Registered: Dec 2005
Location: Philippines
Distribution: Slackware
Posts: 470

Rep: Reputation: Disabled
@LauMars, This is my last post on this subject. That link you so gratefully provided can also serve as my reference. Let me finish your quote for you.
Quote:
Originally Posted by Base Features LibreOffice
Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users, for all kinds of usages such as:

keeping track of collections of objects;
maintaining customer information databases;
maintaining student grade and curriculum databases;
storing survey information and experimentation data;
storing population and census data;
producing monthly financial reports in companies and organizations
managing audit, quality assurance and production data.
Now lets go back to my first post you seem to have a problem with:
Quote:
Originally Posted by chrisretusn View Post
Surprised that my favorite, Sybase is not in the poll. Used it back in my working days. Ah those were the days...

I actually use none of the above now. LibreOffice Base and Calc cover my database needs now-a-days.
Have a nice database day.
 
Old 01-22-2012, 05:15 AM   #44
LauMars
Member
 
Registered: Sep 2007
Location: /root/
Distribution: Arch, CentOS, Debian, FreeBSD, Slackware, Solaris, SuSE (Open & SLES)
Posts: 115

Rep: Reputation: 25
Quote:
Originally Posted by chrisretusn View Post
@LauMars, This is my last post on this subject. That link you so gratefully provided can also serve as my reference. Let me finish your quote for you.
Well yeah, I never said that you couldn't do any of that stuff in there. I just said it's a front end to a RDBMS rather than a R/DBMS itself. Even with the full length of the quote you added, it clearly enforces my point. (In fact it categorically states that).

I really don't know why you can't grasp this concept.
 
Old 02-01-2012, 10:36 AM   #45
indienick
Senior Member
 
Registered: Dec 2005
Location: London, ON, Canada
Distribution: Arch, Ubuntu, Slackware, OpenBSD, FreeBSD
Posts: 1,853

Rep: Reputation: 65
PostgreSQL, when using an RDBMS.
 
  


Reply


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
Database of the Year jeremy 2009 LinuxQuestions.org Members Choice Awards 39 03-06-2010 04:16 AM
Database of the Year jeremy 2007 LinuxQuestions.org Members Choice Awards 78 05-04-2009 04:36 AM
Database of the Year jeremy 2008 LinuxQuestions.org Members Choice Awards 60 02-22-2009 09:21 AM
Database of the Year jeremy 2006 LinuxQuestions.org Members Choice Awards 57 02-20-2007 11:42 AM


All times are GMT -5. The time now is 10:21 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration