How to make a database that is integrated within the application?
-
I'm fairly new to programming especially ones that use database. I can make software that use database but only with .NET and using MySql with XAMPP. However I'm still trying to figure out how to do that in Java because I'm currently learning the language. However I saw this application which is an application for saving solve times for rubik's cube speedsolves. The software is called Prisma Puzzle Timer. [Download] The software generates a file with the .db extension on first run in the same directory of the .jar file. I assume this is the database. My question is how can this be done? And what type of database is it? (the .db file extension) Although the said software is open source, I don't have enough knowledge to understand the source to even find where the database creation is implemented (though I'm still trying to read through the source and I'm still in my learning phase in Java programming).
I think what you mean is to have an embedded database in your application. Well in that case, you have a number of choices. I would suggest you look at [Hypersonic SQL^]. It is lightweight and quite mature. Another option is to look at [Sqlite^]. I have not used it in a Java project before, but it is quite a nice and fast little database.
-
I think what you mean is to have an embedded database in your application. Well in that case, you have a number of choices. I would suggest you look at [Hypersonic SQL^]. It is lightweight and quite mature. Another option is to look at [Sqlite^]. I have not used it in a Java project before, but it is quite a nice and fast little database.
-
The .db extension on the file tells us nothing, because it depends on the program that is generating it as to what format it takes. If you are interested in using databases from Java, and Java itself, then your time would be better spent studying the Java Tutorials[^].
Ah, yes. I just got familiar with that file extension meaning nothing. I actually tried The Java Tutorials but I had a hard time understanding everything there. Perhaps I didn't had enough programming experience yet because I think they assume you've had C++ knowledge already. So I'm currently learning Java with other tutorials. Anyway I'm familiar with MySql.
-
I think what you mean is to have an embedded database in your application. Well in that case, you have a number of choices. I would suggest you look at [Hypersonic SQL^]. It is lightweight and quite mature. Another option is to look at [Sqlite^]. I have not used it in a Java project before, but it is quite a nice and fast little database.
Thanks! I will try to have a look at HyperSonic SQL. Hope this will work for me.
-
Alright I'll also read about this. Thanks. :thumbsup:
-
Ah, yes. I just got familiar with that file extension meaning nothing. I actually tried The Java Tutorials but I had a hard time understanding everything there. Perhaps I didn't had enough programming experience yet because I think they assume you've had C++ knowledge already. So I'm currently learning Java with other tutorials. Anyway I'm familiar with MySql.
extranghero wrote:
I had a hard time understanding everything there. Perhaps I didn't had enough programming experience yet because I think they assume you've had C++ knowledge already.
No, you should be able to work through those tutorials without any previous programming experience. The introduction starts from the very basic concepts.
-
I'm fairly new to programming especially ones that use database. I can make software that use database but only with .NET and using MySql with XAMPP. However I'm still trying to figure out how to do that in Java because I'm currently learning the language. However I saw this application which is an application for saving solve times for rubik's cube speedsolves. The software is called Prisma Puzzle Timer. [Download] The software generates a file with the .db extension on first run in the same directory of the .jar file. I assume this is the database. My question is how can this be done? And what type of database is it? (the .db file extension) Although the said software is open source, I don't have enough knowledge to understand the source to even find where the database creation is implemented (though I'm still trying to read through the source and I'm still in my learning phase in Java programming).
Hello Dear Friend, I'm also having the same question. When you got to know the answer or code for this please do share it with me.
Gokul Gawande
-
Hello Dear Friend, I'm also having the same question. When you got to know the answer or code for this please do share it with me.
Gokul Gawande
Well I think I'll settle with HyperSQL. I downloaded it. Comes with a nice documentation and that's what I'm reading now to learn it. I discovered the embedded database I saw on the example on my original post was something called H2. I think it's similar.
-
I think what you mean is to have an embedded database in your application. Well in that case, you have a number of choices. I would suggest you look at [Hypersonic SQL^]. It is lightweight and quite mature. Another option is to look at [Sqlite^]. I have not used it in a Java project before, but it is quite a nice and fast little database.
A great thing about SQLite is the licence agreement which includes the text "Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original SQLite code, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means." Nice to have that kind of freedom.