Database Designer (in development)

A place for you to show off what you have made with LiveCode

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Database Designer (in development)

Post by Emily-Elizabeth » Thu Mar 02, 2023 4:52 am

This is still in development, but if anyone is brave enough to test it out, here is the beginning of a graphical database designer. Right now it only does SQLite and is Mac only (the source code is available for those that want to try Windows or Linux, I just haven't tested against them yet).

When the application launches, a window with three buttons appears:
"Start Libraries" - not needed in the standalone, clicking does nothing
"Create Blank Template" - start a new database designer file
"OpenFile" - opens an existing database designer file

When you create a blank template, you will be placed in edit mode where you can add labels and fields. Labels are not stored in the database. Double-click either a label or a field to have it place in the editor. When you change the name of a field, press Return/Enter to make the change stick. Once you have all the labels and fields you want, switch to Browse mode.

You can now add records using the "+" button. Use the "-" button to delete a record (there is no warning message, so please make sure). The other buttons are as follows:
"F" - move to the first record
"P" - move to the previous record
"N" - move to the next record
"L" - move to the last record
You can jump to a record by changing the current record number and pressing the return/enter key.

Any feedback is appreciated. This is released under the GPL conditions of the community version of LiveCode (I forgot to include the license in the archive)

Download link:
https://github.com/emily-elizabeth/Data ... g/20230301

dunbarx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 9567
Joined: Wed May 06, 2009 2:28 pm
Location: New York, NY

Re: Database Designer (in development)

Post by dunbarx » Thu Mar 02, 2023 3:00 pm

Emily.

On my Mac. The downloaded stack was reported to be "damaged". The dialog that said that had the option to "remove to the trash".

Craig

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Thu Mar 02, 2023 5:23 pm

Type in “sudo xattr -cr [space]” and drag and drop your application on Terminal window then hit Enter followed by amin password. Right click and Open from contextual menu.

Guess I will have to code sign future releases so we don't need to have to do that.

stam
Posts: 2599
Joined: Sun Jun 04, 2006 9:39 pm
Location: London, UK

Re: Database Designer (in development)

Post by stam » Fri Mar 03, 2023 12:21 am

Hi Emily-Elizabeth,
While it does work as advertised, the interface is a bit trying...
Had go at the standalone - it actually took me a long time to locate the "+" button
ddd.jpg
Also took several minutes to realise that to add fields/lables you have to double click on the text in the right panel. But works...

Are you planning to add a facility to graphically manage the database structure itself (tables, relationships etc)?

S.

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Fri Mar 03, 2023 4:54 am

stam wrote:
Fri Mar 03, 2023 12:21 am
Are you planning to add a facility to graphically manage the database structure itself (tables, relationships etc)?
Sorry for the late reply, I was at work.

I'm just learning about databases, SQL and the revDatabase commands/functions, so I'm not too certain if it is something I want to tackle. My primary goal for this was an easy to use simple database creator for people who want to create a database of "stuff" but don't have the time to learn SQL. Hopefully I'm on the right track.

Thanks for your feedback, I'll look in to getting some icons created to replace the text navigation, so hopefully that'll help.

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Fri Mar 10, 2023 7:24 pm

A new update has been released with some fixes and a Windows version has been released as well.

- supports Unicode
- can now use the arrow keys to move the labels and fields
- updated current record to display 0 if no records in the database
- fixed issue with navigation being disabled when opening a file
- fixed an issue with submitting data with single quotes inline
- fixed issue with losing place when switching from edit back to browse mode
- fixed issue with updating data in a field

https://github.com/emily-elizabeth/Data ... g/20230310

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Fri Mar 17, 2023 7:01 pm

- changes to the startup: hides the "Start Libraries" button in the standalone
- changes to the startup: RawKeyDown events are passed in the development environment
- added scrolling field object
- added picture object (supports JPEG and PNG)
- changes to the table name: now uses the hardcoded "dbdMainTable"
- added icons for macOS and Windows (application and document)

The macOS version is not code-signed and you may need to run the following code in the terminal:

Code: Select all

sudo xattr -cr 
(drag and drop the application to get the full path)
Enter the amin password. Right click and Open from contextual menu

https://github.com/emily-elizabeth/Data ... g/20230317

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Sat Mar 25, 2023 1:15 am

- updated icon
- deleting a column now prompts
- deleting a record now prompts
- drop column for sqlite

The macOS version is not code-signed and you may need to run the following code in the terminal:

Code: Select all

sudo xattr -cr 
(drag and drop the application to get the full path)
Enter the amin password. Right click and Open from contextual menu

https://github.com/emily-elizabeth/Data ... g/20230324

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Mon Apr 03, 2023 2:14 am

- fixed picture drag drop bug
- added checkboxes

The macOS version is not code-signed and you may need to run the following code in the terminal:
sudo xattr -cr (drag and drop the application to get the full path)
Enter the amin password. Right click and Open from contextual menu

https://github.com/emily-elizabeth/Data ... g/20230402

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Mon Apr 10, 2023 3:54 am

- guidelines to help line up interface elements
- background colour changes when in edit mode
- double-clicking a picture object will allow you to import an image
- objects get saved when in edit mode, no longer have to switch to browse mode
- Real data type for fields
- Linux version
- bug fixes

The macOS version is not code-signed and you may need to run the following code in the terminal:
sudo xattr -cr (drag and drop the application to get the full path)
Enter the amin password. Right click and Open from contextual menu

https://github.com/emily-elizabeth/Data ... g/20230409

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Fri May 26, 2023 8:28 pm

Went live with this program and it's now listed at Softpedia, with a nice review.
https://www.softpedia.com/get/Internet/ ... er-E.shtml

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 9801
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Database Designer (in development)

Post by FourthWorld » Fri May 26, 2023 9:27 pm

Well done. Congrats.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Fri May 26, 2023 10:45 pm

Thank you.

jiml
Posts: 336
Joined: Sat Dec 09, 2006 1:27 am
Location: Los Angeles

Re: Database Designer (in development)

Post by jiml » Sun May 28, 2023 12:40 am

Emily-Elizabeth,

Brava!

JimL

Emily-Elizabeth
Posts: 101
Joined: Mon Jan 03, 2022 7:10 pm

Re: Database Designer (in development)

Post by Emily-Elizabeth » Sun May 28, 2023 4:15 am

Thank you JimL :D

Post Reply

Return to “Made With LiveCode”