What’s the best approach for browsing huge databases in Xojo?
Use paging. Use SQL limit function to limit the number of rows displayed at any given time.
I was afraid that the answer was that. Thank you.
Nobody wrote something like a DBGrid component with server-side cursor capabilities yet? I wish to use PostgreSQL.
With a server side cursor the data transfer would be only focused on the part being shown and we could move smoothly forward/backward.
Einhugurs data grid maybe ?
I’ve used it with some pretty darned big data sets
http://www.einhugur.com/Html/DataGrid/index.html
Don’t know how this works.
Could not find usual properties like query, cursorType, dataSource, etc
Online docs needs more details.
[quote=8671:@Ricardo Araujo]http://www.einhugur.com/Html/DataGrid/index.html
Don’t know how this works.
Could not find usual properties like query, cursorType, dataSource, etc
Online docs needs more details.[/quote]
You can download the demo and play with the examples. It’s been a while since I worked with it but I believe it works by getting the cursor and figuring out which items are visible in the control and pulling only that data from the cursor. I’ve seen it work with Valentina but I’m not sure about the standard recordset. It might very well depend upon the database you’re using.
I’ll take a look, but what I really wish is a server cursor for Postgre. This way I could implement my own simple browser for this server. As you told, right now we can only go forward paging.
I made a FR about it: https://forum.xojo.com/1242-can-t-walk-forward-back-in-a-postgresql-recordset