@brad - I was like you. I introduced myself as 50/50 regarding the new database manager but once I saw @George demo it I was completely sold. Being able to keep the changes and implement them on any other targets is something no other tool has offered so the workflow between local and production is now completely sewn up.
“Hold our beers”
- Bundlers, automated testing and CI/CD pipelines
Hate resorting to this meme…but I couldn’t think of a better one.
Step by step, we are getting there
Indeed you are. And at a pace between 3 people I didn’t know it was possible.
Database Manager is amazing…
… but for me, I’m still not convinced I will use it. Here are the reasons why:
- I am creating one app in my lifetime, so I will never have a new project to start using it on.
- 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.
- 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.
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
Thank you for your caring Jon!
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!
- Wappler adds a way to directly edit knex files
- I find time to learn the syntax
- It seems so much better than editing sql files
- I choose to move my entire one time database over to Wappler
- 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!
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
Will see if we can combine that as well we the making seeds for initial population.
@JonL, would you be willing to do a talk on the power of knex in database migration at our next user gathering?
Bring me in to the 2020s man!
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!
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!
And with Wappler - what is impossible today - might be possible tomorrow
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.
Promise me you will start ditching stored procedures asap!
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
this was fantastic. thanks Antony. thanks George.
8 posts were split to a new topic: Simulate a Magento Database with new Database Manager