Installing the Sanskrit Phonetic Transliteration Keyboard

After downloading and installing the application from the Google Play store, now we need to go to Settings on the phone and then to Language and Input

Add virtual keyboard

Choose Sanskrit Phonetic Keyboard from the list

When activated just click on Ok for the message that appears

Now the keyboard is added to list of onscreen keyboards

Go to any particular messenger, like whatsapp and select the keyboard and enjoy typing in sanskrit

Accessing Oracle Schema from Postgresql-11 Database on Ubuntu 18.04 using oracle_fdw

Firstly login to psql

ana@ana-pg ~ % sudo -i -u postgres
[sudo] password for ana:
postgres@ana-pg:~$ psql
psql (11.2 (Ubuntu 11.2-1.pgdg18.04+1))
Type "help" for help.
postgres=# \c testdb;

Now that we are in the test database testdb, we can create a schema here.

testdb=# create schema test;

Now in this test schema, we will try to add the foreign oracle server called “oradb”. Now this server will be accessed by postgres user rtam. Therefore we create a user mapping of rtam to oracle

CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw
OPTIONS (dbserver '//hostname:1521/service');
GRANT USAGE ON FOREIGN SERVER oradb TO rtam;
CREATE USER MAPPING FOR rtam SERVER oradb OPTIONS (user 'oracle_schema_name', password 'oracle_schema_password');

Now lets try a simple experiment. Let us say we have a schema “scott” in oracle. We create a table here called test

CREATE TABLE scott.test
(
id NUMBER,
msg VARCHAR2 (30 CHAR)
);

Now in Postgresql, in our testdb, in our test schema, we run the following in psql

CREATE FOREIGN TABLE test.test (
id integer NOT NULL,
msg character varying(30))
SERVER oradb OPTIONS (schema 'SCOTT', table 'TEST');

If we now do a select on test.test, we will see the values of oracle table in the Postgresql Database.

So basically under Foreign Tables one sees the oracle tables directly accessible to Postgres.

One can also Import the oracle foreign table schemas directly into postgresql using a command:

IMPORT FOREIGN SCHEMA "SCOTT" LIMIT TO
(TABLE1,TABLE2,...) FROM SERVER oradb INTO postgres_schema_name;

Note that when using Oracle names, always use caps. Also in the above schema name, “” have to be used to make sure that Postgres interprets the oracle schema name correctly. Postgresql otherwise tends to search for lower case names and does not find anything.

Back to Import Oracle Foreign Server

Back to Sony Xperia Z5 Original ROM

In my update to this post http://www.partha.eu/partha/custom-rom-xperia-z5-e6653/ I have to tell you what happened in the last three weeks.  My experiment with the LineageOS Custom Rom for Z5 did not pay off.  Why?

  1. The music quality when i used the speakers was terrible
  2. If you are used to superior auto like me, then you cant really use the camera well enough
  3. The phone is unstable. Apps dont react properly sometimes and you tend to just reboot.
  4. I think the battery drained faster
  5. I missed the Sony music app, the Sony Albums for sorting pictures