Timeline for Can SQLite and SpatialLite files be linked
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 4, 2020 at 8:04 | comment | added | AndrewM | I use dbeaver as a database manager. This will do the job for you. I also still use ms-access quite a lot and there are a couple of modules and dlls that you can use to import sqlite data into ms-access. I use Geopaparazzi or Smash over Qfield and these application also use sqlite or spatialite for data storage. I am a botanist so the use case would be very similar. The modules is called sqlite4access. It works well in 32bit access, not sure if it works in 64 bit access. Ms-access is good for forms, Dbeaver is good for interactive use. | |
| Oct 30, 2020 at 18:55 | comment | added | aae | Seven years later, I am really interested in your final solution, @AndrewM. I basically want users of QGIS projects stored in Geopackages) to use a taxonomic database and a vegetation database. Both are stored in SQLite databases, and data collection from QGIS/QFIELD would be my aim. I'd appreciate suggestions where to start looking for projects which do this to learn from them. | |
| Sep 12, 2013 at 6:21 | comment | added | AndrewM | I also found a commercial solution SQLite Expert Professional which has a GUI for attaching SQLite databases to the current database. It uses the Attach command as @Luke points out. | |
| Sep 11, 2013 at 5:50 | comment | added | BradHards | This should be fine. Are you having trouble with something? | |
| Sep 11, 2013 at 5:34 | answer | added | AndreJ | timeline score: 2 | |
| Sep 11, 2013 at 4:37 | comment | added | user2856 | You can link SQLite DBs using sql - stackoverflow.com/questions/6824717/… | |
| Sep 11, 2013 at 4:30 | history | edited | AndrewM | CC BY-SA 3.0 |
clarify questions and add Spatialite to heading.
|
| Sep 11, 2013 at 1:00 | history | asked | AndrewM | CC BY-SA 3.0 |