similar to: R and databases - a comment

Hi everyone; I was just wondering if anyone has any opinion/information on the pros and cons of using the built-in HSQLDB vs Postgres. Thanks! Bee -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to

hi all, I am having a hard time trying to find out what''s wrong with my setup. It used to work smoothly until I decided out of the blue to do a selfupdate and upgrade outdated on MacPort, then things started going south very quickily. Since MacPort kinda broke, I pull it all out and re-install the ports I have before, which went pretty smoothly. Then to my surprise any command I

Has anyone tried using erb and builder in the same file? Either .rxml or .rhtml? I''m wanting to do some think like the following: xml.div(''id''=>''menu'') {|xml| link_to "create race", :controller=>"derby", :action=>"new" } Thanks, -- Tom. -- "Nothing will ever be attempted, if all possible objections must

Hi, I have the following assert_equal that is returning false. @q seems to be returning niil, but is set in the controller, how can I get hold of this value in my tests? assert_equal ''derby'', @q Thanks Mark -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

So after successfully getting the test SQLite db to run from memory, I tried running some tests but found that somewhere in the schema translation from Postgres (my devel database) and SQLite Rails fails to properly set the ''id'' column, which breaks all kinds of things. Take as an example my ''users'' table. In Postgres the schema is (generated with pgAdmin III):

People, I have been thinking at this for long time and I do not know if SQLite is sufficient for my application. I developed an inventory system in Rails -v 2.2.2 and I do not know if SQLite is the best choice or if is neccesary have a bigger database engine than SQLite.. This site will not has thousand and thousand records or visits each day so I think with SQLite could

Not getting any love (tender or otherwise) on my pull request<https://github.com/rails/rails/pull/7035>so I thought you folks might like to chip in. What do you think? #cast and #cast! allow you to declare a mapping from generated column names to simplified database column types (i.e. those used in migrations). This way scopes with columns generated in their select lists can also include

Hello All, Yesterday i put RoR with Locomotive. I am very happy :p. So I follow this tuto (http://developer.apple.com/tools/rubyonrails.html). I used Sqlite. my database.yml # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql -- --include=/usr/local/lib) # And be sure to use new-style password

Dear R users, I am a psychology postgraduate student who is relatively new to using R. I am currently developing a psychometric scale and have run into a few problems when using R to calculate a polychoric correlation matrix for my dataset. I am trying to produce a polychoric correlation matrix for calculating ordinal reliability estimates (eg. Alpha, omega).The set consists of 439 observations

ronggui wrote: > If i am familiar with > database software, using database (and R) is the best choice,but > convert the file into database format is not an easy job for me. Good working knowledge of a DBMS is almost invaluable when it comes to working with very large data sets. In addition, learning SQL is piece of cake compared to learning R. On top of that, knowledge of another (SQL)

= About Ackbar Ackbar is an adapter for ActiveRecord (the Rails ORM layer) to the KirbyBase pure-ruby plain-text DBMS. Because KirbyBase does not support SQL, joins or transactions, this is not a 100% fit. There are some changes to the ActiveRecord interface (see below), but it may still be useful in some cases. = URIs Ackbar: http://ackbar.rubyforge.org KirbyBase:

Hi, I'm working in R 2.11.1 x64 on Windows x86_64-pc-mingw32. I'm trying to insert a very large CSV file into a SQLite database. I'm pretty new to working with databases in R, so I apologize if I'm overlooking something obvious here. I'm trying to work with the American Community Survey data, which is two 1.3GB csv files. I have enough RAM to read one of them into memory,

I know this isn''t Python, but I''d like to get a view on the ''one obvious'' way to set up an SQLite (or other) database and its location per-app. I''ve got a bit lost with the Camping 2 changes and various code snippets I have kicking around. 1. is it best to set up the DB creation/connection: 1.1 at the end of the app

I put them on the wiki page, but I'm not sure if they're read often or whatever. a - Sqlite support I know its been talked about, but it wasn't on the request/todo page until i threw it on there, so i wanted chime in for it as well b - User configurable ports ports are hardcoded in the c source file. it would be nice if these were the defaults, and could be

Hi R-help, I am using the sem package to run confirmatory factor analysis (cfa) on some questionnaire data collected from 307 participants. I have been running R-2.15.3 in Windows in conjunction with R studio. The model I am using was developed from exploratory factor analysis of a separate dataset (n=439); it includes 18 items that load onto 3 factors. I have used the sem package documentation

Just wondering if anyone is using a backend database other than sqlite, and if so, how easy/hard it was to configure. I''m constantly receiving "SQLite3::BusyException: database is locked..." which I presume is due to sqlite''s relatively coarse locking method. Cheers, James -- Senior Linux Platform Engineer Midrange Services AXA Technology Services - Asia Pacific

Hi ! I just wrote cdr_sqlite.c, see http://bugs.digium.com/bug_view_advanced_page.php?bug_id=0001986 This little app creates automatically the sqlite database file in /var/log/asterisk/cdr.db, creates a table 'cdr' inside it and inserts all CDR records into this table. Please comment. I'll use this in my project DESTAR (http://www.holgerschurig.de/destar.html) to show these

Dear fellows, I'm getting blue screen on XP while populating SQLite database, using RStudio and RQLite package. The blue screen says "INVALID PROCESS ATTACH ATTEMPT" before goes into memory check and reboot. The database (file) is corrupted and not readable after this happens. I'm iterating over CSV files, each contans a time-series of as many as 500x5000: rows being dates,

The activerecord-sqlserver-adapter gem is still sort of available via gems.rubyonrails.org, but it will not install on machines that have Rails 2.1 (or its version of ActiveSupport) installed. This has been confirmed with versions of rubygems through 1.2. This seems to indicate that Rails is no longer tested against the MSSQL adapter and that the adapter is also no longer tested against Rails

Please let me know where i have to type below thing to RSQLite database get installed.Please let me know the solution.Thanks in advance RSQLite -- Embedding the SQLite engine in R (The RSQLite package includes a recent copy of the SQLite distribution from http://www.sqlite.org.) Installation ------------ There are 3 alternatives for installation: 1. Simple installation: R CMD