Readme #198

Activity

1. PySimpleSQL commented on Mar 24, 2023

   

   PySimpleSQL

   on Mar 24, 2023 via email

   Owner

   More actions

   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 <#198>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AQX2REQHCT7OKJWXESBODN3W5R6EXANCNFSM6AAAAAAWFPFUB4> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>
2. ssweber commented on Mar 31, 2023

   

   ssweber

   on Mar 31, 2023

   CollaboratorAuthor

   More actions

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

   

   ssweber

   on Sep 21, 2023

   CollaboratorAuthor

   More actions

   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.