Database Views in Database Manager?

Feature Request
1

I can see my database views in the database manager but that is about it. Can't seem to edit or create new views in the database manager? Is this something that is still in the works for the future?

2 Likes
2

I recently attempted to connect to a MySQL view which was visible but no query results. Didn’t spend the time troubleshooting.

3

I create all my views in MySQL Workbench and add them all to the database from there.

Once added, I just need to refresh the database info from within the Database Query server action and it works just like any other database table…

2 Likes
4

I do the same with Navicat. My question was out of curiosity to what we can do with views in the Database Manager. SO, it appears that either we can’t do anything with views in DB Manager or that is something that is coming in the future.

I was just curious that’s all. No issue for those of us that use an external app for databases. But for people that do rely on the DB Manager it may be an issue.

1 Like
5

The views on the database manager are for use only. You can’t create them there yet.

1 Like
6

Thanks George, that’s what I was wondering. :beers:

7

Antonio do you have an example of how to do this?

8

Unfortunately you can’t build views in Wappler. I build mine in Navicat and then they are available in Wappler just like any other table.

9

Hi. Can we know what views are for?

10
11

If you are building a large crud app, I quickly discovered that views are an absolutely essential part of your design strategy.

They allow you to combine content from different database tables into what is effectively another pseudo table you can then use in a single query.

So if you have a display of client orders for example, you will have that information in separate tables such as clients, products, and orders.

In this case I would create a view I call view_orders which brings that information together and has all the text content I need to show on the front end.

Views also offer programming such as case statements which are really powerful.

In this way the processing load on the front end is less and the user experience is way faster for complex displays.

It is counter-intuitive if you’ve come from Bubble, where the back-end is so slow… but you soon realise that in the real world, the back-end is fast and the front-end is much slower!

1 Like
12

I have 54 tables with several foreign keys.
how do i import from Workbench to Wappler?

13

Add your connection information under global and then in the database manager just refresh schema.

I think there is a YouTube video for this on the Wappler YouTube channel.

1 Like
14

Thank you.

15

Hi Marco, did you get it figured out?

Add your connection to Globals here …

Screen Shot 2023-06-05 at 9.00.28 AM

Then in the database manager right click on tables and refresh schema right here …

Screen Shot 2023-06-05 at 9.00.55 AM
Screen Shot 2023-06-05 at 9.00.55 AM736×602 40.5 KB

1 Like
16

I’ll see it today :+1:t2:.

17

Is this something that can be changed to a feature request for Wappler 7?

Alternatively, the ability in query builder to join tables from two different databases. Currently I can only do this by creating the view in Navicat.

1 Like