Editing Database Data with the new Database Manager

The new Database Manager in Wappler just got more great powers! Now you can edit directly your live table data! You can choose between saving the data directly in the database or as a "change" that will be grouped together with any other database schema changes.

This way you can manage fully your database schema, but also make sure the right data is populated initially with the schema changes apply.

Also we have added a possibility to generate “Seeds” from the data of any database table. Seeds are used to do initial data import. So use them to save your database table data and then use it as import to a new database or database at a different target.

Editing Database Data

To edit the data of any database table, just click right on it to call the context menu and then choose View/Edit Data:
image

This will open a new dialog, showing empty initially.

You can change the number of records to display, apply filters or just click on “Fetch Data” to get the database table record. Depending on your chaices you will see your table data

This grid works much like a spreadsheet, you just double click a column cell to edit its data.
Note columns containing the table ID are not editable.

So double click on the second column to go into inline edit mode:
image

When you leave the field, you will see that the data has been changed:

image

You can choose to add complete new records or delete the selected:
image

If you have too much columns to display, you can control which columns are displayed in the grid:
image

Saving The Data Mutations

If the table you are working on already exists in the database, you can save your edits directly, by clicking on the “Save” button

Saving directly to the Database

image

This will result in the live data being changed with your edits or record deletes.

This is useful for initially populating your tables with some data, but in a live environment might be dangerous as you are editing the database directly.

Those edits are one time only and can’t be just repeated.

Saving as Database Changes

However there is another useful option “Save Changes” that won’t apply your edits directly to the database, but instead queue them as “changes” that you can save later as new Database Changes file!

image

You can close the dialog and you will see that the changes are queued for processing:
image

This is particular handy when you want to make some database schema changes and then also add some initial data with them. This way you have and the database schema edits and the new data together in a single “change” file that can be applied to your current database or later to your remote live database to keep everything in sync.

Creating Data Seeds

Sometimes it is useful to take a copy from the data of any table and keep it as backup for later. Or to be applied as initial “seed” data on new databases. This is where “seeds” come in place.

To create a data seed - just right click on any table that you want to save its data and choose Create Seed:

image

A new dialog will popup to enter a description for your seed and choose the data dumping options.

image

the “Clear Previous Data” option means that when this data is imported to a database, any previous data from the table will be cleared first.

Applying / Importing the Seed Data

All your database seeds are saved under the “Seeds” branch in your Database Structure:

image

To run a specific seed, you can just right click on it, to get its context menu and then choose “Apply yhis Seed”

image

This will apply the seed to the currently selected database. Note if you had the option “Clear Previous Data” on - then the table will be cleared first and the new data will be added after that. So be careful where you apply the seed or you might loose data!

If you are curious about how the seed file looks like, you can just choose the “Open In Editor” options:

image

Then the source code for this seed will be opened in Wappler’s editor:

Conclusion

As you can see live data manipulation in Wappler can be really easy with the new Database Manager.
With options to save your data changes together with schema changes, makes database migrations and upgrades really easy and save.
Seeds can be also very useful for data backup and initial import.

4 Likes

Wonderful release and great additions to the DB Manager. I haven’t tried yet this version but I see that the cell color tick chosen for the “changed field” in edit data view is going to create some disturbance in the force.

Due to the dark theme I would suggest choosing another color like yellow, orange or in between those.

2 Likes