pysimplesql icon indicating copy to clipboard operation
pysimplesql copied to clipboard
verified publisher icon PySimpleSQL

Readme

Open ssweber opened this issue 2 years ago • 3 comments

Are you ok if I chip away at reorganizing the readme and adding screenshots/short animated gifs for the features? I plan on adding a linked-table of contents. I will keep in my branch and then if you like, move over.

Short getting started: Sql (with fk, update/delete cascade) + layout = gui

Features

  • Design user interfaces with automatic relationship handling - parent/child linking, cascade description

  • Dynamic comboboxes - add

  • Sortable tables - gif of sorting action

  • Customizable button themes - show full list, possibly make an alternative look to include. Themepacks

  • Localization - LanguagePacks

  • Edit protection - toggle edit protect gif

  • Prompt Save / autosave modes. gif showing popup on record change

  • Fields:

  • Pre-populate new record windows with database-defined defaults - gif w/ side-by-side sql gist

  • Display 'required' markers - gif w/ side-by-side sql gist

  • Automatically fill in not-null fields based on column data types. gif w/ side by side sql gist

Advanced topics: Data transforms - code, maybe show database values side by side Callbacks - edit protect example Event mapping ??

Working with Databases Sqldriver ResultSet

Explanations of behind-the-scenes All your great explanations of how it pysimplesql automatically does things behind the scenes.

ssweber avatar Mar 23 '23 16:03 ssweber

Absolutely, if you have time and want to dig into it that would be great

On Thu, Mar 23, 2023, 12:56 PM ssweber @.***> wrote:

Are you ok if I chip away at reorganizing the readme and adding screenshots/short animated gifs for the features? I plan on adding a linked-table of contents. I will keep in my branch and then if you like, move over.

Short getting started: Sql (with fk, update/delete cascade) + layout = gui

Features

Design user interfaces with automatic relationship handling - parent/child linking, cascade description

Dynamic comboboxes - add

Sortable tables - gif of sorting action

Customizable button themes - show full list, possibly make an alternative look to include. Themepacks

Localization - LanguagePacks

Edit protection - toggle edit protect gif

Prompt Save / autosave modes. gif showing popup on record change

Fields:

Pre-populate new record windows with database-defined defaults - gif w/ side-by-side sql gist

Display 'required' markers - gif w/ side-by-side sql gist

Automatically fill in not-null fields based on column data types. gif w/ side by side sql gist

Advanced topics: Data transforms - code, maybe show database values side by side Callbacks - edit protect example Event mapping ??

Working with Databases Sqldriver ResultSet

Explanations of behind-the-scenes All your great explanations of how it pysimplesql automatically does things behind the scenes.

— Reply to this email directly, view it on GitHub https://github.com/PySimpleSQL/pysimplesql/issues/198, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQX2REQHCT7OKJWXESBODN3W5R6EXANCNFSM6AAAAAAWFPFUB4 . You are receiving this because you are subscribed to this thread.Message ID: @.***>

PySimpleSQL avatar Mar 24 '23 19:03 PySimpleSQL

I haven’t forgotten about this, just got a little side-tracked with black/ruff. I plan on doing some this weekend.

ssweber avatar Mar 31 '23 22:03 ssweber

putting this here for brain-storming how to present a short landing-page readme.

pysimplesql top-5 features:

  1. Binds PySimpleGUI widgets to your data, via specialized SqlDrivers
  2. Creates an internal model of database tables. No need to redefine, just point at an existing db or provide sql to create.
  3. Pre-made buttons for common Form actions - Lock / Save / (First/Previous/Next/Last) / Duplicate / New / Delete
  4. Automatic relationship handling: select a record, and linked/dependent records are re-queried and their widgets updated.
  5. Populates Combo Dropdowns and Table widgets with information extracted from Relationship data. Eg. Store a parent_id key as 1, but display as their name.

New features in Development branch:

  • Data managed as Pandas Dataframes
  • Enhanced Table widget: Sort columns, edit cells, filter via search, lazily load rows.
  • Enhanced widgets. Add placeholders to Input/Multiline. Autocomplete combobox.
  • Live update. Edit a cell and individual widgets will update (and vise-versa).
  • Validate while typing, on save, or both! Specialized ColumnClasses are extendable with additional validation constraints.

ssweber avatar Sep 21 '23 17:09 ssweber