The answer is definitively no! There are no limitations :) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Barry Beattie Sent: Tuesday, 14 July 2009 11:33 AM To: [email protected] Subject: Re: SQL 'in' Silverlight
scratch that, you *are* talking about Client storage (phew!) "All that said, SQL servers are obviously useful and I would never say no to having one available to me direct from client code" a quick question regarding IsolatedStorage while I get up to speed with it .... is there any platform/OS limitations with using IsolatedStorage? (I'm assuming, and hoping, "no") On Tue, Jul 14, 2009 at 11:19 AM, Barry Beattie<[email protected]> wrote: > hang on .... you've lost me completely now... can u guys back up a little? > > is everyone talking about sending SQL/CRUD commands from a Silverlight > app back to the SERVER to execute? > > or are you talking about local data storage on the CLIENT (a la Google > Gears) and accessing it via the Silverlight app? > > > > > > > > On Tue, Jul 14, 2009 at 10:53 AM, Jordan > Knight<[email protected]> wrote: >> ISO storage is quite easy to use in Silverlight. Once you have a little read >> and write class that takes a filename then the rest is history. You can >> request more space etc (default is 10mb in browser and 25 oob - might have >> changed in RTW?) I've saved entire movies in to ISO storage in tests and >> played them back when offline and OOB - it works a treat. >> >> >> >> And for the SQL debate, Like I use SQL on the server even anymore, its all >> about linq baby. >> >> >> >> For starters, its sooo easy to build linq to xml using the semi fluent >> XDocument (fully supported in SL). >> >> >> >> Secondly Silverlight has the DataContractSerializer class - meaning you can >> pretty much dump any graph in to ISO storage rather easily. You can almost >> bet the data you want to serialise came from some form of service request, >> so the classes are usually quite susceptible to serialisation. REST services >> are even better (like Flickr)... cache the XML results straight to ISO. >> >> >> >> All that said, SQL servers are obviously useful and I would never say no to >> having one available to me direct from client code. Oh and I'd >> reaaaaaaalllly love to see SQL Spatial available on the client too :P >> >> >> >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Darren Neimke >> Sent: Monday, 13 July 2009 7:22 PM >> To: [email protected] >> Subject: Re: SQL 'in' Silverlight >> >> >> >>>> I still have a query as to why Isolated Storage + LINQ couldn't do all of >>>> the below >> >> >> >> Disclaimer: I haven't used Isolated Storage commercially since NET 2... >> >> >> >> Last I remember, Isolated Storage was a pig to work with in a reliable >> manner. It was limited by the amount of storage space that you had; it was >> difficult to properly ascertain the scope that you needed to work within; >> and it was unreliable that the data would be there next time your app >> started up. >> >> >> >> Question: Has all of this been addressed/fixed in subsequent NET releases? >> >> >> >> >> >> >> >> Kind Regards, >> >> Darren Neimke >> [email protected] >> mob: 0439 855 046 >> >> >> >> From: Scott Barnes >> >> Sent: Monday, July 13, 2009 4:33 PM >> >> To: [email protected] >> >> Subject: RE: SQL 'in' Silverlight >> >> >> >> Miguel, >> >> >> >> We should chat more when I'm in Melbourne on this. I still have a query as >> to why Isolated Storage + LINQ couldn't do all of the below? The only thing >> I can think of is maybe the way LINQ handles WHERE statements is from memory >> limited to one filter instead of multiple. Still multiple ISO's could solve >> the problem below? >> >> >> >> The only reason I ask is I'm trying to separate the difference between a >> basic CRUD storage cookie vs an indexable mini SQL database which you can >> really begin to do some offline aggregated views on. >> >> >> >> >> >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Miguel Madero >> Sent: Sunday, July 12, 2009 11:57 PM >> To: [email protected] >> Subject: Re: SQL 'in' Silverlight >> >> >> >> There're several scenarios, but some of the ones that come to my mind are: >> >> 1. The typicial not reliable connection like using your cellphone as a modem >> or a mobile broadband. I don't want my whole app to crash, I'd love to be >> able to click save and even start registering a new client, even close the >> browser go gome and submit my changes the next morning. RIA Services has a >> good solution for these problem. >> >> 2. The working offline scenarios. Google reader is a perfect example, it's >> using Gears to allow me to download the content and read offline, when I get >> back online it would replicate the state of my read items. >> >> 3. Caching data. Most LOB apps have a big amount of static data, mainly used >> for reference, like countries, zip codes and other specific to your busines >> domain. Having this data always available in the client can avoid round >> trips allowing you to scale, providing a better user experience, and also >> abstracting your devs from async calls. >> >> >> >> >> >> On Mon, Jul 13, 2009 at 4:38 PM, Barry Beattie <[email protected]> >> wrote: >> >> yeah, I'm a bit unsure of the usage. >> >> if it was a WPF or Adobe AIR app, with reconnect sync of data then I'd >> understand and appreciate. but in-browser Silverlight... still runs in >> a browser... which means being online ... >> >> the only thing I can think of is something I've done with Flex and >> LocalSharedObjects ... basically a "super cookie" for remembering data >> when next using the app. >> >> very, very curious of the use cases (methinks something interesting to >> learn here) >> >> >> >> >> On Mon, Jul 13, 2009 at 4:10 PM, Scott Barnes<[email protected]> wrote: >>> I do have one question, what specifically are you looking to store in >>> offline storage? In that poor man's LINQ to SQL via isolated storage can >>> get >>> you by but it's got limitations as all would most likely know but as to >>> what >>> you store and why, that's got our curiosity into over-drive. >>> >>> >>> >>> >>> >>> From: [email protected] >>> [mailto:[email protected]] On Behalf Of Miguel Madero >>> Sent: Sunday, July 12, 2009 10:49 PM >>> To: [email protected] >>> Subject: Re: SQL 'in' Silverlight >>> >>> >>> >>> Yesterday on twitter Miguel de Icaza and others were talking about this, >>> they were mentioning something about migrating SQL Lite line by line to >>> managed code. >>> >>> On Mon, Jul 13, 2009 at 1:47 PM, Joseph Cooney <[email protected]> >>> wrote: >>> >> >>> I wouldn't be surprised if we saw a managed DB talking to isolated storage >>> in a future version of silverlight. >>> >>> Joseph >>> >>> On Mon, Jul 13, 2009 at 8:31 AM, Craig Dunn <[email protected]> wrote: >>> >>> Hey everyone - played around a bit with porting an old c# version of HSql >>> (from java) to Silverlight. I'm not sure of the utility but it was an >>> interesting exercise - still figuring out the kinks in isolatedstorage... >>> seems to work fine 'in memory' though. >>> >>> post: http://conceptdev.blogspot.com/2009/07/sql-in-silverlighthtml >>> play: http://conceptdevelopment.net/Silverlight2/SharpSql02/default.html >>> >>> the 'default' SQL includes some basic data & queries - you can Execute the >>> entire block, or select text to execute just like MgmtStudio... (just >>> don't >>> habitually hit F5 like was doing during testing!). the UI is pretty basic, >>> so you must scroll with the bars. >>> >>> ________________________________ >>> >>> Support procedure: https://www.codify.com/lists/support >>> List address: [email protected] >>> Subscribe: [email protected] >>> Unsubscribe: [email protected] >>> List FAQ: http://www.codify.com/lists/ozsilverlight >>> Other lists you might want to join: http://www.codify.com/lists >>> >>> >>> >>> ________________________________ >>> >>> Support procedure: https://www.codify.com/lists/support >>> List address: [email protected] >>> Subscribe: [email protected] >>> Unsubscribe: [email protected] >>> List FAQ: http://www.codify.com/lists/ozsilverlight >>> Other lists you might want to join: http://www.codify.com/lists >>> >>> >> >>> -- >> >>> Miguel A. Madero Reyes >>> www.miguelmadero.com (blog) >>> [email protected] >>> >>> ________________________________ >>> >> >>> Support procedure: https://www.codify.com/lists/support >>> List address: [email protected] >>> Subscribe: [email protected] >>> Unsubscribe: [email protected] >>> List FAQ: http://www.codify.com/lists/ozsilverlight >>> Other lists you might want to join: http://www.codify.com/lists >>> >>> ________________________________ >>> Support procedure: https://www.codify.com/lists/support >>> List address: [email protected] >>> Subscribe: [email protected] >>> Unsubscribe: [email protected] >>> List FAQ: http://www.codify.com/lists/ozsilverlight >>> Other lists you might want to join: http://www.codify.com/lists >> >> -------------------------------------------------------------------------------- >> >> Support procedure: https://www.codify.com/lists/support >> List address: [email protected] >> Subscribe: [email protected] >> Unsubscribe: [email protected] >> List FAQ: http://www.codify.com/lists/ozsilverlight >> Other lists you might want to join: http://www.codify.com/lists >> >> >> -- >> Miguel A. Madero Reyes >> www.miguelmadero.com (blog) >> [email protected] >> >> ________________________________ >> >> Support procedure: https://www.codify.com/lists/support >> List address: [email protected] >> Subscribe: [email protected] >> Unsubscribe: [email protected] >> List FAQ: http://www.codify.com/lists/ozsilverlight >> Other lists you might want to join: http://www.codify.com/lists >> >> ________________________________ >> >> Support procedure: https://www.codify.com/lists/support >> List address: [email protected] >> Subscribe: [email protected] >> Unsubscribe: [email protected] >> List FAQ: http://www.codify.com/lists/ozsilverlight >> Other lists you might want to join: http://www.codify.com/lists >> >> ________________________________ >> >> Support procedure: https://www.codify.com/lists/support >> List address: [email protected] >> Subscribe: [email protected] >> Unsubscribe: [email protected] >> List FAQ: http://www.codify.com/lists/ozsilverlight >> Other lists you might want to join: http://www.codify.com/lists >> >> ________________________________ >> Support procedure: https://www.codify.com/lists/support >> List address: [email protected] >> Subscribe: [email protected] >> Unsubscribe: [email protected] >> List FAQ: http://www.codify.com/lists/ozsilverlight >> Other lists you might want to join: http://www.codify.com/lists > -------------------------------------------------------------------------------- Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozsilverlight Other lists you might want to join: http://www.codify.com/lists -------------------------------------------------------------------------------- Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozsilverlight Other lists you might want to join: http://www.codify.com/lists
