If I've asked this before, I'm sorry, but once again I'm hoping to move
databases to a new to me machine, and feel I ought to try to sort things
out once and for all. Just as I did last time and the time before.

At the moment, I'm running 3 MySQL flat databases for various lists,
plus a contacts list in Palm Desktop, a list of private recordings in a
spreadsheet, and have been trying MediaMonkey for video and audio.

What I think I want is to move everything to MySQL to make it moderately
future proof and then find some way of using some already created
generalised front end that can be tailored to the individual lists.
Obviously import, search and order by columns would be needed.

Does anyone know of a source for something like this? Free or very
cheap.

I use a program called HeidiSQL for the MySQL databases at the moment
and it is nearly there, but a bit clunky. I've had a few goes with the
LibreOffice database functions, but never really got anywhere and I'm
even older and further removed from my programming days now..
--
Bill


---
This email has been checked for viruses by AVG.
https://www.avg.com

On 17/09/18 17:12, Bill wrote:
If I've asked this before, I'm sorry, but once again I'm hoping to move
databases to a new to me machine, and feel I ought to try to sort things
out once and for all. Just as I did last time and the time before.

At the moment, I'm running 3 MySQL flat databases for various lists,
plus a contacts list in Palm Desktop, a list of private recordings in a
spreadsheet, and have been trying MediaMonkey for video and audio.

What I think I want is to move everything to MySQL to make it moderately
future proof and then find some way of using some already created
generalised front end that can be tailored to the individual lists.
Obviously import, search and order by columns would be needed.

Does anyone know of a source for something like this? Free or very cheap.

write yer own in PHP - its pretty simple

PHPmyadmin is a good place to start as well.

I use a program called HeidiSQL for the MySQL databasesÂ* at the moment
and it is nearly there, but a bit clunky. I've had a few goes with the
LibreOffice database functions, but never really got anywhere and I'm
even older and further removed from my programming days now..


--
Any fool can believe in principles - and most of them do!

In message , The Natural Philosopher
writes
write yer own in PHP - its pretty simple

PHPmyadmin is a good place to start as well.

I might have a go, as I started on similar lines once before.

On the old machine, I have Xampp, but can't remember how far I got, ran
out of time, and life here is just as hectic now,

That's why I was hoping someone might have a suggestion for a ready made
"shell" program that doesn't need to run a web server.
--
Bill

---
This email has been checked for viruses by AVG.
https://www.avg.com

On 17/09/2018 23:21, Bill wrote:
In message , The Natural Philosopher
writes
write yer own in PHPÂ* - its pretty simple

PHPmyadmin is a good place to start as well.

I might have a go, as I started on similar lines once before.

On the old machine, I have Xampp, but can't remember how far I got, ran
out of time, and life here is just as hectic now,

That's why I was hoping someone might have a suggestion for a ready made
"shell" program that doesn't need to run a web server.

You could install one of the many database connectors to interface
directly with the database, e.g:

https://dev.mysql.com/downloads/connector/odbc/

You can then talk directly to that in any number of languages and
environments. No need for a web server then.


--
Cheers,

John.

/================================================== ===============\
| Internode Ltd - http://www.internode.co.uk |
|-----------------------------------------------------------------|
| John Rumm - john(at)internode(dot)co(dot)uk |
\================================================= ================/

In message , Tim Streater
writes
In article , John
Rumm wrote:

On 17/09/2018 23:21, Bill wrote:
In message , The Natural Philosopher
writes
write yer own in PHP* - its pretty simple

PHPmyadmin is a good place to start as well.
I might have a go, as I started on similar lines once before.
On the old machine, I have Xampp, but can't remember how far I got,
ran out of time, and life here is just as hectic now,
That's why I was hoping someone might have a suggestion for a ready
made "shell" program that doesn't need to run a web server.

You could install one of the many database connectors to interface
directly with the database, e.g:

https://dev.mysql.com/downloads/connector/odbc/

You can then talk directly to that in any number of languages and
environments. No need for a web server then.

Is there some reason this has to be done with mySQL? Are there hundreds
of users or only the OP?

Here's where I am today.

Spent all free time messing with Xampp, PHPmyadmin and transferring the
3 Mysql databases into the newer machine. I think I may be nearly there
with being able to look at, if not actually use fully, these databases
through a browser.

I am still not sure that this is the right approach for me. I was lucky
with time availability today because I had a 4 hour window while our
'house guest' was at hospital. Usually breathers come in 15 minute
lumps, if that.

I have played with odbc connectors in the past when using C++ Builder to
write small programs, and maybe that was what I used when trying to
interface with Libre/Open Office? I can't remember now.

The reason I like MySQL is because it seems stable and unlikely to
become totally obsolete. Yes, users are just me and occasionally a son
or two, but I can usually knock up a list of something or other in it
pretty quickly. I have to get these other older lists of data off old
and unsupported things (like the Palm database) and into a common,
standard to me, format. And, if I wanted to get into relational
databases, it's there.

I had problems when trying to use DBase4 a long time ago, and Access
over the years, and have had all sorts of software in the past. Even
back to a circular database I wrote in machine code for a handbuilt Z80
device.

I am surprised that I can't find anything that does what I want. With my
memory, lots of lists are essential. As I mentioned earlier, HeidiSQL
isn't far off.

I haven't given up yet. Thanks for the suggestions, they all help.

--
Bill

---
This email has been checked for viruses by AVG.
https://www.avg.com

In message , Tim Streater
writes
In article , Bill
wrote:

In message , Tim Streater
writes
Is there some reason this has to be done with mySQL? Are there hundreds
of users or only the OP?

The reason I like MySQL is because it seems stable and unlikely to
become totally obsolete. Yes, users are just me and occasionally a son
or two, ...

In which case why are you futzing with mySQL, which requires you to set
up a server. Just use SQLite instead, which is built into PHP and
requires no server at all.

I'll have a look at SQLite, but the database engine is not really the
sticking point, I don't think.

My hope was to find a simple general purpose UI that could be populated
with specific columns for specific uses and give a standard way of
looking at, updating, amending, printing etc. So, for example, the
Contacts list would work in exactly the same way as the lists of audio
and video files, with the latter being able to be played by a simple
click on the list.

Really, I suppose it's just a sort of spreadsheet-like interface that
would keep me with a system that could be expanded in future if more
complex database features were needed.
--
Bill

---
This email has been checked for viruses by AVG.
https://www.avg.com