How to query sql file without DBMS?

A

Anton @ Lyalin2017-03-29 09:16:46

Java

Anton @ Lyalin, 2017-03-29 09:16:46

There is an application which uses a local database. DBMS is not necessary to me. Therefore, JDBC is also not needed. How to read sql file and pull out certain information?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

A

ayazer, 2017-03-29
@toxa_1995

the most common embedded database is, it does not need a separate server to work. all the necessary information is stored in one file. And most likely it is SQLite, with drivers for which there will be no problems. To check - you can download some SQLite Manager and just try to open that file with it. If it does not work, then it will already be necessary to sit down and conduct a detailed analysis.

E

Eugene Khrustalev, 2017-03-29
@eugenehr

what is sql file and what does it mean uses local database. and DBMS is not necessary to me!!! ?

D

Dmitry Alexandrov, 2017-03-29
@jamakasi666

What do you mean by "make queries to sql file without sdb". It is "requests" that initially imply that the DBMS will work with these "requests". If you just need to get inside the text version of the .sql file, then this is already a regular text file and you can parse it as you like, but no "select * from some_table where name=example" will work and never will. Only by hardcore handles sorting out what is from where and where, but if you still make a certain query format, then congratulations, you have your own bike in the form of your own DBMS implementation without JDBC.