search

emily-elizabeth / Database-Designer

Visual database designer for SQLite and MySQL
GNU General Public License v3.0
11 stars 0 forks source link

postgresql support #8

Open emily-elizabeth opened 1 year ago

emily-elizabeth commented 1 year ago

allow the use of postgresql as a backend

justinclift commented 1 year ago

When you say "as a backend", are you meaning as a way to save the designed database forms in a central location?

If that's the case, it might also be interesting to try saving to some Cloud type service. I'll point at the one I'm working on (https://dbhub.io), but there are plenty of others too. :smile:

emily-elizabeth commented 1 year ago

The designed database forms are saved locally, but the database will be stored on a PostGreSQL server running somewhere (either locally or remotely).

justinclift commented 1 year ago

Ahh, standard backend database storage. Got it. :smile:

The Livecode thing seems interesting. Hadn't come across it before, but it seems potentially nifty for cross-platform rapid prototyping.

Doing a search on the Livecode (.com) -> Resources -> API docs for sql says it has a custom library that supports connections to MySQL, PostgreSQL, , Valentina, and Oracle (LiveCode Enterprise only) databases.

Weird that it doesn't mention SQLite in there. Maybe it's the missing field in that string? :smile:

Hmmm, their Working with Databases page instead says they support SQLite, PostgreSQL, and MySQL. With support for ODBC too. Seems like a pretty standard feature set, so shouldn't be too difficult to make work. :smile:

emily-elizabeth commented 1 year ago

well, I'm a newb at all this, so it's just trying to figure out how to add it to the interface that is still simple for other newbs, like myself, to use ;-)

one nice thing about it, only the connection command is different, all the other commands stay the same so no need to rewrite any parts of the program

justinclift commented 1 year ago

Cool. Looks like you've picked a nifty idea for a project too. :smile:

I'll put aside some time to download and try experimenting with LiveCode, and see if I can make sense of it and do anything useful. :grin:

emily-elizabeth commented 1 year ago

The old GPL version of LiveCode is available on archive.org https://archive.org/search?query=creator%3A%22LiveCode%2C+Inc.%22 Free is always good :)

justinclift commented 1 year ago

Heh Heh Heh. Is that the one you're using?

I'll try and match what you've got, so I can try loading your project too. :smile:

emily-elizabeth commented 1 year ago

I use LiveCode Community 9.6.3 to do the coding

justinclift commented 1 year ago

Thanks, I'll give that a go. :smile:

emily-elizabeth commented 1 year ago

I'm in Ontario, Canada and I'm usually active on the weekends. I wish I had the freedom to be a little more active other times, but that's a "perk" of being a peon ;-)

justinclift commented 1 year ago

Sorry I haven't followed up with this. Stuff with my own main project has really kicked up a notch, so that's where my focus is for now. :innocent: