Notices


Reply
Thread Tools
Posts: 37 | Thanked: 0 times | Joined on Mar 2008 @ MA
#1
I have installed mySQL but have never used it before. I was hoping to use it as a database program on my N810 for my business.

Here are a few of my questions regarding mySQL:

1. Shouldn't it be listed in the program list?...I cannot find it there.

2. Could someone breifly explain how mySQL works?

3. Am I wrong in thinking this could be used as an alternative to glom?

4. Do I need an account setup on an mySQL server or can I use it locally? If that makes any sense.

Any help would be appreciated.
 
briand's Avatar
Posts: 566 | Thanked: 145 times | Joined on Feb 2008 @ Tallahassee, FL
#2
1. no, you'd run the MySQL server from the command line (or have it start up automatically)

2. it's a database. it allows the computerized storage and retrieval of information.

3. i don't know what "glom" is, so i cannot compare/contrast the two

4. yes, you'll need an account to log in. both server and client can reside on the same machine, or on different machines.

It sounds like you were looking for some sort of application to do your 'business tasks' with -- think of a database as an 'engine' in a car: with just an engine, you cannot drive anywhere - you need the rest of the car (the application). Then, you may need tools (knowledge of programming, SQL, etc.) to either build the car (application) or to keep it tuned up.

A database, by itself, will not do anything except take up some space on your computer. It sounds like you probably want some sort of business application that uses MySQL (or any of several alternative) databases for storage/retrieval... and specifying, designing, building, debugging (and so on) of a database application is well beyond the scope of this forum.
 
Posts: 111 | Thanked: 31 times | Joined on May 2007
#3
Hi there.

I wonder if what you are looking for may be this:

https://garage.maemo.org/projects/sqlite3sg


It is a simple GUI to access sqlite3 database.
 
Posts: 37 | Thanked: 0 times | Joined on Mar 2008 @ MA
#4
Originally Posted by briand View Post
1. no, you'd run the MySQL server from the command line (or have it start up automatically)

2. it's a database. it allows the computerized storage and retrieval of information.

3. i don't know what "glom" is, so i cannot compare/contrast the two

4. yes, you'll need an account to log in. both server and client can reside on the same machine, or on different machines.

It sounds like you were looking for some sort of application to do your 'business tasks' with -- think of a database as an 'engine' in a car: with just an engine, you cannot drive anywhere - you need the rest of the car (the application). Then, you may need tools (knowledge of programming, SQL, etc.) to either build the car (application) or to keep it tuned up.

A database, by itself, will not do anything except take up some space on your computer. It sounds like you probably want some sort of business application that uses MySQL (or any of several alternative) databases for storage/retrieval... and specifying, designing, building, debugging (and so on) of a database application is well beyond the scope of this forum.
Brian, thanks for you reply. Very good assimilation of what a database is. I guess I am looking for a simple database without having to pay for an account. I have set up a few of my own databases in Windows XP MS Acess and I am a computer desktop technician by trade but I was just curious about mySQL to see if it may be right for me. I think it would work for me but I am still a little unclear of the details. Does mySQL cost to get an account?

Glom is a database that I had a problem installing but would be willing to bet that it is exactly what I am looking for. If only I could install it and make it work on my N810 to find out. I was having trouble finding all the files needed to install it.
 
Posts: 37 | Thanked: 0 times | Joined on Mar 2008 @ MA
#5
Originally Posted by pamadio View Post
Hi there.

I wonder if what you are looking for may be this:

https://garage.maemo.org/projects/sqlite3sg


It is a simple GUI to access sqlite3 database.
Hmmmm... I will give it a try, thanks.
 
briand's Avatar
Posts: 566 | Thanked: 145 times | Joined on Feb 2008 @ Tallahassee, FL
#6
Ricky --

No, you wouldn't need to pay to get an account. Once the database software is installed, you can create databases, namespaces, tables, and user accounts to your heart's desire. I would heartily recommend the O'Reilly books on MySQL if you're not familiar with SQL syntax.
 
Posts: 37 | Thanked: 0 times | Joined on Mar 2008 @ MA
#7
Originally Posted by pamadio View Post
Hi there.

I wonder if what you are looking for may be this:

https://garage.maemo.org/projects/sqlite3sg


It is a simple GUI to access sqlite3 database.
Incidentally Pamadio, I am a newbie to Linux and X-Term but could you show me how to extract the tarball in X-Term? I think I previously downloaded a decompression utility...I think it was bzip2 or something. Am I even close?
 
Posts: 37 | Thanked: 0 times | Joined on Mar 2008 @ MA
#8
Originally Posted by briand View Post
Ricky --

No, you wouldn't need to pay to get an account. Once the database software is installed, you can create databases, namespaces, tables, and user accounts to your heart's desire. I would heartily recommend the O'Reilly books on MySQL if you're not familiar with SQL syntax.
Great now the only problem I am having is after the App manager said mySQL was successfully installed, I do not have any app to open. Am I missing a file or something? I installed the mysqldatabase file. Is there another file I need or a certain repository?
 
briand's Avatar
Posts: 566 | Thanked: 145 times | Joined on Feb 2008 @ Tallahassee, FL
#9
if the App manager said it was installed, it's there.

it is not, however a GUI application, so there's nothing to be seen on the menu. how to start it up, and what to do once it's started, is covered in detail in the book(s) I recommended earlier...
 
Posts: 37 | Thanked: 0 times | Joined on Mar 2008 @ MA
#10
Originally Posted by briand View Post
if the App manager said it was installed, it's there.

it is not, however a GUI application, so there's nothing to be seen on the menu. how to start it up, and what to do once it's started, is covered in detail in the book(s) I recommended earlier...
Excellent! Thanks for the info and all your help. I will definitely read your recommended book(s).
 
Reply

Thread Tools

 
Forum Jump


All times are GMT. The time now is 20:24.