Dear Dada community,
Greetings. I haven't seen if/how one might import an existing cvs or sqlite database into the dada.base object. If this is possible, could someone tell me or point to where in the documentation I could learn?
Many thanks!
Doug
Importing databases
-
danieleghisi
- Site Admin
- Posts: 1349
- Joined: Fri Dec 03, 2010 1:25 pm
Re: Importing databases
Hi doug,
there's definitely some import function missing; importing CSV would be indeed handy. But in dada columns are typed, so one would have to infer automatically the type from the content. Nothing impossible, but we need some thinking on that.
However notice that if you create a little patch that does that "by hand" (see below), but you need to create your table with the appropriate columns before.
Hope this helps.
<pre><code>
----------begin_max5_patcher----------
1719.3oc0ZsrbihCEcs8WAE0rziKjP3GypdVMqlUyxzc4RXjsUOfDERjNY5p
+2GgDfAa.q3.tRRUARjDb04benqtneNelaH+Ehv04ObdxY1reNe1LcSEMLq7
+m4lfeYeLVnGlKi7Cd32cWX5RRdQpaV75RQZLU570utnpSVdBOWFSj5mDT1p
oI4qoDiXccc9VYWoX49ST1wcYj8RSuA99K8V3..AE2B.EWgvkd0OCMRKe0b5
2QaaHYJqVvEs8q4yKtrvRTtmmjPXxqf4q7bm8XlStf37UFkIjDbT0nhoLxdd
NSOTXmjfW+HEsxqARAA5+q.8cB0MiFT6Qgl5n0m6JXBrXLUo9U.EUbaKbPU5
ptwYy2NIqDckval6AZL4YRlfxYMF8LWbZZilm03QJ3juy0unMKpahxLM4U2T
F4YZ0yGT2JNSgQoBf4YZFv8kUH2yuFdDIikSqUPZsS4TRqGX3DhHEu27vEpq
ptOyZZNSeYEReCsw6LmoTxGi46+WRTy4qKOknLRSyHBkwLVVNwq6Nhb.mGK2
cfyjB5+oEOnPezQ+GJmdc1YA.zy8+Lihiqm8GynQbVwjnkZnn4Jw8jSk8dSv
nGACm1wCqrJTbROcJTfLWDhyJzRgwjFNhJSaNOtcW0OWL4frr6TJicAKJ4o8
2YF83oAd1Ptpyjgd25dD6xYld2oLHj6D3may1RbbbomZ6W+KXFMAKIRpQE.8
p6jvvJfdRrOiGG2BulddtidhTF36I+fFIOoETSiA0vooUFQt0Z4H5QhP1tMI
9nncKB4qFRuQS4gkNv6jjjzXEJZOfVKN0zasYLsVsOTrs1w2Bw6Os7fRlNeQ
E9xIo4f5LJ2Mhz0WzNHBZru0qisc6kQ6tJhG7hYxUQ8Lbmx.IZmwYXGVJyng
4RCYM6JRYlaYXO0qKzDtbiGvCVO.8RFs+KyBHiLoSkb7cRzzhkUsjq2rVGfz
6lbsWubs+igPzVgI3TRLIw4KpmJhjJO4.5mjfCZMtvBKRSlEfUHysfawR9q6
kkfe5sH0J.SlqHzMCELZjObi4F3lje+gCfOFFBK4z6zmMlJj1xHdd14y5CdH
9r525TslPPCr5Wes2nTndQrWiNp1xRyUP0uIVD4kF4dNJziAy8yOd1P.v0nk
9PuBGeyOf0VwGAVsB4cwGmSAsXyb8j6gFPE82MQI34Y6qrEpLYcZCGUxTRJq
Ni7mN6rWLPqTTu4YAz1Yw5IbVTrjq8yBvTwEku7aNKPSoFAYqFohzllYAxVM
BXJsNWaKWDz6rnrwpMWeqLR948rwF0trCwwkaaodaucrum4mmbiSAYjNwNwc
WGFXu0gYgk0hAoSFDtcYv.0hAL00bRmLVZlJUem+9e9K22ZEz7W6aJLhEEVx
2avBKYooy.IwdWp9gJ6n3DOONxAGo90QVr+cmePU6UPdh3jlwSIYN64w4ILm
BC.gSH4.OibBy5t9j9uU1MPmxpeY5ZlaqV0fcCyCUSJAMpYYWJasI21PK.Gu
J1lPDB7QxUTmhuLjUxql6OsT8y2T.ReeTqUslgPkUrNvaH6O35NQNbzclHoD
l1pQYWk8ZEKLlvFtwfajA2qWOHtCdH3VlgYho.jdZzc8llagQzGwXKCQWYjm
c.S.c4uwyB5x+yFc8cNkMErUUwAPCRWvt8f93RWrFUzZb9BRa0gZfqrwYD7Y
itnR0R4WWKvKXN+Ay46V48A8MQo2ZpCkYIqdoPuOaTnHltmzGyc+YKCLYVBW
ooq0ClfIX6mnnZQ3H7xPrfbGLVHlczlnaAdA21aErdxSHTmAryuAlfOoMDnq
mavvP7wjAzwLdd5XhwJieypSq1NHF+zsjdLgcTd5MxWM+lTCs65Ml3ECd3U.
vOhTlRHR9aMWmaGQ.AJJzPYn.T00NokZ+zTbFNgnVabm4qW2b6pSVvhLBNZj
iUT5GY.OZP2nUOjHE0e9whO9EKYhVzDXJrOvePDi9HloQTFOs3HEMUoS.pNo
WJ6g9JW0CozaZq8ufyk76J2oa52WYJ3Ud.vFNf3iLdndBz9a9XHyKqicIkdU
8qgAMqecO0tFzpH2t7rHyjpa8nshF07aYzWUyWctp42ufVYAFQfwPR.avz4O
Pz6SP2TsAGAHYkAhuW2FHduOQu9MXa99jDxBIACFCI4aijPigjf1HI+QPR.q
vDXRLQrwOPyDuWOth8EeSWan2Xn37rESODEmF3idvefUq6LJVm13G.FCeazC
CRVE8eLDjMKbNBxY0CBO1XuecFGljrt3P3WHhKN78Wbv6u9P22+At+xCau9r
.z2gre9ul++.IZzVD
-----------end_max5_patcher-----------
</code></pre>
there's definitely some import function missing; importing CSV would be indeed handy. But in dada columns are typed, so one would have to infer automatically the type from the content. Nothing impossible, but we need some thinking on that.
However notice that if you create a little patch that does that "by hand" (see below), but you need to create your table with the appropriate columns before.
Hope this helps.
<pre><code>
----------begin_max5_patcher----------
1719.3oc0ZsrbihCEcs8WAE0rziKjP3GypdVMqlUyxzc4RXjsUOfDERjNY5p
+2GgDfAa.q3.tRRUARjDb04benqtneNelaH+Ehv04ObdxY1reNe1LcSEMLq7
+m4lfeYeLVnGlKi7Cd32cWX5RRdQpaV75RQZLU570utnpSVdBOWFSj5mDT1p
oI4qoDiXccc9VYWoX49ST1wcYj8RSuA99K8V3..AE2B.EWgvkd0OCMRKe0b5
2QaaHYJqVvEs8q4yKtrvRTtmmjPXxqf4q7bm8XlStf37UFkIjDbT0nhoLxdd
NSOTXmjfW+HEsxqARAA5+q.8cB0MiFT6Qgl5n0m6JXBrXLUo9U.EUbaKbPU5
ptwYy2NIqDckval6AZL4YRlfxYMF8LWbZZilm03QJ3juy0unMKpahxLM4U2T
F4YZ0yGT2JNSgQoBf4YZFv8kUH2yuFdDIikSqUPZsS4TRqGX3DhHEu27vEpq
ptOyZZNSeYEReCsw6LmoTxGi46+WRTy4qKOknLRSyHBkwLVVNwq6Nhb.mGK2
cfyjB5+oEOnPezQ+GJmdc1YA.zy8+Lihiqm8GynQbVwjnkZnn4Jw8jSk8dSv
nGACm1wCqrJTbROcJTfLWDhyJzRgwjFNhJSaNOtcW0OWL4frr6TJicAKJ4o8
2YF83oAd1Ptpyjgd25dD6xYld2oLHj6D3may1RbbbomZ6W+KXFMAKIRpQE.8
p6jvvJfdRrOiGG2BulddtidhTF36I+fFIOoETSiA0vooUFQt0Z4H5QhP1tMI
9nncKB4qFRuQS4gkNv6jjjzXEJZOfVKN0zasYLsVsOTrs1w2Bw6Os7fRlNeQ
E9xIo4f5LJ2Mhz0WzNHBZru0qisc6kQ6tJhG7hYxUQ8Lbmx.IZmwYXGVJyng
4RCYM6JRYlaYXO0qKzDtbiGvCVO.8RFs+KyBHiLoSkb7cRzzhkUsjq2rVGfz
6lbsWubs+igPzVgI3TRLIw4KpmJhjJO4.5mjfCZMtvBKRSlEfUHysfawR9q6
kkfe5sH0J.SlqHzMCELZjObi4F3lje+gCfOFFBK4z6zmMlJj1xHdd14y5CdH
9r525TslPPCr5Wes2nTndQrWiNp1xRyUP0uIVD4kF4dNJziAy8yOd1P.v0nk
9PuBGeyOf0VwGAVsB4cwGmSAsXyb8j6gFPE82MQI34Y6qrEpLYcZCGUxTRJq
Ni7mN6rWLPqTTu4YAz1Yw5IbVTrjq8yBvTwEku7aNKPSoFAYqFohzllYAxVM
BXJsNWaKWDz6rnrwpMWeqLR948rwF0trCwwkaaodaucrum4mmbiSAYjNwNwc
WGFXu0gYgk0hAoSFDtcYv.0hAL00bRmLVZlJUem+9e9K22ZEz7W6aJLhEEVx
2avBKYooy.IwdWp9gJ6n3DOONxAGo90QVr+cmePU6UPdh3jlwSIYN64w4ILm
BC.gSH4.OibBy5t9j9uU1MPmxpeY5ZlaqV0fcCyCUSJAMpYYWJasI21PK.Gu
J1lPDB7QxUTmhuLjUxql6OsT8y2T.ReeTqUslgPkUrNvaH6O35NQNbzclHoD
l1pQYWk8ZEKLlvFtwfajA2qWOHtCdH3VlgYho.jdZzc8llagQzGwXKCQWYjm
c.S.c4uwyB5x+yFc8cNkMErUUwAPCRWvt8f93RWrFUzZb9BRa0gZfqrwYD7Y
itnR0R4WWKvKXN+Ay46V48A8MQo2ZpCkYIqdoPuOaTnHltmzGyc+YKCLYVBW
ooq0ClfIX6mnnZQ3H7xPrfbGLVHlczlnaAdA21aErdxSHTmAryuAlfOoMDnq
mavvP7wjAzwLdd5XhwJieypSq1NHF+zsjdLgcTd5MxWM+lTCs65Ml3ECd3U.
vOhTlRHR9aMWmaGQ.AJJzPYn.T00NokZ+zTbFNgnVabm4qW2b6pSVvhLBNZj
iUT5GY.OZP2nUOjHE0e9whO9EKYhVzDXJrOvePDi9HloQTFOs3HEMUoS.pNo
WJ6g9JW0CozaZq8ufyk76J2oa52WYJ3Ud.vFNf3iLdndBz9a9XHyKqicIkdU
8qgAMqecO0tFzpH2t7rHyjpa8nshF07aYzWUyWctp42ufVYAFQfwPR.avz4O
Pz6SP2TsAGAHYkAhuW2FHduOQu9MXa99jDxBIACFCI4aijPigjf1HI+QPR.q
vDXRLQrwOPyDuWOth8EeSWan2Xn37rESODEmF3idvefUq6LJVm13G.FCeazC
CRVE8eLDjMKbNBxY0CBO1XuecFGljrt3P3WHhKN78Wbv6u9P22+At+xCau9r
.z2gre9ul++.IZzVD
-----------end_max5_patcher-----------
</code></pre>
Re: Importing databases
This is great. Thank you!
Doug
Doug