George's Demo of Database Manager at our First User Gathering

Videos
#12

Staggering.

#13

Database Manager is amazing…

… but for me, I’m still not convinced I will use it. Here are the reasons why:

  1. I am creating one app in my lifetime, so I will never have a new project to start using it on.
  2. All my database is already defined in one .sql file with all the documentation, which has become my “database world”. I feel too comfortable in that world to move unless there is a compelling reason.
  3. Updates to a production database are often much more than just “Add a new column”. That column may need different values depending on other column’s values, so you start to need SQL statements to migrate, and understandably, the knex / database manager world doesn’t offer that. So unless someone can convince me otherwise, I will be needing to manage sql files to do migrations, and I want a single point of defining what my database migration looks like.

So for those reasons, my current plan is to stay in my familiar MySQL world for database management.

Best wishes,

Antony.

#14

Wrong, misleading at best, from the moment that knex allows you to add whatever logic you need in the migration files.

You can pretty much create your own migration file and add it to the migrations database of Wappler.
And the database manager could potentially facilitate that by adding an option to “Create my own migration” and handle the internal part of adding it to the right folder and adding the appropriate entries in the migrations database.

With all due respect. You are using 2020 tools with a 2000(and I am being generous) mindset/workflow. That makes me sad :cry:

2 Likes
#15

Thank you for your caring Jon! :slight_smile:

I see it slightly differently… I am actually much more like you (in terms of place on your infamous bell curve) than you (currently) give me credit for… but I am enjoying the process of us getting to know each other.

The reason I say “the knex / database manager world doesn’t offer that.” is because I asked George the direct question about seeding columns conditionally in the demo (which you can watch), and he replied that this isn’t planned to be available via Wappler.

It may be available via knex… I’ve not had time to absorb all their documentation!

So if:

  1. Wappler adds a way to directly edit knex files
  2. I find time to learn the syntax
  3. It seems so much better than editing sql files
  4. I choose to move my entire one time database over to Wappler
  5. I find the time to actually investigate all this stuff because I am trying to release a product to earn a living

Then yes, anything is possible! :rocket:

#16

Actually I already showed in my demo how to open the changes files (Knex migrations) in the editor.

So you can change them and add data population as you wish :slight_smile:

Will see if we can combine that as well we the making seeds for initial population.

2 Likes
#17

@JonL, would you be willing to do a talk on the power of knex in database migration at our next user gathering? :slight_smile:

Bring me in to the 2020s man! :boom:

#18

That is true George… but I have been gently guided by your team to try and move away from editing Wappler created files, so I’ve been trying to walk more of your path! :slight_smile:

But I can start to see the potential benefits of using knex if it is as powerful as Jon says.

For me, I have created my database definitions… I want a tool that has the power to manage the migrations on a huge production database with 1000s of users whose entire business depends on the data I am managing for them.

I wanted to start the user gatherings to get more discussion on the deep details of what is possible… so I’m delighted we are having these conversations!

#19

And with Wappler - what is impossible today - might be possible tomorrow :slight_smile:

6 Likes
#20

It will depend on when it is, my workload and the toddler. I can’t promise anything.

Forum interaction matches better my style of life.

1 Like
#21

Promise me you will start ditching stored procedures asap! :joy:

1 Like
#22

I think George should do monthly demo video confs on some of these important components and how best to use it… will be very beneficial… Some of the topics coming to my mind:

  • bootstrap designing & template building with wappler
  • flow, sync/async nature of things, also using the new global variable
4 Likes
#23

this was fantastic. thanks Antony. thanks George.

1 Like
#24

8 posts were split to a new topic: Simulate a Magento Database with new Database Manager

#25

Thanks!

#26

Hi George and thank you very much for that very useful video!

I am very happy to hear what’s coming next to the database manager, as for the ability to simplify or even automate some process (ex.: Validation directly within the database manager) and also the data view rendering in database manager or the global configuration to name a few. I was just going to ask you if it was planed to make some more automated process via database manager and I got my answer from that video :slight_smile:

1 Like
#27

@Antony, thanks for organizing and posting this brilliant demo. I learned so much from this! @George, thanks for doing this demo and giving some insight in to the roadmap ahead. It reinforces my decision to switch to Wappler from Bubble a month ago. Such a powerful, flexible tool and still getting better.

Allan

3 Likes
#28

I can’t believe that was 8 months ago! The plan was to do a monthly gathering or a quick demo showing the latest features and the continuing roadmap. Could this idea be resurrected? Would absolutely love that.

3 Likes
#29

Hi everyone…

I’m really sorry, but this video was stored in my Zoom account which I downgraded last month and I’ve now realised that it has caused this video to no longer be available.

I’ll upgrade the account again in a few month’s time, and hopefully it will reappear!

Sorry about this,
Antony.

#30

Hi Antony. Could you send it to me (PM me) and I’ll put it in my Google Drive and link to it?

#31

I think it has gone… :frowning:

Sorry! :disappointed_relieved: