• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

Database connection, a fundamental question

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I want to use a server side Db. I want to build a Db and manipulate data (e.g. got a 000webhost account as a possible starting point, there is a mysql server with MariaDb/Innodb).

At the front end I would like just java/Android, with computing of the data here for easy testing different formula/computations. Also a non-browser user interface with input/results would be here. I just started with that...

As a backend, as I would interpretate some comments around so far, I would need a backend in Javascript(?) or another solution to hide DB login/interns from the world.
I'm in search for a good starting point for that specific case (if e.g. some of the code runs on server side, it's of course also ok)...

I'd like an as standard and all world supported and easy implementation as possible. No discussion, just a state of the art recommendation.
e.g. Java/Android-Backend-DBType in XY% of web, code link, lit link.

<Please don´t kick my question as stackoverflow just did - where should a beginner ask if not in a forum?>
Thank You in advance!




 
Bartender
Posts: 1868
81
Android IntelliJ IDE MySQL Database Chrome Java
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to CodeRanch.

Well you will need some server side coding. There are a number of different solutions/languages that could be used including Java, PHP, Node/JavaScript, ASP.Net. any one of them works do.

If you know some Java then you could get started fairly quickly with Spring see https://spring.io/guides and https://spring.io/.

You can find some resources here https://coderanch.com/c/books which may help you out.

I'm unsure if you are looking for tutorials, what you are comfortable doing, what your knowledge/expertise is or your timeline for this project. It is probably best that you can mirror the live environment for development.

Your web service account may be the limiting factor here. Android supports SQLite out of the box. Is probably best that your create a web service that is consumed by Android to populate the SQLite database.

I'm unsure if any is this helps you out.
 
Marshal
Posts: 8296
592
Mac OS X VI Editor BSD Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the Ranch.

StackOverflow has different idea, so it is understandable that your question didn't go through their filters.

We have different ideology, however, your thoughts seem to be messy a bit. You posted this question in Android forum with a DB subject line, but it isn't clear enough about neither of necessity here.

How much experience do you have in programming? And most important, what are you trying to build? Don't use please any computing terminology.
 
Andreas Pirker
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank You for the quick answer!
My "problem" is there are so many "solutions" from the viewpoint of a beginner.
And I would need a recommendation what [Javascript?/Servlets?Php?Whatever] to read/learn as server/side to "talk with my local Android" on the one hand and the server-side mysql db on the other hand (as standard and easy as possible, if there are already implementation examples as examples onsite even better).

The special use case I would like would be:

front end: input form (survey-like), or computation results based on data - Java/Android (local sqlite mirror if necessary), would manage that so far with my first java knowledge...

back end: ? starting point to read ? (just handle data to/from online db)

database on server: mysql

(Of course security issues should be covered as good as possible with login to change db values, and without only to add to db etc.)

Thanks again.
 
Andreas Pirker
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well I "had" some programming experience 20 years ago with some easy university pascal, signal processor programming, Visual C++/Visual Basic solutions...
(Re)Starting at Java/Android now... ;-)
 
Pete Letkeman
Bartender
Posts: 1868
81
Android IntelliJ IDE MySQL Database Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
As to where to start?
I suggest that you pick what you already know or what you want to learn.  If you are learning Java for Android development then maybe your want to go all the way with Java on the server.
You know some C and some VB, maybe dot Net is for you. ASP.Net MVC can be a good start, free tools. ASP.net has some special server limitations.
The benefits of Node is that it's JavaScript and can be used on the front end and the back end. So you may only need to learn JavaScript. Node can be used on many servers including those that don't support ASP.net and Java.
Is kind of hard to say what path you should take as everyone has their own basis and experiences.
I would suggest that if possible you try a few different languages out. To see what you like the most. There are many get started tutorials out there ranging in quality. I'm trying to stay netural here as many of us have preferences and each language and environment has their own pros and cons.  Many people do what they do on their projects because it's what they know from work or from school.
 
Andreas Pirker
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Does that make still sense for my use case? https://coderanch.com/t/669981/books/book-learn-web-programming-Java
-> http://web-engineering.info/JavaJpaJsfApp-Book
-> or https://www.murach.com/shop/murach-s-java-servlets-and-jsp-3rd-edition-detail
 
Pete Letkeman
Bartender
Posts: 1868
81
Android IntelliJ IDE MySQL Database Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry I have not done too much web programming with Java and I have not read those books. I suggest that before your but a book that you see what you can find on YouTube and other free tutorials. This could save you some money and it may change your path or what your plan on doing.
 
Pete Letkeman
Bartender
Posts: 1868
81
Android IntelliJ IDE MySQL Database Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you are still intent on getting a book then it may be better to start a new thread with a different subject.
In that thread I think it would be wise to post some of your background and what you wish to accomplish what technology/language/framework you would like to use.
You could also list some resources that you researched and ask to help selecting the best resource to get started.

Once again, I suggest you start with the free tutorials and YouTube to see what is out there for that technology/language/framework.
If you find out about feature that you particularity want to use or take advantage of after using the free resources then you could spend the money on a resource and this could influence goals.
 
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic