A Windows XP help forum. PCbanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » PCbanter forum » Microsoft Windows 8 » Windows 8 Help Forum
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

tagging indexing software Information request



 
 
Thread Tools Rate Thread Display Modes
  #16  
Old December 1st 14, 07:36 AM posted to alt.comp.os.windows-8
Rodney Pont[_4_]
external usenet poster
 
Posts: 229
Default tagging indexing software Information request

On Sun, 30 Nov 2014 15:09:55 -0800, Gene E. Bloch wrote:

I don't find Java (or Android) programming especially easy compared to C
or VB, but at least it is doable.


Have you tried PHP? It's fairly straightforward and does have a mysql
interface among others. Normally it's run by a web server but it can be
run from command line or an icon.

--
Faster, cheaper, quieter than HS2
and built in 5 years;
UKUltraspeed http://www.500kmh.com/


Ads
  #17  
Old December 1st 14, 02:10 PM posted to alt.comp.os.windows-8
Keith Nuttle
external usenet poster
 
Posts: 1,844
Default tagging indexing software Information request

On 12/1/2014 8:30 AM, Neil Gould wrote:
Gene E. Bloch wrote:
But suddenly, as I was composing this reply I got this thought: is
there a Java interface into SQL or other data base stuff? I have no
idea, but if there is and it works, then the price is probably right.

I don't find Java (or Android) programming especially easy compared
to C or VB, but at least it is doable.

The user interface for an SQL database can be created in many ways, so you
could use Java, VB, C, or whatever you're familiar with. That said, I still
think that you may find Family Tree Maker to already be what you want. If
you haven't already, give it a look. If you have looked, I'm curious about
what needs you have that it can't provide.

Genealogy OP: Yes I have Family Tree Maker, and while it can attach
files to a person/people in the database, and works well from the person
to the file. There is no search facility to go directly to the file,
without knowing the person.

I believe the person who posted about managing his music files is
looking for a functionally similar program. and if the software existed
it could be loaded with data to serve his purpose and mine.

I have looked at SQL programs, but find the user interface leave a lot
to be desired. Is there a interface program that would make SQL, or
one of the flavors an MS Access clone?

I am quite familiar with the dBase IV programing language, and have
written over 10t lines of code to manage data and documents in a QA
system. I have a copy of dBase IV but have never tried to install it on
Windows 8.1, and have never seen a Basic that will run on Windows 8.1.

Is there one?






  #18  
Old December 1st 14, 02:30 PM posted to alt.comp.os.windows-8
Neil Gould[_2_]
external usenet poster
 
Posts: 167
Default tagging indexing software Information request

Gene E. Bloch wrote:
But suddenly, as I was composing this reply I got this thought: is
there a Java interface into SQL or other data base stuff? I have no
idea, but if there is and it works, then the price is probably right.

I don't find Java (or Android) programming especially easy compared
to C or VB, but at least it is doable.

The user interface for an SQL database can be created in many ways, so you
could use Java, VB, C, or whatever you're familiar with. That said, I still
think that you may find Family Tree Maker to already be what you want. If
you haven't already, give it a look. If you have looked, I'm curious about
what needs you have that it can't provide.

--
best regards,

Neil



  #19  
Old December 1st 14, 03:34 PM posted to alt.comp.os.windows-8
Yes[_2_]
external usenet poster
 
Posts: 76
Default tagging indexing software Information request

Neil wrote:

On 11/30/2014 1:22 PM, Bill wrote:

Neil: If there is a paid for program that is flexible enough to do
what I want, I haven't found it yet. I do some assisting at a small
business that uses locally written paid-for CRM software. It stops
working every time Windows, their anti-virus or Office (which does
the letters) changes and the original company has disappeared. It
took me a long time to track down the person from that company who
actually wrote the software. I opted out and got the business to
deal directly with him.

Unlike Gene's situation, I doubt that there is an off-the shelf
product that will meet all of your needs because they're rather
unusual outside of a professional setting such as radio stations or
music warehouses.

However, from what you've written, it doesn't sound all that complex,
and perhaps you could just use some help from someone who knows
relational database design. I don't really think that the database
engine is as critical as the overall design in your case. Even Access
should be capable of handling your project unless you plan to have a
few million records in one or more of the data tables. I'd probably
go with MS-SQL, given the gyrations that MySQL has been undergoing
for the last few years. It's strongest attraction is its price, IMO.


This thread reminded me that there are two OSS projects that supposedly
offer free database programs - LibreOffice and Open Office. Wikipedia
also has two+ pages related to free, open source softwa
http://en.wikipedia.org/wiki/List_of...tware_packages

and wrt databases

http://en.wikipedia.org/wiki/Categor...gement_systems
  #20  
Old December 1st 14, 05:13 PM posted to alt.comp.os.windows-8
mick
external usenet poster
 
Posts: 370
Default tagging indexing software Information request

On 01/12/2014 13:10:25, Keith Nuttle wrote:
On 12/1/2014 8:30 AM, Neil Gould wrote:
Gene E. Bloch wrote:
But suddenly, as I was composing this reply I got this thought: is
there a Java interface into SQL or other data base stuff? I have no
idea, but if there is and it works, then the price is probably right.

I don't find Java (or Android) programming especially easy compared
to C or VB, but at least it is doable.

The user interface for an SQL database can be created in many ways, so you
could use Java, VB, C, or whatever you're familiar with. That said, I still
think that you may find Family Tree Maker to already be what you want. If
you haven't already, give it a look. If you have looked, I'm curious about
what needs you have that it can't provide.

Genealogy OP: Yes I have Family Tree Maker, and while it can attach files to
a person/people in the database, and works well from the person to the file.
There is no search facility to go directly to the file, without knowing the
person.


Have a look at Rootsmagic
http://www.rootsmagic.co.uk/about/overview.php#explorer
Searching Your Database article

--
mick
  #21  
Old December 1st 14, 05:50 PM posted to alt.comp.os.windows-8
mick
external usenet poster
 
Posts: 370
Default tagging indexing software Information request

On 01/12/2014 16:13:21, mick wrote:
On 01/12/2014 13:10:25, Keith Nuttle wrote:
On 12/1/2014 8:30 AM, Neil Gould wrote:
Gene E. Bloch wrote:
But suddenly, as I was composing this reply I got this thought: is
there a Java interface into SQL or other data base stuff? I have no
idea, but if there is and it works, then the price is probably right.

I don't find Java (or Android) programming especially easy compared
to C or VB, but at least it is doable.

The user interface for an SQL database can be created in many ways, so you
could use Java, VB, C, or whatever you're familiar with. That said, I
still
think that you may find Family Tree Maker to already be what you want. If
you haven't already, give it a look. If you have looked, I'm curious about
what needs you have that it can't provide.

Genealogy OP: Yes I have Family Tree Maker, and while it can attach files
to a person/people in the database, and works well from the person to the
file. There is no search facility to go directly to the file, without
knowing the person.


Have a look at Rootsmagic
http://www.rootsmagic.co.uk/about/overview.php#explorer
Searching Your Database article


Should have included this link
http://www.rootsmagic.co.uk/compare-...als.php#search

--
mick
  #22  
Old December 1st 14, 06:15 PM posted to alt.comp.os.windows-8
Keith Nuttle
external usenet poster
 
Posts: 1,844
Default tagging indexing software Information request

On 12/1/2014 1:08 PM, Neil Gould wrote:
I am not clear about what you mean by saying "...to go directly to the file
without knowing the person." To what or whom is the file associated when
it's stored?

In the example I have been using, the file may be associated with
multiple persons, it may be need to be access by the person owning the
lot not necessarily the person whom it is associated, or it may need to
be accessed because it is a map of Perrysburg.
  #23  
Old December 1st 14, 06:48 PM posted to alt.comp.os.windows-8
Neil Gould[_2_]
external usenet poster
 
Posts: 167
Default tagging indexing software Information request

Yes wrote:
Neil wrote:

On 11/30/2014 1:22 PM, Bill wrote:

Neil: If there is a paid for program that is flexible enough to do
what I want, I haven't found it yet. I do some assisting at a small
business that uses locally written paid-for CRM software. It stops
working every time Windows, their anti-virus or Office (which does
the letters) changes and the original company has disappeared. It
took me a long time to track down the person from that company who
actually wrote the software. I opted out and got the business to
deal directly with him.

Unlike Gene's situation, I doubt that there is an off-the shelf
product that will meet all of your needs because they're rather
unusual outside of a professional setting such as radio stations or
music warehouses.

However, from what you've written, it doesn't sound all that complex,
and perhaps you could just use some help from someone who knows
relational database design. I don't really think that the database
engine is as critical as the overall design in your case. Even Access
should be capable of handling your project unless you plan to have a
few million records in one or more of the data tables. I'd probably
go with MS-SQL, given the gyrations that MySQL has been undergoing
for the last few years. It's strongest attraction is its price, IMO.


This thread reminded me that there are two OSS projects that
supposedly offer free database programs - LibreOffice and Open
Office. Wikipedia also has two+ pages related to free, open source
softwa

http://en.wikipedia.org/wiki/List_of...tware_packages

and wrt databases

http://en.wikipedia.org/wiki/Categor...gement_systems

I think MySQL is probably the most usable open-source database engine, but
it has been going through frequent "upgrade" cycles of late, and that is
often problematic. Once again, the issue is not so much the database engine,
it's the design of the database and creation of the user interface. For the
OP's needs, this requires a level of experience beyond just knowing a
programming language or "all-in-one" database program.
--
best regards,

Neil



  #24  
Old December 1st 14, 07:08 PM posted to alt.comp.os.windows-8
Neil Gould[_2_]
external usenet poster
 
Posts: 167
Default tagging indexing software Information request

Keith Nuttle wrote:
On 12/1/2014 8:30 AM, Neil Gould wrote:
Gene E. Bloch wrote:
But suddenly, as I was composing this reply I got this thought: is
there a Java interface into SQL or other data base stuff? I have no
idea, but if there is and it works, then the price is probably
right.

I don't find Java (or Android) programming especially easy compared
to C or VB, but at least it is doable.

The user interface for an SQL database can be created in many ways,
so you could use Java, VB, C, or whatever you're familiar with. That
said, I still think that you may find Family Tree Maker to already
be what you want. If you haven't already, give it a look. If you
have looked, I'm curious about what needs you have that it can't
provide.

Genealogy OP: Yes I have Family Tree Maker, and while it can attach
files to a person/people in the database, and works well from the
person to the file. There is no search facility to go directly to
the file, without knowing the person.

I am not clear about what you mean by saying "...to go directly to the file
without knowing the person." To what or whom is the file associated when
it's stored?

I believe the person who posted about managing his music files is
looking for a functionally similar program. and if the software
existed it could be loaded with data to serve his purpose and mine.

Well, I know there are music management programs, but they are professional
(read not cheap) and oriented toward a different set of tasks then Bill
wants. For example, radio stations use such apps to run their on-air
programming.

I have looked at SQL programs, but find the user interface leave a lot
to be desired. Is there a interface program that would make SQL, or
one of the flavors an MS Access clone?

Some SQL database engines don't have a user interface, since they don't need
it because users write their own functions to manage the database, and there
may or may not be a "user interface" in the final product. MS Access is and
SQL database app oriented toward those who are used to working with dBase
and such, and it's cheap.

I am quite familiar with the dBase IV programing language, and have
written over 10t lines of code to manage data and documents in a QA
system. I have a copy of dBase IV but have never tried to install it
on Windows 8.1, and have never seen a Basic that will run on Windows
8.1.

Visual Basic runs on all versions of Windows, and depending on what you need
to do, doesn't require purchasing anything in the way of a UI since it is a
natively supported scripting language.

--
best regards,

Neil


  #25  
Old December 1st 14, 08:04 PM posted to alt.comp.os.windows-8
Bill[_40_]
external usenet poster
 
Posts: 346
Default tagging indexing software Information request

In message , Neil Gould
writes
I think MySQL is probably the most usable open-source database engine,
but it has been going through frequent "upgrade" cycles of late, and
that is often problematic. Once again, the issue is not so much the
database engine, it's the design of the database and creation of the
user interface. For the OP's needs, this requires a level of experience
beyond just knowing a programming language or "all-in-one" database
program.


I think I'll disappear for a bit and have another go. I'll start again
on a new machine and try to document what I'm doing this time. I do
understand about planning the structure, so perhaps starting from basic
SQL and getting it going will make the user interface end of things fall
into place.

I have talked to my son who does a lot with MySQL and he has pointed me
to a tutorial that he used.

www.tutorialspoint.com/sql/sql_tutorial.pdf

His connects via Matlab.

I have had several flat databases running for a few years and in use all
the time on MySQL, and I did install MariaDB on another machine in case
Oracle breaks MySQL. Should I be looking to change to MariaDB?

I am familiar with some broadcast automation systems (and despise what
they have done to radio) and they are not what I want.

My experiences with Access all those years ago made me vow to avoid it
for ever. I've not yet had any problem with MySQL where all the data
became inaccessible, and I did with Access and its update.

--
Bill
  #26  
Old December 1st 14, 08:13 PM posted to alt.comp.os.windows-8
Ed Cryer
external usenet poster
 
Posts: 2,621
Default tagging indexing software Information request

Keith Nuttle wrote:
On 12/1/2014 1:08 PM, Neil Gould wrote:
I am not clear about what you mean by saying "...to go directly to the
file
without knowing the person." To what or whom is the file associated when
it's stored?

In the example I have been using, the file may be associated with
multiple persons, it may be need to be access by the person owning the
lot not necessarily the person whom it is associated, or it may need to
be accessed because it is a map of Perrysburg.


It's your current data structure that needs the attention.
You've been given a whole list of programs capable of setting up a
dbase. And if you were going to enter the data one after the other, then
that would be it.
Is that what you want? I doubt it. You want it to handle the data
already there.

You must do a breakdown of all the files; file types and counts, data
held, links between files.

With that info available the discussion here will change from
theoretical to practical. And that is what you want.

Ed

  #27  
Old December 2nd 14, 12:13 AM posted to alt.comp.os.windows-8
Neil
external usenet poster
 
Posts: 714
Default tagging indexing software Information request

On 12/1/2014 12:15 PM, Keith Nuttle wrote:
On 12/1/2014 1:08 PM, Neil Gould wrote:
I am not clear about what you mean by saying "...to go directly to the
file
without knowing the person." To what or whom is the file associated when
it's stored?

In the example I have been using, the file may be associated with
multiple persons, it may be need to be access by the person owning the
lot not necessarily the person whom it is associated, or it may need to
be accessed because it is a map of Perrysburg.

I see. Sounds almost like a cross between genealogy and real estate. Not
a very difficult structure, but not likely to be accomplished with "off
the shelf" apps.

--
best regards,

Neil
  #28  
Old December 2nd 14, 12:22 AM posted to alt.comp.os.windows-8
Neil
external usenet poster
 
Posts: 714
Default tagging indexing software Information request

On 12/1/2014 2:04 PM, Bill wrote:
In message , Neil Gould
writes
I think MySQL is probably the most usable open-source database engine,
but it has been going through frequent "upgrade" cycles of late, and
that is often problematic. Once again, the issue is not so much the
database engine, it's the design of the database and creation of the
user interface. For the OP's needs, this requires a level of
experience beyond just knowing a programming language or "all-in-one"
database program.


I think I'll disappear for a bit and have another go. I'll start again
on a new machine and try to document what I'm doing this time. I do
understand about planning the structure, so perhaps starting from basic
SQL and getting it going will make the user interface end of things fall
into place.

I have talked to my son who does a lot with MySQL and he has pointed me
to a tutorial that he used.

www.tutorialspoint.com/sql/sql_tutorial.pdf

His connects via Matlab.

I have had several flat databases running for a few years and in use all
the time on MySQL, and I did install MariaDB on another machine in case
Oracle breaks MySQL. Should I be looking to change to MariaDB?

I am familiar with some broadcast automation systems (and despise what
they have done to radio) and they are not what I want.

I have several friends in radio, and most of them don't like their new
roles as meat-based androids either. Although that kind of app is not
ideally suited to what you are doing, it does provide robust cataloging
functions and some other features that you might use if you had it.

My experiences with Access all those years ago made me vow to avoid it
for ever. I've not yet had any problem with MySQL where all the data
became inaccessible, and I did with Access and its update.

I've not had that kind of problem with any database engine, and I use
MySQL, MS SQL, Access, and even have dBase running an app for the last
25-30 years that I just don't feel like rewriting. Once again, it's not
so much an engine issue as a design issue.

--
best regards,

Neil
  #29  
Old December 2nd 14, 02:37 AM posted to alt.comp.os.windows-8
Gene E. Bloch[_2_]
external usenet poster
 
Posts: 7,485
Default tagging indexing software Information request

On Mon, 01 Dec 2014 06:36:41 +0000 (GMT), Rodney Pont wrote:

On Sun, 30 Nov 2014 15:09:55 -0800, Gene E. Bloch wrote:

I don't find Java (or Android) programming especially easy compared to C
or VB, but at least it is doable.


Have you tried PHP? It's fairly straightforward and does have a mysql
interface among others. Normally it's run by a web server but it can be
run from command line or an icon.


Since I don't plan to do anything requiring databases, I won't bother. I
was making a suggestion for the OP...

--
Gene E. Bloch (Stumbling Bloch)
  #30  
Old December 2nd 14, 02:38 AM posted to alt.comp.os.windows-8
Gene E. Bloch[_2_]
external usenet poster
 
Posts: 7,485
Default tagging indexing software Information request

On Mon, 1 Dec 2014 08:30:24 -0500, Neil Gould wrote:

Gene E. Bloch wrote:
But suddenly, as I was composing this reply I got this thought: is
there a Java interface into SQL or other data base stuff? I have no
idea, but if there is and it works, then the price is probably right.

I don't find Java (or Android) programming especially easy compared
to C or VB, but at least it is doable.

The user interface for an SQL database can be created in many ways, so you
could use Java, VB, C, or whatever you're familiar with. That said, I still
think that you may find Family Tree Maker to already be what you want. If
you haven't already, give it a look. If you have looked, I'm curious about
what needs you have that it can't provide.


Since I don't plan to do anything requiring databases, I won't bother. I
was making a suggestion for the OP...

--
Gene E. Bloch (Stumbling Bloch)
 




Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off






All times are GMT +1. The time now is 09:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 PCbanter.
The comments are property of their posters.