SQLLite Opensource editor

[fredotechGA2742]

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.

[BvG]

I use the firefox add-on:
https://addons.mozilla.org/en-US/firefo ... e-manager/

[cavenewt]

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

[BvG]

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

[cavenewt]

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

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.

[FourthWorld]

...I've started reading up about SQL so I guess I'll just proceed that way.

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.