Data-aware Grid

Applications, Games, Tools, User libs and useful stuff coded in PureBasic
psyclops
New User
New User
Posts: 3
Joined: Wed Aug 19, 2020 8:49 am

Data-aware Grid

Post by psyclops »

This is an editable grid that I've been developing in pure PureBasic.

It is data-aware in that it sources its data from a database via a data provider. Currently there is only a SQLite data provider but other data providers can be developed for ODBC, MySQL etc.

It includes features such as:

- Master-Detail grids
- Fixed columns
- Popup editors such as for long text, date/time, and for populating foreign keys from other tables.
- A very basic hand written inline text editor, this was necessary as trying to overlap gadgets, yikes!
It can be used as a base for developing other inline editors.
- Column sorting (currently only one column at a time)
- Basic filtering
- Handles larger datasets by requesting records from the data provider as necessary, it does not request all records at once.

Some screenshots:

1. This shows two grids in master-detail.

Image


2. This shows the calendar popup editor for a date field.

Image


3. This shows the large text popup editor.

Image


4. This shows column sorting with an indicator in the top right of the column header.

Image


5. This shows the list of values popup editor for populating foreign keys. Two fields from the foreign key are used, firstly the primary key which is applied to the database and a more descriptive field such as name or description is shown to the user.

Image


6. This shows another example with filtering applied. It also shows fixed columns (enabled, first name, last name) and a checkbox field.

Image


7. This shows the insert record for creating new records.

Image
User avatar
NicTheQuick
Addict
Addict
Posts: 1223
Joined: Sun Jun 22, 2003 7:43 pm
Location: Germany, Saarbrücken
Contact:

Re: Data-aware Grid

Post by NicTheQuick »

You didn't add any link to the code or to test it out. Also does it work on Linux too?
The english grammar is freeware, you can use it freely - But it's not Open Source, i.e. you can not change it or publish it in altered way.
psyclops
New User
New User
Posts: 3
Joined: Wed Aug 19, 2020 8:49 am

Re: Data-aware Grid

Post by psyclops »

I haven't posted the code or a test sample as it is still work in progress. It should work on Linux with a bit testing and tweaking as I'm not using any platform specific code.
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 636
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: Data-aware Grid

Post by captain_skank »

Looks good.

A few q's if i may :

1. is it DPI aware ?
2. is it a module ?
3. does it have variable row heights ?

Cheers
psyclops
New User
New User
Posts: 3
Joined: Wed Aug 19, 2020 8:49 am

Re: Data-aware Grid

Post by psyclops »

Thanks for the good questions!

1. I haven't tested DPI aware yet.

2. Yes, it is modular, it is made up of a several modules. The grid can be extended using a "plugin" which is a module that listens to grid events.

3. Unfortunately no variable row heights at the moment. I did consider this but it was adding complexity to the grid functionality that I couldn't yet figure out. This should be a future improvement.

Cheers!
Mohsen

Re: Data-aware Grid

Post by Mohsen »

It seems interesting and useful, :) I am waiting for its release :wink:
dagcrack
Addict
Addict
Posts: 1868
Joined: Sun Mar 07, 2004 8:47 am
Location: Argentina
Contact:

Re: Data-aware Grid

Post by dagcrack »

No release?
! Black holes are where God divided by zero !
My little blog!
(Not for the faint hearted!)
BarryG
Addict
Addict
Posts: 3292
Joined: Thu Apr 18, 2019 8:17 am

Re: Data-aware Grid

Post by BarryG »

dagcrack wrote: Sun Sep 05, 2021 12:00 amNo release?
Doesn't look like he's around here anymore:

Image
Post Reply