Those of you that don't use Wappler's database manager, what do you use?

Wappler General
1

Those of you that don't use Wappler's database manager, what do you use to sync development and production table structures?

In a Wappler website I have to access a DB that was made outside Wappler, and need some way to sync whatever table changes happen in the production DB to development, so I don't have to toy with a production DB in development...

2

I do use it BUT also use Mysql Workbench for some tasks and occasionally HeidiSql.

3

Can you not connect the wappler dbmanager?

If you connect then refresh the schema inside wappler it will read the database structure etc
From there,you can use it to replicate changes.

4

Yes, but that's a manual process, I need something that can run reliably & repeatedly not prone to human mistakes

5

If you use the wappler publish process it does the database update automatically at the same time.

Note sure any product can do any more than that.
What are you thinking of, db structure changes triggered by something like a development database change.
That actually sounds dangerous to me. Too much could go wrong.

6

I'm not sure if you understood my context, I'll try to clarify:

  1. I have a Wappler website (project A) with its own database
  2. I have another application (project B) with its own database
  3. I want my Wappler website to be able to access project B database
  4. My Wappler website doesn't perform any structure changes to project B database, so the Publish button shouldn't change any DB structure in project B
  5. In Development, I want to clone the structure of the project B database to a local DB, to be used by my Wappler website during development
  6. I want to repeatedly ensure my local DB schema of project B matches production's project B database, sync if needed (Sync from Production schema to Development, not the inverse)

Does that look good or do you have a better idea?

7

Hi Apple,

I use DataGrip by JetBrains (a paid product). It offers connectors for a wide range of databases, and can perform comparisons between databases and can also execute schema update queries if required.

8

I use Navicat for all my database needs. I don't trust my ability/knowledge with the database manager. Been using Navicat for almost 25 years now.

4 Likes
9

Like @brad, I use Navicat, though I've only been using it for a mere 17 years. I think you could do what you want by creating a schedule to run a job which synchronises the schema (though I haven't tried it).

10

I've been using HeidiSQL for over a decade now, it's excellent.

1 Like
11

I'm also a Navicat user. Not sure for how many years, though!

I also use phpMyAdmin.

1 Like
12

outcast here..... Microsoft Sql management studio....

13

Same here. Navicat for MySql.

1 Like
14

I also use management studio for the MSSQL databases.

15

phpmyadmin and navicat... as i have a WAMP server setup... and use PHP most of the time.. and i prefer connecting to the database and view the data in a separate browser window.. nice to import other data from clients sites ... as i dont always have a project setup but i always have different databases that i need to get data from..

i have made to many "crucial" mistakes when uploading my project.. publishing stuff that i should not have.... SO all manual now.. lol i know it defeats the complete point of what the Team has achieved.. BUT I DONT TRUST MYSELF........ :slight_smile: :wink:

so i always do manual update via FTP.. and run the SQL manually for updates on the live servers.....

1 Like
16

Yep, use a lot of views in Navicat. Builder a really simplifies things.

1 Like
17

MySQL Workbench.

I carefully create numbered update files and document them for a specific code base.

I use lots of Views, and I can’t create those the Wappler.

1 Like
18

Navicat for over a decade. HeidiSQL for Postgres and Mariadb on rare occassions.

Never felt the need to learn Wappler's DM since my solution was working as needed.

19

We use replication to do this. Fail safe as only replicating remote to local. For all things remote we use Workbench or SSH directly in to the MySQL console.

Quick Google search brings up a simple script (there are plenty out there and am sure one of the LLMs could write you one specific to your needs). This script is a little old but not much changes in regards to replication so should work fine. This is remote to local but can just as easily have one instance replicate to any other (or multiple) regardless of location remote or local...

20

I use DBSchema for modeling etc and Postico comes in handy for every day quick mainuplation. I work with Postgres databases. Both are paid licensees. Postico is cheap onetime purchase and I purchased DBSchema perpetual years back and it is $50/year to get updated versions. I really like both of these products. For Postgres pgAdmin is also pretty good,