Yes. SQLite is good. I blogged about it as a format for open data sometime
back
https://thejeshgn.com/2012/08/23/sqlite-open-format-for-open-data/
May be its time to do SQL for Poets kind of workshop for who are
interested.
--
Thejesh GN ⏚ ತೇಜೇಶ್ ಜಿ.ಎನ್
http://thejeshgn.com
GPG ID : 0xBFFC8DD3C06DD6B0
On May 26, 2014 8:23 AM, Raphael Susewind li...@raphael-susewind.de
wrote:
Dear all,
for complex files, I would suggest SQLite (sqlite.org). It is open,
scalable, and extremely rich due to SQL queries. I use it for all my
more complex datasets, interlinked tables, etc...
My five cents,
Raphael
On 26.05.2014 06:50, Dilip Damle wrote:
Hello,
I think we need to discuss the following
1. When is the data eligible to go to Repository
There could be several factors here. Mainly cleanliness and completeness.
2. Place other than Repository for temporary data.
I think it should surely not be only an attachment to a post here
Then it becomes difficult to find later
Administrators should decide on suitable place
3. The particular formats itself
This could vary based on type of data
My observations is that for many types of data Multiple Linked Tables
serve better than a single CSV file which is more common.
In this case is .mdb acceptable or is there any other open format for
linked tables.
this could be a long topic...
4. Compressing multiple files in one file
Unless there is a reason multiple files that go together should be
bundled in to one file.
This should also be true for repository.
5. About the content itself
Since multiple people will contribute/edit to data we will have to have
some rules.
example : when there is a Unique for the data it should always be used
otherwise combining comparing the data becomes difficult.
( presently I am trying to collate the election results data and find
there are differences in the different sources especially in the Names
of places. Will be putting up the collated data in .mdb format in a few
days)
On Friday, May 23, 2014 10:06:35 AM UTC+5:30, Nisha Thompson wrote:
In the discussion guidelines thread Dilip suggested we have some
data sharing guidelines and a place to store some of the more casual
datasets, people are cleaning up.
I think its a good idea.
Can we use this thread as a place to discuss formats, procedure, and
a good place to put it.
We have a github already set up, we can start with that, maybe
create a project called - Data that needs to be cleaned up.
Any other suggestions?
Nisha
--
Nisha Thompson
DataMeet.org
ni...@datameet.org javascript:
skype: nishaqt
mobile: 962-061-2245
--
Datameet is a community of Data Science enthusiasts in India. Know more
about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google
Groups datameet group.
To unsubscribe from this group and stop receiving emails from it, send
an email to datameet+unsubscr...@googlegroups.com
mailto:datameet+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Raphael Susewind | BGHS Bielefeld University, CSASP University of Oxford
Snail Mail | Melanchthonstr. 4a, 33615 Bielefeld, Germany
Web Twitter | http://www.raphael-susewind.de | @RaphaelSusewind
Please do consider http://www.gnupg.org for encryption (key id A5ED49AE)
--
Datameet is a community of Data Science enthusiasts in India. Know more
about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups
datameet group.
To unsubscribe from this group and stop receiving emails from it, send an
email to datameet+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Datameet is a community of Data Science enthusiasts in India. Know more about
us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups
datameet group.
To unsubscribe from this group and stop receiving emails from it, send an email
to datameet+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.