similar to: SQL Console to View

Why this doesn''t work? ActiveRecord::Base.connection.execute("\\d") ? I use PostgreSQL server and this should be command to get list of all tables within a database. Is there a problem with privileges or PGSQL driver for rails doesn''t support it? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message

I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different. http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example Files included with the distribution:

Hi The PostgreSQL development group released an update[1] for PostgreSQL to address a SQL injection vulnerability. From the infromation[2] released with this update, it appears the vulnerability exists in other (all?) database systems allowing multi-byte encoding of requests. Of particular importance - since it relates not to database issues but to web programming practices - are these quotes

Rails SQL Views 0.5.0 is now available from http://rubyforge.org/frs/?group_id=2435&release_id=8685 and shortly as a Gem (gem install rails_sql_views). More information on Rails SQL Views can be found at http://activewarehouse.rubyforge.org/rails_sql_views/ This release finally fixes the SchemaDumper issues, including the necessary select statement for the view. It also introduces PostgreSQL

I wasted some time yesterday and today implementing a SQL storage plugin. It seems to be working, but: - Saving new messages is done in a regular INSERT statement, which is bad. PostgreSQL has at least this COPY TO command which could be used instead. - It breaks in stress testing - It's not that well optimized. Especially it could support caching some commonly requested fields (same as

On 02/20/2020 05:18 PM, Liam O'Toole wrote: > On Thu, 20 Feb, 2020 at 16:36:51 -0500, H wrote: >> On 02/16/2020 10:47 PM, Bee.Lists wrote: >>> Sequel ORM >>> >>> >>>> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: >>>> >>>> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB

Hi everybody At work we''ve finally convinced the chief to develop some small project using open source technology. Unfortunately we are deeply involved with Micro$oft technology. That means, windows 2003 server, IIS, MS SQL 2005 and asp. I was thinking about recommending ruby on rails instead of asp, but I''d like to know how well it goes with IIS and MS SQL, because for the

Hi everyone, I have this code: @person_pages, @people = paginate :person, :per_page => 20, :conditions => [ "username LIKE ? OR first_name LIKE ? OR last_name LIKE ? OR preferred_name LIKE ?", "%" + params[:q].downcase + "%", "%" + params[:q].downcase + "%",

On 02/16/2020 10:47 PM, Bee.Lists wrote: > Sequel ORM > > >> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: >> >> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite? > > > Cheers, Bee > > > > > _______________________________________________ > CentOS

Hi, excuse me if this is off-topic and feel free to ingore it in case. I''m using acts_as_taggable (the gem version) and found what to me looks like a bug in this code from the method tags_count: sql = "SELECT #{t}.#{t_pk} AS id, #{t}.name AS name, COUNT (*) AS count FROM #{jt}, #{o}, #{t} WHERE #{jt}.#{t_fk} = #{t}.#{t_pk} AND #{jt}.#{o_fk} =

If I establish a new connection with a new adapter (ie. switch from mysql to postgresl) the generated sql is still mysql specific. I tried all sorts of reset methods on AR::Base but to no avail. There must be something being memoized on ActiveRecord base that has to do with the adapter and it doesn''t get cleared when you establish a connection with a new adapter. I know this

Hi... I want to know the equivalent instructions to insert, update, search and delete a registry. I know Rails can do it easily Thanks to ActiveRecord, but here''s the catch: I''m using PostgreSQL. As I''m using SQL to do the migration (Including the foreign keys), I need to know if I can use SQL queries to do those actions. Is there an example out there? I uncommented

Every page of my DEPOT on Postgresql rails app now gets an error from postgres-pr about some wild left-join SQL that has nothing to do with my tables: SQL (0.000000) NameError: undefined local variable or method `errors'' for #<PostgresPR::Connection:0x3b200c0>: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN

Hello! I'd like to setup quota for for virtualusers, i'm using both maildir++ and mdbox as storage, and i'm using postgresql to keep users. I'm keeping all users data in one table: [...] login text NOT NULL, domain text, password text, quota_mb integer NOT NULL DEFAULT 0 [... other columns ...] i'd like to keep present quota in such two columns: quota_dict_bytes integer NOT

Hello! I would like to put user login attempts into SQL DB (PostgreSQL). Any idea how to do it (without manual parsing log files)? Kind regards, Krzysztof Kiszewski

I have been running Postfix/Dovecot with a Postgresql backend for several months, and everything has been running great. Now I want to add server side filtering, so I'm attempting to configure deliver. The SQL maps for Postfix are all keyed upon the recipient email address. The SQL map (user_query) for Dovecot is keyed upon the IMAP login name, which is potentially unrelated to the email

I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite?

On Thu, 20 Feb, 2020 at 16:36:51 -0500, H wrote: > On 02/16/2020 10:47 PM, Bee.Lists wrote: > > Sequel ORM > > > > > >> On Feb 16, 2020, at 7:28 PM, H <agents at meddatainc.com> wrote: > >> > >> I am looking for an open-source SQL modeling tool to use with MySQL, MariaDB and PostgreSQL. Does anyone have a favorite? > > > > > >

I haven't been able to find anything useful on the horde sites, and I haven't found anything useful with 'yum search'. I am trying to set up horde webmail using the PEAR install on a new CentOS 5 system intending to migrate existing horde-3.x sites to horde-4.x. The PEAR installation procedure asked for the database type, db name, and password. I had not created the mysql

[copying the rails list for more feedback] On 3/17/06, Jakob Skjerning <jakob@mentalized.net> wrote: > I believe you''re currently the man putting a lot of effort into the > Rails SQL Server adapter - is this correct? Somewhat. I am maintaining the SQLServer adapter but I''m not doing quite as much as I''d like with it and you certainly can''t call