[V4RB] pgSQL4RB and CLI

[Kim Kohen]

G'day Ruslan,

> Okay, first of all I see talk about RB Binding. Yes we have no add  
> this in
> Valentina. And I should say nobody for years have ask us to  
> implement this.
> So you, Kim, like bindings?
••••
Bindings are a great idea but RB implements them poorly.  pgSQL4RB is  
a much, much better implementation of bindings.  Everyone who uses  
them raves about them.


> You really see advantages of this ?
••••
I do, certainly in speed, and especially for new users.

As best as I can tell, a pgSQL4RB cache is similar to a vCursor but  
easily created via the GUI and simple to bind to any control without  
code. It also makes it extremely easy to update multiple editfields,  
listboxes, popups from the same cache without code (other than a  
query).  I converted my MySQL app to postgres using pgSQL4RB in a  
couple of hours. I expect doing the same thing using Valentina's API  
will take several weeks of learning, testing and re-writing a _lot_  
of code (it's a big app).

Run through the pgSQL4RB tutorial in the Getting Started section of  
the manual (only takes 40 seconds!) and you'll see how well it  
works.  http://www.aliacta.com/download/Manual_pgSQL4RBv2_draft2.pdf

This is not to say Valentina doesn't work well or that Valentina  
should necessarily use this method, just that Valentina is not as  
easy as pgSQL4RB - the learning curve is a lot steeper - several  
hundred pages of user manuals would suggest this.

It's interesting Norman is now using a similar system for OpenBase -  
I didn't know that.


> Can you explain what you mean with CLI?
••••
Command line interface ala MySQL - load data etc which can be run  
from cron. Once again, probably not a highly requested feature but as  
someone who's used MySQL a bit, I always fall back to the CLI tools  
when I need to check something easily. All my MySQL backups are done  
via CLI tools and scripts.


cheers

kim