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. |
|
|
|
Thread Tools | Rate Thread | Display Modes |
#16
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
|
|