bb.donnay-software.com

Donnay Software Web Forums
It is currently Sat May 30, 2020 11:58 pm

All times are UTC - 7 hours




Post new topic Reply to topic  [ 11 posts ]  Go to page 1, 2  Next
Author Message
PostPosted: Wed May 08, 2019 9:34 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
If you use eXpress++ build 266 or later, you are a candidate to be a beta tester for build 267 and SqlQuery.

I received very good responses from those who attended our gathering here in Boise, Idaho this May.
They are excited about being beta-testers for the next build of eXpress++ and are already incorporating many of the new features into their existing applications.

For this to be a successful rollout in August, beta testers must be serious about wanting these features in their applications now, not in August.

Let me know if you wish to be a beta tester for eXpress++ build 267 and SqlQuery.
I will be working on a YouTube video that shows the features.
I hope to have this ready next week.

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Wed May 08, 2019 9:37 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 10:27 am
Posts: 130
Location: NYC
Roger,

I'm on board!

Bobby


Top
 Profile  
 
PostPosted: Wed May 08, 2019 11:25 am 
Offline

Joined: Sat May 11, 2013 3:46 pm
Posts: 13
I'm on board!

Richard


Top
 Profile  
 
PostPosted: Wed May 08, 2019 1:18 pm 
Offline

Joined: Thu Jan 28, 2010 7:07 am
Posts: 612
Location: Alachua, Florida USA
Kibitzer in charge here.. :)

_________________
Brian Wolfsohn
Retired and traveling around the country to music festivals in my RV.
OOPS.. Corona Virus, so NOT travelling around the country right now...
http://www.breadmanrises.com
FB travel group: The Breadman Rises


Top
 Profile  
 
PostPosted: Fri May 10, 2019 5:23 am 
Offline
User avatar

Joined: Tue Jul 28, 2015 5:15 am
Posts: 94
I´m doing an overhaul of my app and it´s the perfect time to fully stress the SqlQuery possibilities.

I´m in.

Alexandre


Top
 Profile  
 
PostPosted: Fri May 10, 2019 12:46 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
BTW SqlQuery is included free with an eXpress++ subscription.

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Fri May 10, 2019 2:19 pm 
Offline

Joined: Sun Jan 31, 2010 11:25 am
Posts: 64
Yes; of course I'm willing to Beta test. As long as you are prepared for my silly questions. :)

Bob Volz


Top
 Profile  
 
PostPosted: Fri May 10, 2019 3:04 pm 
Offline
User avatar

Joined: Thu Jan 28, 2010 10:27 am
Posts: 130
Location: NYC
Other than Tim, the Beta-testers are all here.

Bobby


Top
 Profile  
 
PostPosted: Sat May 11, 2019 1:17 am 
Offline
User avatar

Joined: Tue Feb 09, 2010 3:06 am
Posts: 131
I already have some things in PostGree SQL remote.
Of course DBFs have their days counted.
All the work to develop in SQL is very important and already comes a little late.
I will follow this topic with great interest and if I can i will make my contribution.

_________________
Pedro Alexandre


Top
 Profile  
 
PostPosted: Sat May 11, 2019 9:02 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
Quote:
All the work to develop in SQL is very important and already comes a little late.


Yes, much of it is coming late, but mostly that is the fault of Alaska Software telling everyone to wait for PGDBE.
They started talking about this back in 2008, at my eXpress++ conference in Boise.

At that time, I was already working in SQL with ADSDBE.
I had a customer with a very large application originally written in Clipper.
It became an enterprise-level application with 350 workstations and 25 stores all connected to a single application.
I helped him convert the application to Xbase++ and built a framework that would combine the best features of ISAM and SQL.
This was soon after Sybase bought Extended Systems and they created Advantage Streamline SQL.

I tried to promote this idea back then but never got any backup from Alaska Software because they were developing their own SQL solution and it still does not work as well as ADSDBE, ODBCDBE or SqlExpress (3rd party product).

I think that PostGreSql is a good idea (mostly because it's free), but it was available in Xbase++ years ago via ODBCDBE or SqlExpress.

Alaska talked a lot about incorporating SqlLite into the language to provide SQL without the requirement of a server.
That is still not available, yet we have been able to do this for over a decade using ADSDBE and Local Server (adsloc32.dll).

I agree that it is late, but it is not too late.
That is why I have been working on the SqlQuery project.

Many of my customers must maintain and grow their existing applications and they are finding it harder and harder to find Xbase++ programmers to write and maintain code. However, there are a plethora of programmers who know how to work in SQL and they can be a valuable addition to the development team.

SQL also is a simple fix to some data problems that are arising in legacy applications because the data set is growing too large to work reliably any more.

A case in point is Bobby Drakos taxi application which was failing on a regular basis several years ago due to the thousands of transactions that had to be added every day to a database. The old ISAM code could not keep up with the application in real time.
By rewriting the code to use SQL INSERT statements instead of Lock - append - write -unlock (the old way), there has never been another failure. Using SQL to archive old transactions and reduce the size of the file from 20gb to 10gb (annually) took minutes rather than hours and could even be done without shutting down the application.

I welcome you who have large applications using DBF files to get on board with ADSDBE. You don't need to change any of your code to get started. It will work better than before and it will give you a starting point for learning SQL. It will also allow programmers who work in any language to develop applications, reports or web interfaces that work with your DBF data.

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ]  Go to page 1, 2  Next

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group