Quote:
I am posting this question and just wanna know your feedback.
What features of Progress do you like and unlike most? Why? |
Just off the cuff:
1. Solid as granite. I haven't had a Progress DB cark itself in the last
10-15 years, probably not since the early V7 days.
2. Almost non-existent administration overhead. Just set up auto-switch AI
scripts, do auto backups, do a compaction when you feel like it -- perhaps
once a year. One of my clients runs about 500 online users on a
Progress-based ERP, and DB administration has been managed by one person for
the last 3 years. This person also has been the primary application
developer during that time.
3. The 4GL has been a wonderful thing. The language sets up implicit
bindings between the database contents and application variables with an
elegance that SQL will never achieve. It allows server-based processing
that is very fast and efficient with resources. Variable length fields and
distinction between NULL and "" are very nice features of the 4GL, although
I am now tending to spend my time on the SQL side of the fence.
4. The database performance and capacity compare favorably with Oracle and
MS SQL Server.
In my experience Progress kills both Oracle and MS SQL Server on the
administration point (the same site that I mentioned above needs 3 Oracle
DBAs to handle another ERP application with fewer users). SQL server
databases seem to need reboots and cleanups on a regular basis, or they
start producing lots of errors.
What would I like to see?
* Visual tools with the features of SQL Server's DB Adminstrator and Query
tools.
* A Type 4 pure Java JDBC interface for cleaner, simpler deployment.
* Auto-ID columns (OE10 perhaps? I haven't looked yet).
I'm sure I'll think of more great features as soon as I post this