24 April 2014

The Ruby Reflector

Topic

SQLite

  Source Favicon
Email

…It's important to note that none of the topics or commands we'll look at are specific to SQLite3. All the query examples we'll go over below are ISO 9705 compliant and will work in any of the major databases ( Postgresql , MySql , Oracle , etc).

From the command line fire up SQLite3 and create a database named back_to_basics : % sqlite3 back_to_basics

Now let's create three tables. We'll call them players , teams and players_teams …

robots.thoughtbot.com Read
  Source Favicon
By allaboutruby of All About Ruby over 4 years ago.
Email

…fun trying to rectify the SQL errors that are working fine on MySQL and SQlite.

Heroku provides a way to push (and pull) data to the production database from the development, but it didn't really work for me, I raised a ticket - let's see how it goes.

7.2. - Logs and console

Both logs and console are accessible via heroku command. Run "heroku logs" to get the latest extract from logs and "heroku console" to load the console for debugging / testing purposes. …

allaboutruby.wordpress.com Read
  Source Favicon
On Litany Against Fear over 5 years ago.
Email

…database connections.

The future: combine the Ruby feel of Guy's code with Dan's C codebase, improve tests, more marshaling options. Support for newer version of the DB and moving to GitHub soon.

Databasess != SQL or Entity/Relationship. Just be happy and use Ruby! Use the right tool for the job too, if it's BerkeleyDB, sqlite, MySQL, or whatever.

litanyagainstfear.com Read
  Source Favicon
By Todd Hoff of High Scalability 2 months ago.
Email

MVCC database (write do not block reads, and vice versa) that runs in the same process (a la SQLite), which we've also merged with our application code and our caching tier, so we're down to—literally—a single process for what would have been at least three separate tiers in a traditional setup.

The result is that we had to move to measuring request latency in microseconds exclusively. The architecture (without additional application-specific processing) supports a wire-to-wire …

highscalability.com Read
  Source Favicon
By Bill Karwin of MySQL Performance Blog 2 months ago.
Email

SQLite, another popular open-source SQL database, just released version 3.8.3 , including support for recursive SQL queries using the WITH RECURSIVE syntax , in compliance with SQL:1999.

Why is this significant? It means that MySQL is now the only widely-used SQL implementation that does not support recursive queries. Fifteen years after it was defined in the SQL standard, almost every other SQL database of note has supported this feature:

IBM DB2 UDB

mysqlperformanceblog.com Read
  Source Favicon
By Satish Talim of RubyLearning Blog 4 months ago.
Email

Sinatra and SQLite3 interaction

The course contents are subject to change.

Mentors

Satish Talim and Victor Goff III from the RubyLearning team.

Some Highlights

RubyLearning's IRC Channel

Some of the mentors and students hang out at RubyLearning's IRC (irc.freenode.net) channel (# rubylearning.org) for both technical and non-technical discussions. Everyone benefits with the active discussions on Ruby with the mentors.

Google Hangouts

There …

rubylearning.com Read
  Source Favicon
By Satish Talim of RubyLearning Blog 4 months ago.
Email

Simple CRUD app with ActiveRecord, SQLite3 and YAML

Using Rack Middleware

You can read through the RubyLearning FAQ .

Some Fun Apps

Here are some of the fun apps created by the previous batch participants and deployed to Heroku:

A static webpage .

Finding Photos on Flickr

String Reversal Service .

Stock Exchange Quote Service .

A Sinatra app to access GEO Info via GeoCoder

Sinatra Street View …

rubylearning.com Read
  Source Favicon
On carpeaqua by Justin Williams 6 months ago.
Email

Base - Elements has a SQLite database behind it. I'm constantly inspecting the database contents using this application. It's lightweight and easy to use.

Charles - Sometimes I want to snoop the traffic that is going through an iPhone app. Setting up Charles makes it pretty easy to do just that.

CodeRunner : There are times I am writing a small snippet of code to share with someone or just to test an idea on my own. I don't necessarily need the full …

carpeaqua.com Read
  Source Favicon
By Joey of Global Nerdy 6 months ago.
Email

…follow these instructions, you have to use MySQL as your database rather than the default SQLite3. I've heard of a number of problems getting SQLite3 to work with Rails on Windows, which may be why this is the case. The end result is that if you want to create a new project, you'll enter a slightly longer command: rails new your_project_name -d mysql

The recipe has 5 steps, each with its own video:

Install MySQL

Install Ruby 2.0

Install Git (and use it to clone …

globalnerdy.com Read
  Source Favicon
By Assaf of Labnotes 1 year ago.
Email

…communicating relationships in data . Supports PostgreSQL, MySQL, SQLite, Redis, and MongoDB out-of-the-box.

§ Times Haiku, a collection of Haiku found in The New York Times . Love this one :

As an engineer,

I'm sort of a student of

how things fall apart.

§ Eric Bogs :

If Tetris has taught me anything, it is that errors pile up and accomplishments disappear.

§ Rich Rogers :

"A good programmer is someone …

blog.labnotes.org Read