Search In
We often need to integrate search functionality in our application, If our rails application is using PostgreSQL as a database, then we can use pg_search gem. This is the easiest way to add a search feature on any rails application having postgres as
Some Useful PostgreSQL Command in below example->
Backup database-
pg_dump -U geekstuff erp -f mydb.sql
Restore database-
psql -U erp -d erp_devel -f mydb.sql
Change owner of database-
ALTER DATABASE erp_v1 OWNER TO openerp;
Describing table
As we all know that creating a backup of your project is very crucial for any application , not just to recover your application in case of any unseen conditions but also for testing , creating a new server , migration etc.
Until recently heroku do
If we are using PostgreSQL RDBMS in rails application and there are need to search functionality, pg_search gem is perfect for that. It has easy implementation and having rich methods for the search functionality.
Note: pg_search gem supports o
Many Programmers feel comfortable to use Postgre SQL rather than MongoDB, member of MEAN Stack.
We are going to integrate Postgresql with NodeJS
To install NodeJS, please go through this Article
Now, when we are finished with Installation of NodeJ
Following is the XML which we want to create:
SELECT magazineId
, magazineName
, coverPage
, publishDate
, expiryDate
, isActive
,(
SELECT (
SELECT (
SELEC
Hello Reader's! If you're having a problem to convert a string into an array then you can use the html entity in php.
Let's see the example below:-
&
then be sure to use html_entity_decode
// Input string //
$input = 'pg_id=2_parent_id=2_docume
If you face error on re-installation of OpenERP or pgAdmin, then you need to add the port 5432 for Postgres in Inbound and Outbound Rules.
Follow these step given below:-
Step1- Go to Control panel/System and Security/Windows Firewall and select Al
"%g" % (float_number)
Above function formats float number to natural number if it contains zero's after decimal point otherwise format float upto one decimal point
Helpful in showing working days(like 22.5 days)
For renaming a database in pgAdmin:
Go to pgadmin and select 'postgres' database and click on the query tool; run the query:
ALTER DATABASE old_dbname RENAME TO new_dbname
Example:
ALTER DATABASE test_ky RENAME TO kwality(14-15)
