mysql. There are various frontends to it, but OpenOffice has one and is already included on the Knoppix CD, as is mysql itself.
I just made the long overdue change from Windows to Knoppix and all I can say is I'll never use Windows again! I've been playing with various software, but still haven't found a database I like, so if anyone knows of any good programs for knoppix... PLEASE let me know. I currently have my entire client database in ACT on a *rolls eyes* Windows box and I can't wait to do away with ACT!
Thanks,
Michael Harazin
mysql. There are various frontends to it, but OpenOffice has one and is already included on the Knoppix CD, as is mysql itself.
if you go for webhacks, mySql might be ok.
For a more professional task take postgresql. It's much more advanced in implementing the standards (mySql don't knows subqueries - and I use it since years.
There is even a free edition of oracle9 (perhaps today oracle10) - which I downloaded but I'm hanging in the installation-process. And it's a 500 MB tarball to download
There is pure java-implemented database which stays in memory: hsqldb, but if you have lots of data you should have lots of ram. A jre is included in my knoppix, so the more small hsqldb (a few MBs) is everything you need.
I would very much appreciate direction on how to open mysql with OpenOffice. I have tried to open mysql directly without success despite forum searches, asking in Knoppix chatroom, google searches, and texts such as "Kiss the Blue Screen of Death Goodbye" by Marcel Gagne. Obviously I'm missing something obvious and obviously Im still a newbie despite using Knoppix for over a year.
I know I'm rambling a little but I wanted to show that I did some looking before posting for help.
Steven Schwimmer
steven2099@aol.com
MySQL supports subqueries and other jazz as well. I was at a MySQL talk where they had someone who works for mysql talking about it, and basicly I don't think I'll ever used postgres. It doesn't have anywhere near the number of users that MySQL has and so it's hard for it to remain as bug-free.Originally Posted by user unknown
There is a really good gui for MySQL and it's called DBDesigner4
eadz
from the mySql homepage:
Well - it looks as if the comming mySql 5.0 release will have stored procedures.What new features are you most looking forward to in MySQL?
Subqueries Prepared statements Stored Procedures
... Views ...
When you tell mySql has more users, where did you get that information?
Can you prove it?
It might be more easy to have less bugs, if you have less features. But since postgresql had views and subqueries when I first used it in 1996, bugs might have been removed since years. Feel free to visit the bug-page of postgresql.
Since the additional features of postgres are essential to complex databases and experienced users, there might be a different level of experience, as well for developers as for users.
steven2099
I just made a postgresql connection to openOffice/calc.
F4 shall give you a database view.
Read the Help:Search:JDBC; database to get additional info and feel free to ask again afterwards, more specific if possible.
MySQL 5 has no known bugs. MySQL don't release anything unless it can pass it's tests which include testing test cases for ALL known bugs, and speed tests. If it has a known bug or is not as fast as a previous version then it doesn't get released. So in saying that, MySQL 5 is stable enough to use.Originally Posted by user unknown
MySQL has more users I was told by someone who works at MySQL.. well it's downloaded 20,000 times a day. I'm not sure what the dowloads for postgresql are, but I'm inclined to believe MySQL.
Are you making jokes here?
First: here you may see, that the recommended production release is 4.0, and 5.0 is for testing new features.MySQL database server & standard clients:
* MySQL 4.0 -- Production release (recommended)
* MySQL 4.1 -- Alpha release (use this for new development)
* MySQL 5.0 -- Development tree (use this for previewing and testing new features)
Source http://dev.mysql.com/downloads/
Note the dot-com in the name.
Have a look at this page, before telling there is no bug:
http://bugs.mysql.com/bugstats.php
Of course, every complex software has bugs, and there is nothing wrong with that.
But it's wrong to tell it has no known bug.
Perhaps it had no known bug when released, but of course bugs are found when used by many people on different systems with different ...
MySql is a fine, usable, and quite stable amateur database, used by millions of webhackers.
And postgres is a seldom used, professional database. Stable and usable, as well.
Are you somehow involved in mySql?
Geeks talking smack. Sheesh!
I am still favouring Windows, I have tried SQLyog and in my opinopn it is the best and most intuitive which I believe only have windows installations. But MySQL is creating better interfaces (GUIs) for its own product. MySQL Control Center and MySQL Administrator are the names and locations.
1U Supermicro Server 10 Bay 2x Intel Xeon 3.3Ghz 8C 128GB RAM 480GB SSD 2x 10GBE
$297.00
HP ProLiant Xeon E3-1220L V2 MicroServer Gen8 2.30 GHz 16 GB RAM NO DRIVES
$199.99
HPE ProLiant MicroServer Gen8 Intel Xeon E3-1265L 16GB ECC PCIe x16 4x1TB HDD
$249.99
HP ProLiant HSTNS-5151 Micro Server 8GB RAM No Drives/Key/Caddies *READ*
$94.99
HPE ProLiant MicroServer Gen10 Plus v2 Ultra Micro Tower Server - 1 x Intel Xeon
$846.19
SuperMicro Server 505-2 Intel Atom 2.4GHz 8GB RAM SYS-5018A-FTN4 1U Rackmount
$202.49
Microsel Server Tower Supermicro X10SAE E3-1275 V3 @3.5GHz 16GB 509849-001
$149.99
Supermicro 5018A-FTN4 Rack Server - Black
$125.00
SUPERMICRO CSE-512 AMD Opteron Processor 6128, 32GB DDR3 RAM NO HDD
$90.00
1U 20" Short Depth Server Firewall PFSense X11SSH-F Xeon 3.5Ghz 32GB RAM NVME
$247.00