| Looking for >useful< database |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
 |
1. Looking for >useful< database |
|
|
| Hi, I've got experience with rexxsql that it is awesome to use together with Sybase SQL Anywhere 9 and ODBC connection (yea, I know, on another OS). The thing is that I've written 3 rexx graphical apps that are useful in every day work¹ and would like to do something similar on eComStation. I'd therefore like to ask you for some help to find a database engine with a graphical tool to manage the database, tables, write sql statements etc. and that it can be reached through ODBC. ==== Setup: Graphic ( Native, Java or Odin ) it would also be nice if the db would work out of the box too. If command line only, please do tell me/explain how to do it in eCS-OS/2 and not require me to find a proper version "somewhere on the net" of sh and sed etc.
Client-Server communication: odbc ( so that I can use rexxsql on the client to select, insert, delete records ) ==== I tried DB2 Personal Edition with the latest fixpacks but found out that it doesn't allow inbound connections, so the huge download was a waste of time. I've looked at some interesting alternatives, but need some help then to understand how to use them... Tried Postgres 7.3.x that had to be tweaked and the scripts rewritten to work, the instuctions @ OS2Voice was helpful to some extent though, but it still complained. Postgres 8.x doesn't explain how to use it on eCS-OS2, add tables etc. just as MySQL, textmode and "you're on your own"  Mvh / Wkr / MfG //Jan-Erik ¹Software testing of a range of concurrent versions of a MPS system mean that I have to switch between several versions of an app every day. I've got one tool to deregister/register settings on the fly and start the MPS app that the other testers can only imagine, another tool to determine problems in the products and verify the problem on each version, and the last one to file reports to the right person. All these apps use odbc and databases to handle both the MPS system with it's database and additional databases to help me.
|
| Date: 09 Dec, 2006 on 12:57 |
|
|
Premium member in user
     posts: 277 since: 10 Aug, 2004 |
|
2. Re:Looking for >useful< database |
|
|
| I was just going to suggest either Postgre or MySQL, both of which have OS/2 ports. But it seems you've already looked at those. Anyways, I've been running MySQL on OS/2 for a while and it works well. As for an administration interface, I've used PHPMyAdmin through a web browser (set up a web browser - Apache or Web/2, along with PHP and you can install PHPMyAdmin). The benefit of either of these is because they are open source and available on a number of systems, in the future if you want to move the database to another server on another platform, all you really have to do is a data export and import. Anyways, you can grab what you need from Paul Smedley's website at: http://smedley.info/os2ports/index.html |
| Date: 09 Dec, 2006 on 15:46 |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
|
3. Re:Looking for >useful< database |
|
|
last updated at 09 Dec, 2006 17:53 (1 times) Thank you for the advice...The "extras" ("A" and "P" in AMP4eCS http://www.amp4ecs.de ) may very well do it but hope to avoid it as I don't want to be forced to install another webserver on my machines just for that and don't want to force users of the app-to-be, to have to do the same. It's to much M$. How about real admin apps for MySQL and Postgres? Mvh / MfG / Wkr //Jan-Erik I guess I'll never turn into a textmode l*nix user, I like the OS/2-eCS way and Drag& Drop to much for that. |
| Date: 09 Dec, 2006 on 17:50 |
|
|
Normal member in user
     posts: 40 since: 24 Mar, 2004 |
|
4. Re:Looking for >useful< database |
|
|
Jan-Erik (09 Dec, 2006 12:57): Postgres 8.x doesn't explain how to use it on eCS-OS2, add tables etc. just as MySQL, textmode and "you're on your own"
The main PostgreSQL plastforms have a admin GUI called "pgAdmin". It is coded in C/C++ and also uses WxWidgets. OS/2-eCS has a port of WxWidgets so maybe pgAdmin can be compiled for OS/2-eCS. I have setup PostgreSQL on eCS before. I have also setup my database on Linux or mswin systems then backed up and restored the database to PostgreSQL running on OS/2-eCS. You can also admin PostgreSQL using pgAdmin from a virtual machine on the OS/2-eCS computer or from a second computer. Another option you could do without inslalling anything on your hard drive, boot Knoppix Live CD on a second machine then use pgAdmin in Knoppix to admin PostgreSQL on OS/2-eCS. |
| Date: 09 Dec, 2006 on 18:39 |
|
|
Normal member in user
     posts: 40 since: 24 Mar, 2004 |
|
5. Re:Looking for >useful< database |
|
|
| Date: 09 Dec, 2006 on 18:57 |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
|
6. Re:Looking for >useful< database |
|
|
| Date: 09 Dec, 2006 on 19:36 |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
|
7. Re:Looking for >useful< database |
|
|
| Thank you for your reply... It may be possible to port pgAdmin III to OS/2-eCS as well since we've got wxWindows. Mvh / Wkr / MfG
---
//Jan-Erik
|
| Date: 09 Dec, 2006 on 19:54 |
|
|
Normal member in user
     posts: 46 since: 09 Dec, 2004 |
|
8. Re:Looking for >useful< database |
|
|
last updated at 13 Dec, 2006 15:41 (1 times) While this may or may not be helpful. it doesn't hurt to be reminded of Douglas Clark's in-depth eCS-OS/2 specific 12-part database series titled, "ODBC on OS/2," on OS/2 eZine a few years ago that begins with the May 16, 2001 issue at http://www.os2ezine.com/backissues.htmlThe ODBC on OS/2 Part 5 article on PostgreSQL (then at v7.1) is at http://www.os2ezine.com/20010916/page_7.html Here's some of Douglas Clark's part 5 article: "Among the so called 'open source' SQL databases available on OS/2 - PostgreSQL, mySQL, miniSQL - PostgreSQL is feature-wise vastly superior in every way. PostgreSQL also compares very favorably with commercial databases, at least in the feature and design areas." |
| Date: 09 Dec, 2006 on 20:09 |
|
|
Normal member in user
       posts: 113 since: 04 Oct, 2006
 |
|
9. Re:Looking for >useful< database |
|
|
last updated at 09 Dec, 2006 21:37 (2 times)
Jan-Erik (09 Dec, 2006 19:36): Hmm, I've now (finally) found this one:PGCup written in JAVA http://gborg.postgresql.org/project/pgcup/download/download.php I have now seen the commands in it how to create tables and users etc. a) A few years old 
For a more current pure Java alternative, you may consider IBM's freely downloadable Cloudscape and/or open source Apache Derby. If you know DB2 SQL commands, you will find that you already know how to manage either of the above mentioned alternatives.Please, see the following previous reply and elaborate if either CloudScape and/or Derby would be something you may want to try: < http://www.os2world.com/cgi-bin/ultraboard/UltraBoard.cgi?action=Read&BID=12&TID=1071&P=1&SID=yycXNMM8qGmRD13V#ID12 > This is a snapshot (under WebSphere Application Server Community Edition) of what you are getting: http://www.chingonazo.com/wasceDerbyView.JPG This database engine is used in vendor offerings, ranging from Sun Microsystems to Oracle, in some of their Web services software development platforms. ...and yes, there is ODBC support also, see: < http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0409cline2/#N10209 > Jan-Erik (09 Dec, 2006 19:36): b) Compact  c) Display commands  d) Easy to use (Took me only minutes to dowload-and-get-up-and-running) e) Behave/Look like similar tools  f) Seems to handle alot of the aspects related to db-administration  g) Use TCP/IP  h) Generate event dispatch problems at times  ( Tested with Postgres 8.1.x and GoldenCode Java 1.4.1 ) Mvh / MfG / Wkr //Jan-Erik
|
| Date: 09 Dec, 2006 on 20:59 |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
|
10. Re:Looking for >useful< database |
|
|
| Thank you for the suggestion... I'll try it out. I do know some SQL, but want the app to do the work for me as with pgcup. GUI is preferred  Mvh / Wkr / MfG //Jan-Erik |
| Date: 11 Dec, 2006 on 19:00 |
|
|
Premium member in user
     posts: 164 since: 30 Aug, 2006
 |
|
11. Re:Looking for >useful< database |
|
|
| Someone help me out here. Why doesn't Lotus Approach satisfy the requirements? |
| Date: 11 Dec, 2006 on 23:44 |
|
|
Normal member in user
     posts: 3 since: 06 May, 2006 |
|
12. Re:Looking for >useful< database |
|
|
| Lotus Approach doesn't meet Jan-Erik's last requirement... it cannot be reached using ODBC. |
| Date: 12 Dec, 2006 on 02:11 |
|
|
Premium member in user
     posts: 164 since: 30 Aug, 2006
 |
|
13. Re:Looking for >useful< database |
|
|
| Sorry I meant Approach just for the client, with a Postgres or MySQL server backend through ODBC. |
| Date: 12 Dec, 2006 on 02:50 |
|
|
Normal member in user
     posts: 46 since: 09 Dec, 2004 |
|
14. Re:Looking for >useful< database |
|
|
last updated at 12 Dec, 2006 16:39 (1 times) Just remembered DbVisualizer, a Java-based universal database tool, now at v5.1, might be useful.It is listed "eCS-OS/2 compatible" at http://www.os2world.com/java/ Current features include a graphical query builder, graphing, table creation, SQL Commander, and new support for Derby. http://www.minq.se/products/dbvis/ "DbVisualizer is a feature rich, intuitive and cross platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections, it lets you explore and manage database objects, execute SQL queries, visualize information and a lot more." DbVisualizer's Forum states the coming v5.2 will strictly require Java 1.5 in a user survey. There are older versions available depending upon the underlying Java subsystem. Visualizer Query might have a fit here except it's been withdrawn from sale & development by the folks who bought it from IBM. Too bad Visualizer Query is not a part of eComStation supplemental applications pack since it is the only database query tool with intentional Workplace Shell integration. http://www.os2ezine.com/20011116/page_4.html |
| Date: 12 Dec, 2006 on 16:33 |
|
|
Premium member in user
     posts: 164 since: 30 Aug, 2006
 |
|
15. Re:Looking for >useful< database |
|
|
| From an an article on OS/2 Ezine: http://www.os2ezine.com/20010416/ssapproach.html
Database Connectivity Approach comes with ODBC Administrator which allows you to connect to a variety of databases including Btrieve, DB2, dBase, Informix 5, Oracle 7 and Sybase. I also have a driver for Postgres SQL from the Postgres SQL server installation. Unfortunately there isn't an ODBC driver for MySQL; although this isn't Lotus' problem, it is still frustrating.Through ODBC, Approach supports entering SQL queries and then processing the results, so you could use Approach for your reporting needs if you run a SQL database such as for managing your website.
|
| Date: 12 Dec, 2006 on 21:13 |
|
|
Normal member in user
     posts: 46 since: 09 Dec, 2004 |
|
16. Re:Looking for >useful< database |
|
|
| [1] Near the bottom of "ODBC on OS/2 - Part 1," Douglas Clark, provides instructions & pictures for connecting Lotus Approach to a SQL database through ODBC. http://www.os2ezine.com/20010516/odbc1.html [2] The article also defines Lotus Approach as a "Local" database. Databases come in two basic flavors: * Local, or sometimes called "desktop" - designed to be accessed (only) on the machine where the database resides. Examples are dBase, Paradox, and Approach. * Client/server - where the database resides on one machine and the users of the database are on client machines. The machine the database is on is called the database server, and may or may not be the same machine as the network server. The operating system used on the database server and the client machines may or may not be the same. (Some databases, like Watcom SQL/Sybase SQL Anywhere, function both ways: as a local database the application talks directly to the database engine, as a client/server the application talks to a client.) |
| Date: 12 Dec, 2006 on 22:22 |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
|
17. Re:Looking for >useful< database |
|
|
| The reason I'd like to use a remote server<->ODBC<->rexx is that I'm quite skilled with rexx, DrDialog and have written stuff that will generate large amounts of data that I need to store and later retrieve and communicate with others, preferrably in the same way across the world and applications. One would e.g. think that rexx is the scripting language in DBExpert, but the rexx implementation just work as some sort of layer on top of the original scripting language. I need it to interact with the system, other rexx applications and possibly other apps. I've used Approach and am quite found of the capabilities to create graphs, but LotusScipt make it limited to itself, just as the absence of server capablilites mentioned above. Mvh / MfG / Wkr //Jan-Erik |
| Date: 13 Dec, 2006 on 13:12 |
|
|
Normal member in user
     posts: 46 since: 09 Dec, 2004 |
|
18. Re:Looking for >useful< database |
|
|
last updated at 13 Dec, 2006 22:19 (1 times) I have taken, perhaps a thinking out loud interest, in this "useful database" thread, and here is why...First of all, eComStation will be the preferred workstation. Period! As a part of my research, resources have been slowly gathered for a SOHO network with: eCS 1.2R (soon 2.0) with a KVM in some type of coherent system that will talk with each other, and; part of my looking at in virtualization with a preferred eCS host instead of an eCS guest for those win-apps still required for business. Over the past few years, I've gathered OS/2-native resources for SQL & ODBC databases such as VX-Rexx Client/Server, and; VisualAge Enterprise Editions for Visualage Generator/Smalltalk, Java (for JDBC), and TeamConnection Server (for component-driven access sorted by DB2) for which a DB2/2 Workgroup Edition is targeted for installation. OS/2-native Lotus Go, Domino, and Notes have also been secured for experimentation. The thought here was to find the latest OS/2-native versions, with available & detailed documentation, that work reasonably well together in the Workplace Shell. Isn't eBay a great place to garner OS/2 resources when nobody else is looking? So, there is a method to my madness. Perhaps in a year or so, I'll be in a position to write an article(s) for the OS/2 community. This was all inspired from the "ODBC on OS/2" series in OS/2 eZine. Where was I thinking earlier without remembering part 12 - ODBC ACCESS IN OS/2? ...at http://www.os2ezine.com/20020416/page_7.html At the article's beginning we see... "There are two products for Rexx that provide access to ODBC databases, neither of which is sold anymore: VX-Rexx and VisPro-Rexx. There is currently no method for getting at ODBC data apart from those two products. However the is a library of data access routines called RexxSQL put out by Mark Hessling that provide a common (though not ODBC) interface to DB2, Oracle, mSQL, mySQL, and SQL Anywhere." "Sibyl is a Delphi clone that works on OS/2. It builds Borland-like Turbo Pascal applications using the same interface and parts as Borland's Delphi 2. It is very compatible with Delphi and supposedly you can take Delphi source (Pascal language, forms, etc.) and recompile with Sibyl on OS/2. When you are finished building your application you end up with a stand-alone executable that can be moved to any Warp machine. Sibyl is very complete. It has interfaces to TCP/IP, the OS/2 Control Program API, Rexx, multimedia and more. You can build very nice applications with Sibyl, as NewView by Aaron Lawrence shows." GET THIS: "Sibyl can work with any ODBC enabled database." It also comes with a number of drivers for different databases that bypass ODBC and allow Sibyl to work directly with that database: DB2/2, dBase, mySQL, Oracle 7, SQL Anywhere, and Paradox. I have not tested any of these. But in theory, for instance, you could use Sibyl to write applications for mySQL which does not have an ODBC driver (that works) in OS/2." "Sibyl addresses databases through a concept it calls a database alias. This database alias is very similar to a data source in ODBC, meaning that an alias is the association of an arbitrary name with a database driver. The driver can be either one of Sibyl's built in drivers or it can be an ODBC data source - if the alias is an ODBC datasource the alias must have the same name as the ODBC data source name." "The easiest way to create database aliases is with the DBExplorer tool. This little jack-of-all-trades tool allows you to create a database alias, browse the attributes of a database, and to submit SQL statements to a database." Here's another Sibyl-article at http://www.os2ezine.com/20001216/sibyl.html There is one other way for ODBC access not mentioned in the article which is VisualAge Generator/Smalltalk. Sibyl is no longer in development, but its successor, WDSibyl is now under Netlabs at http://svn.netlabs.org/wdsibyl/wiki. Now, the SOHO adventure begins... |
| Date: 13 Dec, 2006 on 22:07 |
|
|
Premium member in user
     posts: 54 since: 24 Jul, 2003 |
|
19. Re:Looking for >useful< database |
|
|
Terry (12 Dec, 2006 22:22): [2] The article also defines Lotus Approach as a "Local" database.Databases come in two basic flavors: * Local, or sometimes called "desktop" - designed to be accessed (only) on the machine where the database resides. Examples are dBase, Paradox, and Approach.
That is correct, however it is possible to connect to Approach using ODBC and using it as a multi user remote database, it's not an ideal application but a number of people do this when they need to convert an existing app to multi user and/or remote purposes. For new applications this would not be recommended since a good SQL would give you transaction control, what people tend to forget is that some of the open source SQL databases like My and M SQL do not offer transaction control and are thus no safer than Approach as a multi user database. |
| Date: 14 Dec, 2006 on 19:50 |
|
|
Normal member in user
       posts: 27 since: 15 May, 2003 |
|
20. Re:Looking for >useful< database |
|
|
El Vato (09 Dec, 2006 21:37): For a more current pure Java alternative, you may consider IBM's freely downloadable Cloudscape and/or open source Apache Derby. If you know DB2 SQL commands, you will find that you already know how to manage either of the above mentioned alternatives.
Thank you for the suggestion, but as with the rest of them... no GUI admin tool a very large NoNo when I need to configure/modify/administrate it myself. It may be very handy if it can be handled automatically with a rexx .cmd-file from the app-to-be later on though. I'll try out the older DBVisualizer 4.0.4 to see if it can make up for that, otherwise I have to ask you for some more suggestions. Mvh / MfG / Wkr //Jan-Erik |
| Date: 17 Dec, 2006 on 17:04 |
|
|
| Looking for >useful< database |
|
|
| All times are CET+1. |
< Prev. | P. 1 2 | Next > |
|