Basic mode

Data Designer basic mode is meant for users with no database experience!

I hope this video helps especially those plugin users with no database experience to create their own database tables and use these tables in other plugin tools to publish and manage their data.

Are you new the database modelling? Start reading here…

Are you an experienced database developer? Read how the plugin can help you to execute SQL script files directly from the dashboard…

Still stuck? How can we help?

Updated on 2025-02-10

8 Comments

Hien Doan on 2021-03-10 at 7:42 pm

I use Vietnamese and Chinese characters. I would like to create a lookup table with 2 fields, field 1 is the characters before : and field 2 is everything after the :
I define both fields as varchar type but they don’t show up correctly. Is there a column type to display Vietnamese and Chinese characters?

Here is the sample:
Ác hoá 惡化: Biến thành xấu kém, trở thành xấu.

Thanks,
Hien Doan
Reply
- Peter Schulz on 2021-03-12 at 1:47 pm
  
  Does anyone know this? I have absolutely no idea! Sorry Hien…
  
  Thanks,
  Peter
  Reply
Amy on 2021-10-08 at 4:19 pm

I am struggling with the CREATE table command. It keeps telling me that I have improper SQL syntax. I admit to being very new, but from what I can tell I have good code (plus, I used the advanced designer to make it). So is my database wrong somehow? I put a query in at the support tab but hadn’t heard back yet and thought I would bug you here.

Thanks
Reply
- Peter Schulz on 2021-10-09 at 10:48 am
  
  Sorry my late reply Amy,
  
  I answered your email. Just didn’t come to it earlier. Thanks for being so patient and not giving up! 🙂
  
  Best regards,
  Peter
  Reply
Peter de Pradines on 2022-03-18 at 3:01 pm

It would be appreciated if your videos reflected the new interface layout. Those of us just joining are having to learn two different IDEs – one for work and another for learning [from the old videos]. Do you have plans to update these anytime soon, please? I have great hopes for this software.
Best wishes, Peter
Sent: 16:00m
Friday 18 Mar 2022
Reply
- Peter Schulz on 2022-03-19 at 8:17 am
  
  Good point Peter! 🙂
  
  Let me answer your question first:
  Yes, I do have plans to update the whole tutorial and demo sections. I absolutely see the need!
  
  There are some new features and changes on my to do list that I want to finish first. Otherwise we’ll have outdated tutorial after the updates again. Time is my constraint!
  
  To anyone reading this:
  Please contact me if you have the time, knowledge and skills to create WP Data Access tutorials. I can really use your help! A compensation is possible.
  
  Thank you for contribution Peter,
  Peter 😉
  Reply
Robby on 2023-06-07 at 2:09 pm

Hi There

I want to get premium but I am testing. I cant get my Tables to show the data added. I can see the data in the table on the sql editor but my tables are empty in my view. Any help to get me going or do i need to purchase the Premium first
Reply
- Kim Leong on 2023-06-07 at 3:39 pm
  
  Hi Robby,
  
  Where are you viewing your table?
  
  You can also send us a message here Contact so we can take a closer look at your issue.
  
  We’ll wait for your message!
  Reply

Submit a Comment Cancel reply