Comments (9)
Why not just store in sqlite blobs?
from grout.
Sidecar sqlite files? That way you avoid requiring another tool.
from grout.
Sorry, I realized I hadn't pushed an update that sought to clarify this. If you look at the table structure for the tile_level table
now you should see you can store as blobs in the database.
My question was: should we have a way to store them outside the database too?
from grout.
Outside the database could be outside of the main database. In other words have a single master database with child databases. This is pretty much the same as putting them in a zip file except you don't need to switch between sqlite and zip mode in your code.
from grout.
Yes, sqlite sidecar files would be a good alternative.
from grout.
I'm good with all SQLite and master/child tables
from grout.
From Tom MacWright
table structure would look like tilesets -> tile_level -> tile_table{0..23}
? Seems like the number of tables could rapidly increase if you had (tilesets)x(zoomlevels + 2) tables in a database.
Is there a good way to support master/child SQLite databases, but limit the table growth?
from grout.
If I understand it correctly the intention is to partition on tile level right? I don't think that's the best partitioning scheme though since the upper levels are very small and the lower levels are very big. Partitioning on spatial extent seems like a better idea. In other words, move branches of the quad tree to separate files rather than entire levels.
from grout.
I really like this idea. Would you be able to help me define how this would work?
from grout.
Related Issues (5)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from grout.