webservices

CSV import and API: 2 news features!

Two new features have been rolled out, both having to do with getting data in and out of MyOwnDB. We're very excited about this! It is now possible to import data from a CSV file through a very simple procedure:
  1. upload your CSV file
  2. link columns in the CSV file to fields in your database table
  3. get an overview of the import: number of rows imported and number of rows rejected
Rows can be rejected due to data validation exceptions, for example:
  • trying to import text in an integer field
  • trying to import an invalid email add

Loud Thinking

I'm not lazy at writing neither I'm bad. But I do not have my personal blog! Because I wont be updating it much! Developing a REST API on top of MyOwnDB was our prime decision to make it integrate able to a number of products/services. And that way, we want to be the memory of Web 2.0! We've been working with the REST API for sometime now and it was a leap from a concept to its application to MyOwnDB within the Rails framework. We had to make many interesting design decisions and for that, I explored top ten REST API's available including Twiter, Google, Flicker and many more.

Some tricks to use S3 in your web application

After the post on my dojo.io.bind experience, here's what I learned in using S3. I'm using the S3 library for Ruby published by Amazon.

Uploads

When you save an entry with a file attached in MyOwnDB, the Rails action handling the form checks the size of the file. If it is within the limits allowed for the account, it saves the information needed locally in the database (let's say in the table "files"), and then saves the file on S3.
Syndicate content