2011 LinuxQuestions.org Members Choice AwardsThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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"
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.
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
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
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.
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
LOL; phpMyAdmin, wouldn't even remotely meet my database needs.
I really hope that's a joke
Quote:
Originally Posted by chrisretusn
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
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
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
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).
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
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.
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
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
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
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
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.
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
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.
@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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.