Database software

Database software

[David Sexton]

Hi, I am looking for database software that will let me create, 
edit, and view mysql 
databases.
Any out there that work especially well with speakup?

Re: Database software

[Willem van der Walt]

I normally use straight sql commands from mysql, but you might look at 
phpmyadmin, a web-based front-end for mysql administration.
I have not played with it in years, so by now it might have lots of 
inaccessible javascript.
HTH, Willem

On Fri, 23 Oct 2009, David Sexton wrote:

> Hi, I am looking for database software that will let me create, 
> edit, and view mysql 
> databases.
> Any out there that work especially well with speakup?
> _______________________________________________
> Speakup mailing list
> Speakup@braille.uwo.ca
> http://speech.braille.uwo.ca/mailman/listinfo/speakup
> 

-- 
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard. 
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.

Re: Database software

[Chris Brannon]

David Sexton wrote:
> Hi, I am looking for database software that will let me create, 
> edit, and view mysql 
> databases.
> Any out there that work especially well with speakup?

The good old mysql command-line client works beautifully.  In fact, every
Unix RDBMS that I've ever used has a command-line client.
They're fairly straightforward.

Edbrowse can also do some database operations, as long as your RDBMS supports
the ODBC interface.  MySQL does,
but I believe that the ODBC wrapper is packaged separately.
I haven't used the database functions of edbrowse too much, so I can't
give many details.

While we're on the subject of databases, you might also want to have a look
at PostgreSQL, the other popular free RDBMS.
I prefer it to MySQL for several reasons.  Please do investigate both, if
you haven't already done so.

-- Chris

Re: Database software

[Liz Hare]

Hi Chris,

You said:
 > RDBMS.
> I prefer it to MySQL for several reasons.  Please do investigate both, if
> you haven't already done so.


Would you mind telling us what those are? I might be about to take on a 
big database project myself.

Liz

Re: Database software

[Chris Brannon]

> > I prefer it to MySQL for several reasons.  Please do investigate both, if
> > you haven't already done so.
> 
> Would you mind telling us what those are? I might be about to take on a 
> big database project myself.

Hi Liz,

I had to check the documentation,
because it's been almost half a decade since I've seriously looked at MySQL.
Most of my biggest complaints aren't quite valid anymore.
For a long time, MySQL didn't support foreign key constraints.  It
accepted the syntax, but it wouldn't check them.  In other words, using
FOREIGN KEY in a CREATE TABLE statement was a no-op.
One of MySQL's several storage engines, InnoDB, does support foreign key
constraints.  It has done so for a few years now.  The other storage
engines do not.  You probably want to use InnoDB.  Also, some of the engines
don't support transactions.  Thankfully, InnoDB does.
Prior to version 5.0, MySQL didn't have stored procedures.
All of these things have always just worked out of the box for me with
PostgreSQL.

Be careful about identifiers when using MySQL.  Table
names are case-sensitive on Unix and case-insensitive on Windows.  Trigger
names are case sensitive.  Et cetera.
There's a MySQL variable called "lower_case_table_names".  When set to 1,
table names are stored on disk in lowercase.  Comparisons convert both operands
to lowercase as well.
You get the benefit of case-insensitivity, but it is not case-preserving.
The reference manual has  the gory details.

That is a fair explanation of what I omitted earlier today.
Hope it helps.

-- Chris

Re: Database software

[Alex Snow]

What about the mysql command-line client, called "mysql"?
On Fri, Oct 23, 
2009 at 03:56:26AM -1000, David Sexton wrote:
> Hi, I am looking for database software that will let me create, 
> edit, and view mysql 
> databases.
> Any out there that work especially well with speakup?
> _______________________________________________
> Speakup mailing list
> Speakup@braille.uwo.ca
> http://speech.braille.uwo.ca/mailman/listinfo/speakup

-- 
quit   When the quit statement is read, the  bc  processor
       is  terminated, regardless of where the quit state-
       ment is found.  For example, "if  (0  ==  1)  quit"
       will cause bc to terminate.
	-- seen in the manpage for "bc". Note the "if" statement's logic

Re: Database software

[David Sexton]

does anyone use mysql for their address book, cd collection, and so on?

* Alex Snow <alex_snow@gmx.net> [091023 06:37]:
> What about the mysql command-line client, called "mysql"?
> On Fri, Oct 23, 
> 2009 at 03:56:26AM -1000, David Sexton wrote:
> > Hi, I am looking for database software that will let me create, 
> > edit, and view mysql 
> > databases.
> > Any out there that work especially well with speakup?
> > _______________________________________________
> > Speakup mailing list
> > Speakup@braille.uwo.ca
> > http://speech.braille.uwo.ca/mailman/listinfo/speakup
> 
> -- 
> quit   When the quit statement is read, the  bc  processor
>        is  terminated, regardless of where the quit state-
>        ment is found.  For example, "if  (0  ==  1)  quit"
>        will cause bc to terminate.
> 	-- seen in the manpage for "bc". Note the "if" statement's logic
> _______________________________________________
> Speakup mailing list
> Speakup@braille.uwo.ca
> http://speech.braille.uwo.ca/mailman/listinfo/speakup

Re: Database software

[Chris Brannon]

David Sexton wrote:
> does anyone use mysql for their address book, cd collection, and so on?

I'd be shocked if someone did.  If you want to store this sort of thing
in a relational database, then sqlite would be a very good fit.  As for
myself, I put these sorts of things into text files under ~/personal.

-- Chris

database software

[Gregory Nowak]

Hi all.

Does anyone have suggestions for database software? I'm thinking of
something that lets the user create various databases with field/value
pairs, and allows one to either do a search on the full database file,
or on selected fields. What I have in mind is something similar to
braillebase on the Blazie notetakers, or keybase on the braillenote, just
to name a couple for those who are familiar with one or both.

I'm running debian squeeze, but will upgrade to wheezy in the near
future. So, I would prefer something which has a debian package. In my
research I found gcstar, which looks like it should do what I want,
except that it relies on gnome. I would really prefer something that
runs from the text console, and can be used interactively, and from
the CLI.

Suggestions for such a beast would be much appreciated. Thanks in
advance.

Greg


-- 
web site: http://www.gregn.net
gpg public key: http://www.gregn.net/pubkey.asc
skype: gregn1
(authorization required, add me to your contacts list first)

--
Free domains: http://www.eu.org/ or mail dns-manager@EU.org

Re: database software

[Mike Ray]

Greg,

What you probably need is sqlite.

sqlite is a totally free public domain database engine.  It is used in 
probably more devices than any other rdbms, because it is present in 
practically every embedded device.  Mobile phones, tablets and media 
centres.

If you install Python, you will get sqlite along with it.

There are ways to connect to it from practically every language you can 
think of.

And it even has the ability to create purely 'in memory' databases for 
temporary configuration stuff.

I have used it on a Raspberry Pi to hold the station list in a home-brew 
internet radio.

Mike



On 12/05/2013 23:03, Gregory Nowak wrote:
> Hi all.
>
> Does anyone have suggestions for database software? I'm thinking of
> something that lets the user create various databases with field/value
> pairs, and allows one to either do a search on the full database file,
> or on selected fields. What I have in mind is something similar to
> braillebase on the Blazie notetakers, or keybase on the braillenote, just
> to name a couple for those who are familiar with one or both.
>
> I'm running debian squeeze, but will upgrade to wheezy in the near
> future. So, I would prefer something which has a debian package. In my
> research I found gcstar, which looks like it should do what I want,
> except that it relies on gnome. I would really prefer something that
> runs from the text console, and can be used interactively, and from
> the CLI.
>
> Suggestions for such a beast would be much appreciated. Thanks in
> advance.
>
> Greg
>
>


-- 
Michael A. Ray
Analyst/Programmer
Witley, Surrey, South-east UK

Interested in accessibility on the Raspberry Pi?
Visit: http://www.raspberryvi.org/

 From where you can join our mailing list for visually-impaired Pi hackers

Re: database software

[Gregory Nowak]

Thanks Mike! It looks like sqlite is what I was looking for. I've got
the sqlite3 and sqlite3-doc packages installed, and will be figuring
things out.

Greg


On Sun, May 12, 2013 at 11:22:14PM +0100, Mike Ray wrote:
> Greg,
> 
> What you probably need is sqlite.
> 
> sqlite is a totally free public domain database engine.  It is used
> in probably more devices than any other rdbms, because it is present
> in practically every embedded device.  Mobile phones, tablets and
> media centres.
> 
> If you install Python, you will get sqlite along with it.
> 
> There are ways to connect to it from practically every language you
> can think of.
> 
> And it even has the ability to create purely 'in memory' databases
> for temporary configuration stuff.
> 
> I have used it on a Raspberry Pi to hold the station list in a
> home-brew internet radio.
> 
> Mike


-- 
web site: http://www.gregn.net
gpg public key: http://www.gregn.net/pubkey.asc
skype: gregn1
(authorization required, add me to your contacts list first)

--
Free domains: http://www.eu.org/ or mail dns-manager@EU.org

Re: database software

[Willem van der Walt]

As part of the kies package, I wrote a database frontend that is doing 
most of what you want.
It uses adodb, so you can pick your database backend.
It is currently set up to use mysql, but can use any adodb supported 
rdbms.
You can grab kies from:
ftp://ftp.csir.co.za/MI/National_Accessibility_Portal/wvdwalt/kies-latest.tar.bz2
HTH, Willem


On Sun, 12 May 2013, Gregory Nowak wrote:

> Hi all.
>
> Does anyone have suggestions for database software? I'm thinking of
> something that lets the user create various databases with field/value
> pairs, and allows one to either do a search on the full database file,
> or on selected fields. What I have in mind is something similar to
> braillebase on the Blazie notetakers, or keybase on the braillenote, just
> to name a couple for those who are familiar with one or both.
>
> I'm running debian squeeze, but will upgrade to wheezy in the near
> future. So, I would prefer something which has a debian package. In my
> research I found gcstar, which looks like it should do what I want,
> except that it relies on gnome. I would really prefer something that
> runs from the text console, and can be used interactively, and from
> the CLI.
>
> Suggestions for such a beast would be much appreciated. Thanks in
> advance.
>
> Greg
>
>
> -- 
> web site: http://www.gregn.net
> gpg public key: http://www.gregn.net/pubkey.asc
> skype: gregn1
> (authorization required, add me to your contacts list first)
>
> --
> Free domains: http://www.eu.org/ or mail dns-manager@EU.org
> _______________________________________________
> Speakup mailing list
> Speakup@linux-speakup.org
> http://linux-speakup.org/cgi-bin/mailman/listinfo/speakup
>
> -- 
> This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard.
> The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.
>
> This message has been scanned for viruses and dangerous content by MailScanner,
> and is believed to be clean.
>
> Please consider the environment before printing this email.
>
>

Re: database software

[Gregory Nowak]

Thanks Willem, I'll check this out as well.

Greg


On Mon, May 13, 2013 at 09:53:50AM +0200, Willem van der Walt wrote:
> As part of the kies package, I wrote a database frontend that is
> doing most of what you want.
> It uses adodb, so you can pick your database backend.
> It is currently set up to use mysql, but can use any adodb supported
> rdbms.
> You can grab kies from:
> ftp://ftp.csir.co.za/MI/National_Accessibility_Portal/wvdwalt/kies-latest.tar.bz2
> HTH, Willem
> 
> 


-- 
web site: http://www.gregn.net
gpg public key: http://www.gregn.net/pubkey.asc
skype: gregn1
(authorization required, add me to your contacts list first)

--
Free domains: http://www.eu.org/ or mail dns-manager@EU.org

Re: database software

[Tony Baechler]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

I've been looking for such a thing for years without much luck.  Of course
there is MySQL and the web interface to go with it, but that seemed way
too complicated to me.  There is also the "recutils" package which is
command line only, but I didn't like it either.  I ended up using PC-File
for DOS which does exactly what I want.  It was shareware but has been
made free by the author.  I don't think you can register now anyway.  The
problem with it is that it's designed for low memory usage so it can't
hold 50,000 records which is what I need.  The recutils package can, but
it uses flat files and seems slow.  There is also SQLite Browser, but it
seems to require X.  I think recutils is only in Wheezy.

On 5/12/2013 3:03 PM, Gregory Nowak wrote:
> Does anyone have suggestions for database software? I'm thinking of 
> something that lets the user create various databases with field/value 
> pairs, and allows one to either do a search on the full database file, 
> or on selected fields. What I have in mind is something similar to 
> braillebase on the Blazie notetakers, or keybase on the braillenote,
> just to name a couple for those who are familiar with one or both.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (MingW32)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBCAAGBQJRkKb0AAoJEPrAuJWnLe0yNPQQAI+AqdnAXZ9RhnDqlBwdhULk
jcJvyrS7RvzU4lUOaf2GKbav902GFtQcUnnjbPBgy3tbPf57pDOrmx8VDFQJ5vB5
usIXcrQgGMJnAyUWapNZX9Nu1d3cME1yLeVioIpKCK2DYLN9qG8chxEgGFV3MUy/
ebx5J+HXgYV57JCVjPncOWPaMDMiZNZ07r2OR8sCgdE1QmpvUTqT7cAh13yN90ST
XMzbHFD+IBpusTh3O32723lAxu6fk5a+jXgpsmtsafPrQkhpBsL4UYTWGsAMPcr+
mbJm5kRMoqeHUw2X++2lIOav1cDMEC3UutAsLe9yfdcg1WklTZ/aCL2D1TO1HdF+
nqomIjJMhrsP1SV8X73WlZolZJGbLGJT1/5EstgraIn1RX2rIt9N7MViYNfXXLBp
Tw31KKP7Z/agDHG5GA2FqC6THCfyJhlOMeM2Arnsvdgx3gM1EZvSSCx5Kr3BXSZq
YYJ9ydVwZ/O266G2l5jAh5h1xwmhqxVh4H7r6olAGHi+D4vX+pLdV1n2eWT4BfMP
f2iHeP9MyMgDtzjCoytBS/9lgNCpdceYREbY5HtcFpbN1lvUnIMp1aM4H3Y55/YE
wlnPRFVQ9uKECuhHPnET3q8ibf9qEoy1qI5g3OVjeRrUNn/8TGQ+oxaZ4J8NnpKM
E/ZZ6APDUYx7n+l1up8m
=CA03
-----END PGP SIGNATURE-----