Andriod (Python dev) and Posgresql help

[Faziki]

Hello,

Thank you for your interest in my post.

Noob here....

Im writing a andriod app in python and using Posgresql as a database to capture information.

But im struggling to make the link from Andriod to Python, so that if a new user signs in that his information is captured automatically in the fields i have created in Posgresql.

The link between Posgresql is created and i can log into the database with Python create fields, tables, and inject information into my fields. (User name, password ect)

Any advice would be great!


Regards,
Pieter.

 

[nevadayz]

Hello,

Thank you for your interest in my post.

Noob here....

Im writing a andriod app in python and using Posgresql as a database to capture information.

But im struggling to make the link from Andriod to Python, so that if a new user signs in that his information is captured automatically in the fields i have created in Posgresql.

The link between Posgresql is created and i can log into the database with Python create fields, tables, and inject information into my fields. (User name, password ect)

Any advice would be great!


Regards,
Pieter.

Wow, i do work in both of those languages, but not at the same time.

Good luck!

 

[Pho3nix]

Hello,

Thank you for your interest in my post.

Noob here....

Im writing a andriod app in python and using Posgresql as a database to capture information.

But im struggling to make the link from Andriod to Python, so that if a new user signs in that his information is captured automatically in the fields i have created in Posgresql.

The link between Posgresql is created and i can log into the database with Python create fields, tables, and inject information into my fields. (User name, password ect)

Any advice would be great!


Regards,
Pieter.

Question..

PosgreSQL on the phone????
Why not a service that the app will access over the web?

 

[Faziki]

Question..

PosgreSQL on the phone????
Why not a service that the app will access over the web?

Im not going to add posgresql on the phone, the app is going to connect to the posgresql. SQL lite and all those wont work for the amount of info we are going to capture. and its fast reliable and effective.

 

[_kabal_]

hope you have a good sync plan in place.

 

[gkm]

I suspect you are in for a tough road if you are going to try to write directly from Android to the DB. And writing your android app in Python is also pretty "experimental" in my opinion.

Maybe rather write the stuff from the phone onto some kind of queue or Rest interface and from there into the DB. And maybe consider other phone development options, with Java probably the easiest to get tons of info and help on.

 

[Faziki]

I suspect you are in for a tough road if you are going to try to write directly from Android to the DB. And writing your android app in Python is also pretty "experimental" in my opinion.

Maybe rather write the stuff from the phone onto some kind of queue or Rest interface and from there into the DB. And maybe consider other phone development options, with Java probably the easiest to get tons of info and help on.

Its not going to send and retrieve the whole time from the database... only when the user logs into the app or register for the 1st time. The users information is vital for the application. Python is in my opinion a very good and compatible language to write any app, it draws libraries from Java or any language that you need and your time programming is less than half than coding in a other language (Java,C++ etc) and the libraries im using is very good for apps.

But can you elaborate on the though road part, because it would help a lot if i can find out more about the database writing.

Thanks for your opinion

 

[Faziki]

hope you have a good sync plan in place.

Busy working on it... but if you have any suggestions please feel free to advise

 

[gkm]

But can you elaborate on the though road part, because it would help a lot if i can find out more about the database writing.

Thanks for your opinion

Databases do not deal well with flaky connections, since that controls what gets committed etc. Mobile generally means flaky connections. Usually best to have some kind of server in the middle that deals with the database connection.

Also, remember a mobile phone is not a PC or server, so the thinking that applies for developing PC apps does not translate directly to mobile apps. It is similar, but not the same.

 

[Faziki]

Databases do not deal well with flaky connections, since that controls what gets committed etc. Mobile generally means flaky connections. Usually best to have some kind of server in the middle that deals with the database connection.

Also, remember a mobile phone is not a PC or server, so the thinking that applies for developing PC apps does not translate directly to mobile apps. It is similar, but not the same.

Thanks ! I have noted it and worked an idea in the project to avoid flaky connections. going to make a gateway server role on the database server that regulates the connection.

Im having trouble with google API's At the moment, Im searching for a way to use gmail's API so that I can set it up so that i can get the users name, surname,email addr and age but also so that the user can use that API to send emails through the application for enquiries... anyone here know how to work with google API's really noob with the API's

Regards,
Faz

 

[gkm]

Usual way of doing this is via an intent, which then uses the e-mail client configured on the device to send e-mail:
http://www.tutorialspoint.com/android/android_sending_email.htm

Getting other details about the user of the device is usually via account manager:
http://stackoverflow.com/questions/2112965/how-to-get-the-android-devices-primary-e-mail-address