SQLLite Opensource editor
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- VIP Livecode Opensource Backer
- Posts: 24
- Joined: Mon Jan 16, 2012 10:39 am
- Location: Maryland USA
- Contact:
SQLLite Opensource editor
I was looking for a way to open the database and be able to view the data and create SQLLite databases. I came across: http://sourceforge.net/projects/sqliteb ... source=dlp
Thought I should share.
Thought I should share.
-
- VIP Livecode Opensource Backer
- Posts: 1236
- Joined: Sat Apr 08, 2006 1:10 pm
- Location: Zurich
- Contact:
Re: SQLLite Opensource editor
I use the firefox add-on:
https://addons.mozilla.org/en-US/firefo ... e-manager/
https://addons.mozilla.org/en-US/firefo ... e-manager/
Various teststacks and stuff:
http://bjoernke.com
Chat with other RunRev developers:
chat.freenode.net:6666 #livecode
http://bjoernke.com
Chat with other RunRev developers:
chat.freenode.net:6666 #livecode
-
- Livecode Opensource Backer
- Posts: 66
- Joined: Fri Mar 15, 2013 3:54 pm
- Location: Jackson Hole, Wyoming, USA
Re: SQLLite Opensource editor
Thanks for the suggestions. I have downloaded and made my own two-dimensional contacts database using the Navicat demo. For someone pretty unfamiliar with SQL, I'm surprised I managed to do that without reading the instructions. Quite a bit of flailing was involved.
I will check out the Firefox add-on, it sounds pretty simple… Eventually I want to be able to do relational links as we have in FileMaker.
Here's a thought: since I already know how, it would be great to be able to set up my tables and relationships in FileMaker, and then import that structure into SQLite or MySQL. With or without data, either would be fine. A quick Google did not answer if this is possible
I will check out the Firefox add-on, it sounds pretty simple… Eventually I want to be able to do relational links as we have in FileMaker.
Here's a thought: since I already know how, it would be great to be able to set up my tables and relationships in FileMaker, and then import that structure into SQLite or MySQL. With or without data, either would be fine. A quick Google did not answer if this is possible
-
- VIP Livecode Opensource Backer
- Posts: 1236
- Joined: Sat Apr 08, 2006 1:10 pm
- Location: Zurich
- Contact:
Re: SQLLite Opensource editor
You'd probably need some software.. There's a guy who writes filemaker export and import software with LC, maybe he has a hint for you:
http://www.fmpromigrator.com
http://www.fmpromigrator.com
Various teststacks and stuff:
http://bjoernke.com
Chat with other RunRev developers:
chat.freenode.net:6666 #livecode
http://bjoernke.com
Chat with other RunRev developers:
chat.freenode.net:6666 #livecode
-
- Livecode Opensource Backer
- Posts: 66
- Joined: Fri Mar 15, 2013 3:54 pm
- Location: Jackson Hole, Wyoming, USA
Re: SQLLite Opensource editor
Thanks, I've looked at that in the past. It's overkill for what I want and it's $400. I could ask the developer for a hint as you say, but I've started reading up about SQL so I guess I'll just proceed that way.BvG wrote:You'd probably need some software.. There's a guy who writes filemaker export and import software with LC, maybe he has a hint for you:
http://www.fmpromigrator.com
-
- VIP Livecode Opensource Backer
- Posts: 9857
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: SQLLite Opensource editor
IMO that's the best way to go. SQLite is a very capable toolkit, well worth learning. And if you're going to use it you'll have to get to know it anyway, so making your own tools to view tables, records, etc. is a great learning experience that will accelerate your understanding of SQLite.cavenewt wrote:...I've started reading up about SQL so I guess I'll just proceed that way.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn