Tagged Questions

0
votes
1answer
18 views

How to select records using table relationships and timestamps?

Another newbie PostgreSQL question. I have something like this: CREATE TABLE user ( userID bigserial primary key, name varchar(50) NOT NULL, created timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ...
0
votes
0answers
21 views

Puma Cluster configuration on Heroku

I need some help with my configuration of Puma (Multi-Thread+Multi-Core Server) on my RoR4 Heroku app. The Heroku docs on that are not quite up-to-date. I followed this one: Concurrency and Database ...
1
vote
1answer
20 views

Is a ruby's Timestamp class equivalent to PostgreSQL's timestamp?

If I make a model and create a field like "name" along with a Timestamp, will it be equivalent to a timestamp created manually through a query like: CREATE TABLE whatever ( name varchar(25) created ...
-3
votes
1answer
57 views

counting repeated records in rails

I'm programming an application that receives user records, as in a vote. I need that accumulates the names if they are repeated and tell me how many times written by this name. i did it but, but I do ...
0
votes
2answers
29 views

LEFT OUTER JOIN loses original userID

Stepping up my PostgreSQL knowledge. Here's a working query: SELECT * FROM associates a LEFT OUTER JOIN ip b ON a.userID = b.userID AND b.iPAddress = '124.xxx.xxx.xxx' LEFT OUTER ...
0
votes
1answer
21 views

How to get the id of the row inserted from PG::Result

I've ran a simple insert command: INSERT INTO names (name) VALUES ('john') As a response I get a PG::Result object. I've been digging through those docs but I can't squeeze out of that object the ...
0
votes
0answers
29 views

export users email addresses into excel from Heroku production database

What's the best way to export all of the users email addresses from a production on Heroku running Postgresql into excel?
0
votes
0answers
34 views

When i run: heroku run rake db:migrate

When I am pushing my project to Heroku where I'm using PostgreSQL as the database, I get an error: sorry something went wrong. Then I run: heroku run rake db:migrate and I get these errors: ...
1
vote
0answers
17 views

Heroku multi region support

Does Heroku offer multi region support for it's implementation? I'm specifically interested in a master-master database setup in multiple AWS regions. Thanks
0
votes
1answer
21 views

Error in Heroku run python manage.py syncdb

I'm using django==1.5.1 and I got this error below. Earlier I was using django==1.4.2 and didn't got such error following the same tut in GSWD (I did not update the django version in the middle of the ...
1
vote
1answer
24 views

Postgresql.app user database deleted. How to recreate?

I'm developing a Ruby on Rails app for use on Heroku and want to use postgresql.app locally for the development environment (mostly to play with Rails 4.0's new array attributes.) I had installed ...
1
vote
1answer
26 views

Error on DB:Migrate “uninitialized constant DeviseCreateUsers”

I'm trying to run the rake db:migrate command on Heroku and I'm running into this problem. uninitialized constant DeviseCreateUsers ...
0
votes
2answers
54 views

Heroku - how to pull data from one database and put it to another one?

We have 2 Heroku apps - the first one is production and the second one is staging. I would like to pull data from one table from the production app (it's table users with all user's data) and push it ...
0
votes
1answer
19 views

delete posts on rails server from heroku console

I am developing a rails-backed iOS app that is running on Heroku. The app uses afnetworking to GET and POST to the server. As I am developing it, I make posts to test and see if http requests are ...
0
votes
1answer
31 views

Heroku: Dump Postgres database into local SQLite3 database for Rails project

Is there way to dump heroku postgres database and import the data into my local SQLite database? I tried using https://github.com/ludicast/yaml_db and heroku db:pull with no success. I am developing ...

1 2 3 4 5 … 48
15 30 50 per page