The missing link : Database creator would make Wappler a true App Builder

When I use wappler or dmx zone I find myself wasting tons and tons of time back tracking.

Plainly put you cannot experiment with your design and database in realtime.

For example say you make a form that updates a record and you need another table or even another column/field in your table… you have to break your concentration go into your database software and create the table or column/field… then fool around with wappler or dmxzone extensions to you get something…working…

What needs to happen is that as I design forms fields or create them… the field/column needs to be automatically created in the database…if I deleted the field the column/field should be deleted in the database . We should not even need to go into a third party program or know that there is a database there (so to speak)… it should be seemless. The other features are awesome in wappler… especially the serverside extensions/plugins…

wappler is not a CRUD only app generator :slightly_smiling_face:
what you need is already available in other tools. but here we have freedom!

I think it was mentioned that something like this might be included in Wappler at some point. I expect it might be quite a popular feature - which might be a good reason for including it.

Personally, I would prefer that the Wappler developers concentrated on features which are not already catered for by third-party programs. There are lots of features which are not yet included, or at least not documented. For Wappler to get the widespread interest and following it deserves, it needs to compete with lots of other frameworks (Angular, Vue.js, ReactJS etc., as well as the PHP frameworks). None of these (as far as I know) offer what you suggest, but I don’t think with any of them the reply to a question is never ‘this is not yet possible with xxx.js’). This reply appears quite often in the DMX forums - and probably applies still to Wappler. I don’t think people suggest that any of the other frameworks are lacking because they don’t manage the database side of things.

I think it would be a huge task to develop really good tools to manage all of the databases supported by Wappler (MySQL, SQLite, MS SQL Server etc.) - and such tools already exist. I use MySQL for websites and use Navicat to manage these databases. It’s excellent software. The same company develops software to manage many databases.

Also, should it be such a simple task to add a new field anyway, given you may need to consider type, length, indexes and other constraints? I think your suggestion is a little like suggesting that Wappler should incorporate image-editing software. Perhaps it could, however there is adequate third-party software available.

Thats’ the winning combination of software I use … Wappler and Navicat.

You have basically already done this with wappler…refactor the program into a database like the video program Davinci resolve… we should not have to create a database when we create the app or the web page… because the project is the DATABASE. I am now adjusting to the logic which is basically php but it is still tediuos…10 times easier then trying to learn each function and nuance. And I am no php expert… but I am learning the flow of php with wappler… in essense you have create a database or encylopedia of php /asp code snippets that I do not have to remember or really even know how it works…(how visual programming should be) but I am repeating myself a lot with the logic and flow. You are doing a great job… and this is just a feature Request… you are doing nothing wrong. You guys are great. And the support is great! :grinning: and I am recommending Wappler to everyone I know.

What I just suggested has not even been created(livecode almost has this…they are just are missing the database piece which I am a trying to build with livecode). I do not have time to sit around and write code for the web and server side. That is why I bought wappler. Wappler team has effectively programmed all the server side syntax in php and asp to programmable snippets that we can create serverside apps a remarkable feat. It’s just a widget that does this in the background so I can save myself a few extra steps…keep all the others and cheers to your freedom…more time is all I seek.

Actually we have this planned as a Database Creator in Wappler. So you will be able to create database structures and meta data directly in Wappler!

This will be also very useful for the mobile app or when client side database are required because those databases need to be created on the fly for each user.

That said - the Database Creator is indeed a large undertaking so we will do it once we implemented all the base components, so it has a bit lower priority right now

2 Likes

Any updates on a database creator?

4 Likes

I personally don’t think I would use it. I just don’t see it being able to do it as easily and efficiently as Navicat. I could be wrong though.

1 Like

Also very interested in the database creator!

1 Like

We will be working on it this summer. It is a complex matter but very needed not only when using hosting but also for local databases when building apps.

So we want to get it right and we’ll in Wappler visual way style.

1 Like

Something licke „kickstarting“ a DB would be nice. I mean to be honest, mostly we have for user DB‘s each time the same columns like ID, name, lastname, birthday, city, etc etc.

Also for products some stuff are similar. But maybe it could be done more „generic“ like speaking of objects instead of products or articles. And maybe at the end some „customization“ could help, where a user just could change rows etc. What about to have some kickstart snippets from community driven library? So all these projects which are done on wappler could be shared in SOME parts.

So somebody could just put his „addressbook kickstart db“ into that wappler community (:star::star::star: Star Rated) asset folder?

Here my old link for Snippet Library. So that feature could be merged together and increase community shared snippets a lot!

Thanks George, I can image it is a difficult feature

@brad, thanks, will try Navicat