Database Designer (in development)

[Emily-Elizabeth]

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]

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]

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]

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

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]

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]

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]

- 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]

- 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