5 Replies - 589 Views - Last Post: 25 February 2020 - 08:17 PM Rate Topic: -----

#1 Field Dog   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-March 16

How to Create a Database

Posted 21 February 2020 - 09:39 AM

I would like some advice on how to create a database so I can recall latitudes and longitudes for manual input into Google Maps. I have one hundred and ninety three lakes that I check for their respective water elevations. Eventually I'd like to create a program that not only automatically inputs said data, but also launches Google Maps. Finally, the program will allow me to record the lake elevations into the database.
Is This A Good Question/Topic? 0
  • +

Replies To: How to Create a Database

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15564
  • View blog
  • Posts: 62,309
  • Joined: 12-June 08

Re: How to Create a Database

Posted 21 February 2020 - 09:59 AM

Databases can come in all forms. Ones that require serverish setups like MSSQL, MySQL, or MariaDb. Others that are local like SQLite, Access, or the even a text file.

So it depends on your platform, single/multiuser reqs, and availability needs.
Was This Post Helpful? 1
  • +
  • -

#3 ndc85430   User is offline

  • I think you'll find it's "Dr"
  • member icon

Reputation: 994
  • View blog
  • Posts: 3,901
  • Joined: 13-June 14

Re: How to Create a Database

Posted 21 February 2020 - 11:16 AM

Specifically on the JVM, there are also (SQL) databases that you can embed in your application. See, e.g. this.
Was This Post Helpful? 1
  • +
  • -

#4 Field Dog   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 26-March 16

Re: How to Create a Database

Posted 21 February 2020 - 01:38 PM

View Postmodi123_1, on 21 February 2020 - 09:59 AM, said:

Databases can come in all forms. Ones that require serverish setups like MSSQL, MySQL, or MariaDb. Others that are local like SQLite, Access, or the even a text file.

I have an Excel file with all my lake info in it.

So it depends on your platform, single/multiuser reqs, and availability needs.

My platform is a Windows 8.1 laptop, single user, and what do you mean by availability needs? Thanks for replying!


View Postndc85430, on 21 February 2020 - 11:16 AM, said:

Specifically on the JVM, there are also (SQL) databases that you can embed in your application. See, e.g. this.

Thanks for the info and for replying!

Was This Post Helpful? 0
  • +
  • -

#5 ndc85430   User is offline

  • I think you'll find it's "Dr"
  • member icon

Reputation: 994
  • View blog
  • Posts: 3,901
  • Joined: 13-June 14

Re: How to Create a Database

Posted 22 February 2020 - 01:32 AM

For completeness, though not necessarily things you need to explore right away:

1. These days, "database" doesn't just mean SQL. There are other kinds that have uses that they're more suited for.

2. Even if one were to choose a datsbase that has a server, set up of these can be made quite simple by using Docker.
Was This Post Helpful? 0
  • +
  • -

#6 victorman   User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 27
  • Joined: 03-July 18

Re: How to Create a Database

Posted 25 February 2020 - 08:17 PM

Like ndc said you can get a database up very quickly using docker.

I can't comment on which database is right for your project. It's clear you want to keep the data that you create, which i don't believe docker is known for permanance, although you can export your containers to share and whatnot.

You really can't go wrong with mysql, it works. it works with java. a lot of people know it, which translates to not having a shortage of online resources or folks to answer questions.

these should help you get up and running on mysql in docker:
https://dev.mysql.co...ng-started.html
https://dev.to/sandr...ur-java-app-jpn

use JDBC in your java code to communicate with your database:
(if using docker, run the mysql installer and do a custom install then only select Jconnector, and optionally mysql workshop for a great debugging tool, and skip mysql server)
https://www.ntu.edu....JDBC_Basic.html

those are really all the best resources i used to get started.

For a good docker introduction check out this video by engineer man: https://youtu.be/6aBsjT5HoGY

really. you can start programming java code for mysql database tonight.

This post has been edited by victorman: 25 February 2020 - 08:19 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1