tag:blogger.com,1999:blog-9053536529694784563.post6024317197718591236..comments2020-05-07T00:33:57.272-07:00Comments on Database Explorer: R is for InnovationSimon Riggshttp://www.blogger.com/profile/06017750505968534813noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-9053536529694784563.post-36995695127461651762011-08-19T04:40:07.306-07:002011-08-19T04:40:07.306-07:00I'm not sure what you mean by "plugin&quo...I'm not sure what you mean by "plugin". None of the databases you mention has, so far as I can find, anything more than two versions of database driver/connectivity: DBI (the RPostgreSQL, etc. "native" set) and the regular ODBC/JDBC set. DB2, looking at the train track fragment for CREATE FUNCTION, doesn't support R as a language. Spending some time at various R sites doesn't reveal any, either. Neither was R listed in the PostgreSQL docs I looked at. Where would one find the docs for using R as a function writing language?<br /><br />In any case, having such wouldn't be practical; R, unlike SPSS or SAS (which are pure RBAR), is a (data) memory resident program, since it implements matrix routines for solving. Teradata is the worst possible fit I can think of.<br /><br />As to NoSql and such, they've just revivified the VSAM/RBAR approach to client driven data storage/management. That's hardly an innovation.<br /><br />If you're looking for database/stat pack innovation, look to IBM/DB2. They're well on the way to integrating SPSS *into* DB2. Since SPSS has 1) always been SQL friendly, and 2) uses RBAR to solve the equations, it seems to be a good fit.Robert Younghttps://www.blogger.com/profile/09056808374481236610noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-59174932704942814012011-08-18T11:04:55.529-07:002011-08-18T11:04:55.529-07:00Hi Simon,
I'm more interested in Postgres'...Hi Simon,<br /><br />I'm more interested in Postgres' future than its past, personally. While Postgres is definitely innovating at a wild pace, I think there are a lot of exciting things happening outside the traditional RDMS space which are increasing developer productivity and enabling new workflows.<br /><br />What would you say are the key innovations NoSQL has brought to the space? I'd probably single out out Redis' novel approach to providing shared data structures, CouchDB's unique document/data structure storage model, and Riak's ability to provide massive scale on consumer hardware. How do we as Postgres users, developers and providers react and remain relevant in the next decade?<br /><br />If I had a dollar for every person I'd met who lamented being trapped on MySQL I think I could single-handedly fund Postgres development for years to come. Regardless of the abstraction layer, production databases are nearly impossible to port. How can we get more of the little newbies? (Encouragingly, OS X Server now ships with Postgres instead of MySQL as of the Lion release.)Peter van Hardenberghttps://www.blogger.com/profile/14721601975435968732noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-29005694585348888622011-08-18T04:18:55.380-07:002011-08-18T04:18:55.380-07:00History is interesting, I agree, and Database Hist...History is interesting, I agree, and Database History probably even more so. I think I'll cover that in future blogs.Simon Riggshttps://www.blogger.com/profile/06017750505968534813noreply@blogger.comtag:blogger.com,1999:blog-9053536529694784563.post-32163335503062919142011-08-17T19:23:01.909-07:002011-08-17T19:23:01.909-07:00> databases that have responded directly to inn...> databases that have responded directly to innovations in PostgreSQL<br /><br />It would be great to see what the other platforms have adopted from PostgreSQL. As a relative newcomer, the history is interesting.Anonymousnoreply@blogger.com