www.myowndb.com - code http://www.myowndb.com/taxonomy/term/3/0 en CSV import and API: 2 news features! http://www.myowndb.com/blog/p/45 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: <ol> <li>upload your CSV file</li> <li>link columns in the CSV file to fields in your database table</li> <li>get an overview of the import: number of rows imported and number of rows rejected</li> </ol> Rows can be rejected due to data validation exceptions, for example: <ul> <li>trying to import text in an integer field</li> <li>trying to import an invalid email add<p><a href="http://www.myowndb.com/blog/p/45" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/45#comments code dedomenon feature javascript News webservices Thu, 26 Mar 2009 15:26:22 +0000 rb 42 at http://www.myowndb.com Freedom in the cloud http://www.myowndb.com/blog/p/32 <p> Richard Stallman, the founder of the Free Software Foundation, launched a <a href="http://www.clipperz.com/users/marco/blog/2008/05/30/freedom_and_privacy_cloud_call_action">call for action concerning freedom and privacy in the cloud</a>. </p><p><a href="http://www.myowndb.com/blog/p/32" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/32#comments agpl code freedom News open source Tue, 01 Jul 2008 17:09:32 +0000 bbbart 31 at http://www.myowndb.com Javascript closures illustration http://www.myowndb.com/blog/p/24 <strong><em><a href="http://www.jackslocum.com/yui/">Jack Slocum</a> mentioned in a comment the problem comes from the creation of a global variable. When you create a local variable, you don't get the problematic behaviour. Thanks Jack for taking the time to correct me.</em> </strong> <h2>Intro</h2> Here is the illustration of a bug that was present in version 0.1 of the <a href="http://www.myowndb.com/slideshow/">yui slideshow</a>.<p><a href="http://www.myowndb.com/blog/p/24" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/24#comments code javascript Sat, 30 Sep 2006 17:07:40 +0000 rb 24 at http://www.myowndb.com YUI based slideshow http://www.myowndb.com/blog/p/23 As I wanted to add a slideshow on the <a href="/">MyOwnDB</a> homepage, I started looking for a ready made solution, but as I didn't find exactly what I wanted, but also because I was curious of how it could be done, I started coding one based on <a href="http://developer.yahoo.com/yui/">YUI</a>.<p><a href="http://www.myowndb.com/blog/p/23" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/23#comments ajax code javascript Sat, 30 Sep 2006 13:58:51 +0000 rb 23 at http://www.myowndb.com Remember to reset the YUI listeners on updated content http://www.myowndb.com/blog/p/22 I had event listeners set on elements added dynamically to the page not working: <pre> <div id="c">my original content <a href="#" id="test_link">Click here to replace content</a></div> <script type="text/javascript"> YAHOO.namespace("raphinou"); YAHOO.raphinou.new_content = '<a href="#" id="undo_link">Click here to display original content</a>'; YAHOO.util.Event.addListener("test_link",'click',change_content); YAHOO.util.Event.addListener("undo_link",'click',reverse_content); </script> </pre> When you click on the <em>test_link</em>, the content of the div is <p><a href="http://www.myowndb.com/blog/p/22" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/22#comments ajax code javascript Fri, 01 Sep 2006 21:13:17 +0000 rb 22 at http://www.myowndb.com Mass mailing with active mailer http://www.myowndb.com/blog/p/20 So, you have plenty of users, and you want to notify them of a significant update. You have all recipient emails in you database, and the corresponding ActiveRecord models. Rails also provides the nice ActiveMailer tool. Writing a script using all your existing infrastructure seems the best solution, and it's also how I wanted to send an anoucement to <a href="/">MyOwnDB</a> subscribers. There are, however, two points that you need to take into account: <ul> <li>you can't simply loop over all emails, and for each address open a connection to the SMTP server.<p><a href="http://www.myowndb.com/blog/p/20" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/20#comments code rails Wed, 09 Aug 2006 10:57:50 +0000 rb 20 at http://www.myowndb.com Some tricks to use S3 in your web application http://www.myowndb.com/blog/p/19 After the post on my dojo.io.bind experience, here's what I learned in using S3. I'm using the S3 library for <a href="http://www.ruby-lang.org">Ruby</a> published by Amazon. <h2>Uploads</h2> When you save an entry with a file attached in <a href="http://www.myowndb.com">MyOwnDB</a>, 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.<p><a href="http://www.myowndb.com/blog/p/19" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/19#comments code rails webservices Tue, 25 Jul 2006 17:55:29 +0000 rb 19 at http://www.myowndb.com File uploads to Amazon S3 the AJAX way thanks to Dojo http://www.myowndb.com/blog/p/16 File uploads are finally deployed! You can now specify in MyOwnDB that a detail of your entity is of the type "file". This will let you attach a file to an entry, and subsequently replace or delete it. This required some changes in the application, more specifically in the way the forms are submitted back to the server. For a file upload to work fine, you have to send it with the enctype attribute set to "multipart/form-data". But that's not all! You cannot just serialize the form in javascript like you can do with other input types because you cannot access the file from Javascript.<p><a href="http://www.myowndb.com/blog/p/16" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/16#comments ajax code javascript rails Wed, 19 Jul 2006 18:41:27 +0000 rb 17 at http://www.myowndb.com Use of Yahoo UI's tooltip and overlay http://www.myowndb.com/blog/p/15 Monday has seen a big update of the signup code, with, amongst other changes, the use of the <a href="http://developer.yahoo.com/yui/">Yahoo UI</a> libs. Although prototype is well integrated with rails, Yahoo's extensive documentation and the praise it got from some <a href="http://www.dustindiaz.com/">leading javascript developers</a> got me interested, and I must say I wasn't disappointed. When you <a href="http://sourceforge.net/projects/yui">download</a> the distribution and uncompress it, you get a directory structure.<p><a href="http://www.myowndb.com/blog/p/15" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/15#comments code javascript Wed, 07 Jun 2006 19:16:16 +0000 rb 16 at http://www.myowndb.com Sending HEAD requests using Amazon's S3 Ruby lib http://www.myowndb.com/blog/p/14 After some usage of <a href="http://www.amazon.com/s3">Amazon's S3</a> storage service from Ruby, I'm quite happy with the result obtained.<p><a href="http://www.myowndb.com/blog/p/14" target="_blank">read more</a></p> http://www.myowndb.com/blog/p/14#comments code rails Sun, 21 May 2006 18:07:19 +0000 rb 15 at http://www.myowndb.com