On Sat, 30 Jan 2016 20:50:17 -0500 Jim Callahan <jim.callahan.orlando at gmail.com> wrote:
> I am not interested in a complete ORM; what I am interested is when the > object-oriented language supports a SQL-R-like object. In R, the object is > called a data.frame and the package "Pandas" supplies a similar data frame > object to Python. > https://pypi.python.org/pypi/pandas/0.10.0/ The page says: > Additionally, it has the broader goal of becoming the most powerful > and flexible open source data analysis / manipulation tool available > in any language. There have been so much announcements of the like in many areas?? (open?source or not) The page mentions HDF5, and Pandas descriptions seems similar to that of HDF5 in the intents. If Pandas exists, this may be that its authors believe the HDF5 library is not good enough. But HDF5 (which is itself subject to criticism) made the same promises as Pandas seems to do. Just to say this may be seeing something as universal, while it is not for every one or every use, so the urgency may not be that hight. Is the concern mainly about hierarchical data? (SQL has a reputation for not be well suited to that) About heterogeneous data? (i.e. not easily matching a type or a pattern) > I am not interested in a complete ORM; what I am interested is when the > object-oriented language supports [?] What is object oriented in this context? What properties of the object model raise hight in the picture when you think about in typical use cases? > R as I have mentioned has fantastic interfaces to SQL databases that allow > one to pass a query and have the result populate a data frame. The data > frame in R or Python can be fed to a machine learning algorithm (scikit > learn on Python) or to a plotting package such as ggplot or bokeh. > https://pypi.python.org/pypi/ggplot/0.6.8 > http://bokeh.pydata.org/en/latest/ > http://scikit-learn.org/stable/ > > What I want to do is to demonstrate short scripts in R and Python to > accomplish the same task. I don't want the Python scripts to be longer and > more complicated because Python has an lower level interface to SQLite. [?] Why should this be SQLite's responsibility? What prevents a Python (or R) library to implement the desired interface? (providing a used library does not count in a script's length). Is this with the hope to get greater efficiency? (i.e. timing and consumed resources) With my apologizes for the naive questions?? -- Yannick Duch?ne
