Results 1 to 10 of 10

Thread: Anyone know of any great database programs for Knoppix?

  1. #1
    Junior Member registered user
    Join Date
    Apr 2004
    Location
    Philly PA
    Posts
    11

    Anyone know of any great database programs for Knoppix?

    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

  2. #2
    Senior Member registered user
    Join Date
    Feb 2003
    Location
    Germany
    Posts
    1,159

    Re: Anyone know of any great database programs for Knoppix?

    mysql. There are various frontends to it, but OpenOffice has one and is already included on the Knoppix CD, as is mysql itself.

  3. #3
    Senior Member registered user
    Join Date
    Mar 2004
    Location
    Berlin
    Posts
    436
    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.

  4. #4
    Junior Member
    Join Date
    May 2004
    Posts
    4

    mysql via openoffice

    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

  5. #5
    Senior Member registered user
    Join Date
    Nov 2002
    Location
    Auckland, New Zealand
    Posts
    818
    Quote Originally Posted by user unknown
    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.
    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.

    There is a really good gui for MySQL and it's called DBDesigner4

  6. #6
    Senior Member registered user
    Join Date
    Mar 2004
    Location
    Berlin
    Posts
    436
    eadz
    from the mySql homepage:
    What new features are you most looking forward to in MySQL?
    Subqueries Prepared statements Stored Procedures
    ... Views ...
    Well - it looks as if the comming mySql 5.0 release will have stored procedures.

    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.

  7. #7
    Senior Member registered user
    Join Date
    Nov 2002
    Location
    Auckland, New Zealand
    Posts
    818
    Quote Originally Posted by user unknown
    eadz
    from the mySql homepage:
    What new features are you most looking forward to in MySQL?
    Subqueries Prepared statements Stored Procedures
    ... Views ...
    Well - it looks as if the comming mySql 5.0 release will have stored procedures.

    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.
    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.

    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.

  8. #8
    Senior Member registered user
    Join Date
    Mar 2004
    Location
    Berlin
    Posts
    436
    Are you making jokes here?

    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)
    First: here you may see, that the recommended production release is 4.0, and 5.0 is for 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?

  9. #9
    Senior Member registered user
    Join Date
    Jul 2003
    Posts
    692
    Geeks talking smack. Sheesh!

  10. #10
    Senior Member
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    157
    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.

Similar Threads

  1. Driver database update in Knoppix
    By chris_Xnest in forum General Support
    Replies: 1
    Last Post: 10-20-2004, 01:56 PM
  2. Driver database update in Knoppix
    By chris_Xnest in forum Customising & Remastering
    Replies: 1
    Last Post: 10-19-2004, 02:37 PM
  3. Database in knoppix
    By wari in forum Ideas
    Replies: 0
    Last Post: 05-20-2004, 03:57 AM
  4. knoppix app that will open database field data?
    By duah55 in forum General Support
    Replies: 0
    Last Post: 01-05-2004, 08:20 PM
  5. Knoppix Hardware Database
    By aay in forum The Lounge
    Replies: 0
    Last Post: 12-13-2002, 06:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


ASUS - PRIME B450M-A II (Socket AM4) AMD B450 microATX DDR4 Motherboard - Black picture

ASUS - PRIME B450M-A II (Socket AM4) AMD B450 microATX DDR4 Motherboard - Black

$69.99



Asus Prime H310M-A R2.0 Intel LGA 1151 DDR4 Desktop Motherboard picture

Asus Prime H310M-A R2.0 Intel LGA 1151 DDR4 Desktop Motherboard

$54.99



GIGABYTE GA-AB350M-D3H Motherboard Socket AM4 DDR4 +AMD Ryzen 3 2200G I/O Shield picture

GIGABYTE GA-AB350M-D3H Motherboard Socket AM4 DDR4 +AMD Ryzen 3 2200G I/O Shield

$79.99



Gigabyte B560 DS3H AC Intel LGA 1200 DDR4 ATX Motherboard picture

Gigabyte B560 DS3H AC Intel LGA 1200 DDR4 ATX Motherboard

$69.95



Gigabyte B560 DS3H AC Intel B560 LGA 1200 ATX Desktop Motherboard A picture

Gigabyte B560 DS3H AC Intel B560 LGA 1200 ATX Desktop Motherboard A

$79.99



ASUS H81M-C/CSM Motherboard LGA 1150 DDR3 RAM USB 3.0 mATX; Tested picture

ASUS H81M-C/CSM Motherboard LGA 1150 DDR3 RAM USB 3.0 mATX; Tested

$29.99



ASRock H370M-HDV LGA1151/ Intel H370/ DDR4/ SATA3&USB3.2/ Micro ATX Motherboard picture

ASRock H370M-HDV LGA1151/ Intel H370/ DDR4/ SATA3&USB3.2/ Micro ATX Motherboard

$51.95



ASRock Z170M-ITX/AC LGA 1151 Intel Motherboard | Fast Ship, US Seller picture

ASRock Z170M-ITX/AC LGA 1151 Intel Motherboard | Fast Ship, US Seller

$59.97



Gigabyte M-ATX motherboard with Intel Core i3 8100 CPU and 8GB DDR4 RAM picture

Gigabyte M-ATX motherboard with Intel Core i3 8100 CPU and 8GB DDR4 RAM

$79.00



ASUS ROG Strix X670E-F AMD X670E DDR5 Socket AM5 Wi-Fi Gaming Motherboard picture

ASUS ROG Strix X670E-F AMD X670E DDR5 Socket AM5 Wi-Fi Gaming Motherboard

$215.00