Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
thezimguy wrote:gonpublic2k wrote:@theZimGuy - Is this a Point Of Sale project you're working on? From your screenshot I took a look and at a
glance it appears to be. Please let me know because I'm interested on developing one using MVD.
Cheers!
Please find attached.
To use this project, pls dont forget to create a mySQL database first.
You can install xampp and access it phpMyAdmin to do that.
Import the zims.sql after you create the database.
Provide the database settings when prompted.
Example
Server(Host) : localhost
Port : 3306
User : root (default)
Password : (empty default)
Database : zims (the name of the database you created)
Sorry for the delay
Trying to run your project in MVD 5.0 but it throw an error, see the attachment please
smoustafa wrote:Dear All
I found a free software called DB Browser for Sqlite databases. You should give it a try. It helps me to import my CSV files and more
As the web site says
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.
Controls and wizards are available for users to:
Create and compact database files
Create, define, modify and delete tables
Create, define and delete indexes
Browse, edit, add and delete records
Search records
Import and export records as text
Import and export tables from/to CSV files
Import and export databases from/to SQL dump files
Issue SQL queries and inspect the results
Examine a log of all SQL commands issued by the application
To download it Pls go to the web site
http://sqlitebrowser.org/
Best Regards for ALL
Tools that I use for SQLite:
Valentina Studio (the best for me, there is a free version)
SQLite Expert Profressional (there is also a free version)(for windows only)
Navicat Premium (it let you convert from sqlite to mysql or sql server)(for windows, mac, linux)
SQLite Studio (free)(multiplatform)
Ok thanks I saw the link, thanks, sadly my DB is not compatible since de PK are named different and FK also,
Is this feature planned?
Currently I'm programmer for a big web project (EHR system) and was thinking to use MVD to do the desktop application, again my db is not compatible since my PK are named different
MVD is a great piece of software but it lacks some features out of the box:
- Ability to recognize existent MySQL or SQLite databases (created outside of MVD)
- Ability to create menus (I already saw solutions that include modifying scripts), it would great to have a menu editor
- Ability to create toolbars
- Ability to create MDI applications rather than just SDI apps
- Ability to set a different charset other than the default utf8 since this is a partial implementation of UTF8, the correct one is the utf8mb4 with the best collation utf8_unicode_ci (utf8_general_ci produces odd sorting)
Again MVD have great potential and if this features are planned I think it would be a complete system maybe a RAD
I have been playing with tables.ini file that is generated with mvd, it could be great if you could read an existent db schema a generate tables.ini
Hello there, one way to achieve this is with NGROK https://ngrok.com/, it exposes a local port to internet, so you can share your mysql server to a remote client without a public ip
Currently I want to work with a mysql database that already contains data, I want to use MVD to make a small program that generates a report, however, I can not make MVD recognize the tables that already exist.
Posts found: 5