search for: postresql

Hello everybody, now I'm using MySQL for SIP/IAX friends and CDR. Is it also possible to use PostreSQL instead of MySQL? Regards Bastian

Hi We are using postgresql with rails, we find out that when we read array from postresql (postgresql support array type in table) the rails (or postgresql_adapter) converts the arrays into Strings, example: we have a data type array in a table which has two cells: [cell1,cell2], rails will convert them into string like this {cell1,cell2}. So after received the result from a SQL request...

Hi all, I am about to start a new RoR project. Which version of mysql is the current best one to use? I will be using the soon-to-be-released RoR 1.0 for the project. I really don''t want to start a PostreSQL vs. MySQL vs. Whatever war. I have all databases including Oracle at my disposal. This project will be my testbed for using RoR with mysql. I will be doing other tests with other dbs later. Thanks for any input! -Eric

.../$owner >>shared/shared-boxes/group/$group/$owner What is a "dict path"? Is this some kind of hard coded identifier in the Dovecot code? I need to understand how they work because I can't use the example in http://wiki2.dovecot.org/SharedMailboxes/Shared. This is because in my PostreSQL table users are not a single column but two columns with the local and domain part[2]: Table "public.shared_mailboxes" Column | Type -----------------------+------------------------ shared_mailbox_local | character varying(64) shared_mailbo...

...//supervisors - define new users that can access to the software - set for each user the operation to do in the queue (login/logout/real time monitor/statistics) now i've realized the firse section, realtime, and i'm using it in my callcenter sice 2 weeks the software use php and mysql o postresql as database (i would add some ajax module for refreshing some data without reloading the page) so, would you like to contribute? what do you think of that?

...o, if this package is so fast, how come its not available on CRAN? If I may ask a second question for my enlightenment. It seems that PostgreSQL and mySQL are pretty popular, but my database is in SQL Server and I do not have the ability to change it. How come every package has native drivers to PostreSQL and Oracle but none of them seem to have a native drive to SQL Server and I have to use ODBC? Thanks in advance for any advice.

Hi, there are something that is using mysql instead postresql? If I modify the modules.conf, and write load => cdr_mysql.so get this error: loader.c:240 ast_load_resource: /usr/lib/asterisk/modules/cdr_mysql.so: cannot open shared object file: No such file or directory loader.c:359 load_modules: Loading module cdr_mysql.so failed! Ok, there is no cdr_my...

I need to insert ~100k rows into the database, but using "Table.new(...).save" is painfully slow (I notice in the logs that it''s wrapping each insert in a transaction -- that can''t be fast). Any suggestions on how I can improve the speed of bulk inserts like this? Thanks ... -- Steve

Hi to all!! I'm successful to connect Asterisk to PostgreSQL database... If it's possible, can anyone learn me how to store sip user in PostgreSQL database and how to configure voicemail?? Thanks for all!!!

Hi all I need some help with query on Postresql Database. I have some tables on a DB, and I wanna to retrieve status on field in this tables... I explain: ON the DB table, I have this field: XXXX => Service Order YYYY => the situation about Product Order Now, when a cliente call to phone pluged on Asterisk, he follow the URA, by the sy...

Hello, I have tried to install the salted hash login generator by following the quick start guide at: http://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart. Everything seems to work fine until I try to run the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in

I have an application where speed is probably the #1 priority here. I am using MySQL 5.0.22. Would SQL be considerably faster than MySQL? I know this has been discussed before, but the search on the forums is not working. Thanks for your help. -- Posted via http://www.ruby-forum.com/.

Hello, I''m a newbie to rails and I am trying to do the Demo in the November Issue of Linux Journal. Things go fine go fine until I try to connect to my Postgres database (ver 8.1). At this point I get the following error message ---- RoR error and trace back ---- PGError in Admin#index could not connect to server: Permission denied Is the server running on host "localhost"