Mixing
how to connect sqlite database with an android project
I have created an SQLite database by using DB Browser for SQLite.
I want to connect this database with my android project ..
So, where should I put it ? in which folder of my project ?
and how can I connect them together ? just with SQLiteOpenHelper ?
android sqlite 
android-studio asked Nov 22 '18 at 12:16
NoorNoor
103
add a comment |
I have created an SQLite database by using DB Browser for SQLite.
I want to connect this database with my android project ..
So, where should I put it ? in which folder of my project ?
and how can I connect them together ? just with SQLiteOpenHelper ?
android sqlite android-studio asked Nov 22 '18 at 12:16
NoorNoor
103
5
Possible duplicate of How and where to add sqlite(.db) file in to an android project
– Ali
Nov 22 '18 at 12:19
check this stackoverflow.com/questions/513084/…
– Karan Mer
Nov 22 '18 at 12:19
Welcome to StackOverFlow, please look at the link : stackoverflow.com/help/how-to-ask
– Arash GM
Nov 22 '18 at 12:19
You really have to search before asking. If you did, you'd find an answer less than in a minute
– Vladyslav Matviienko
Nov 22 '18 at 12:24
add a comment |
I have created an SQLite database by using DB Browser for SQLite.
I want to connect this database with my android project ..
So, where should I put it ? in which folder of my project ?
and how can I connect them together ? just with SQLiteOpenHelper ?
android sqlite android-studio asked Nov 22 '18 at 12:16
NoorNoor
103
I have created an SQLite database by using DB Browser for SQLite.
I want to connect this database with my android project ..
So, where should I put it ? in which folder of my project ?
and how can I connect them together ? just with SQLiteOpenHelper ?
android sqlite android-studio android sqlite android-studio asked Nov 22 '18 at 12:16
NoorNoor
103
asked Nov 22 '18 at 12:16
NoorNoor
103
asked Nov 22 '18 at 12:16
NoorNoor
103
asked Nov 22 '18 at 12:16
NoorNoor
103
asked Nov 22 '18 at 12:16
NoorNoor
103
103
5
Possible duplicate of How and where to add sqlite(.db) file in to an android project
– Ali
Nov 22 '18 at 12:19
check this stackoverflow.com/questions/513084/…
– Karan Mer
Nov 22 '18 at 12:19
Welcome to StackOverFlow, please look at the link : stackoverflow.com/help/how-to-ask
– Arash GM
Nov 22 '18 at 12:19
You really have to search before asking. If you did, you'd find an answer less than in a minute
– Vladyslav Matviienko
Nov 22 '18 at 12:24
add a comment |
5
Possible duplicate of How and where to add sqlite(.db) file in to an android project
– Ali
Nov 22 '18 at 12:19
check this stackoverflow.com/questions/513084/…
– Karan Mer
Nov 22 '18 at 12:19
Welcome to StackOverFlow, please look at the link : stackoverflow.com/help/how-to-ask
– Arash GM
Nov 22 '18 at 12:19
You really have to search before asking. If you did, you'd find an answer less than in a minute
– Vladyslav Matviienko
Nov 22 '18 at 12:24
5
5
Possible duplicate of How and where to add sqlite(.db) file in to an android project
– Ali
Nov 22 '18 at 12:19
Possible duplicate of How and where to add sqlite(.db) file in to an android project
– Ali
Nov 22 '18 at 12:19
check this stackoverflow.com/questions/513084/…
– Karan Mer
Nov 22 '18 at 12:19
check this stackoverflow.com/questions/513084/…
– Karan Mer
Nov 22 '18 at 12:19
Welcome to StackOverFlow, please look at the link : stackoverflow.com/help/how-to-ask
– Arash GM
Nov 22 '18 at 12:19
Welcome to StackOverFlow, please look at the link : stackoverflow.com/help/how-to-ask
– Arash GM
Nov 22 '18 at 12:19
You really have to search before asking. If you did, you'd find an answer less than in a minute
– Vladyslav Matviienko
Nov 22 '18 at 12:24
You really have to search before asking. If you did, you'd find an answer less than in a minute
– Vladyslav Matviienko
Nov 22 '18 at 12:24
add a comment |
1 Answer
1
active
oldest
votes
So, where should I put it ? in which folder of my project ?
Typically you'd put the database file into the assets folder or within a folder within the assets folder.
how can I connect them together ? just with SQLiteOpenHelper ?
You would typically then connect to the database after copying the database from the assets folder to a suitable location (easiest place is in data/data//databases).
Although you could do the above via a subclass of SQLiteOpenHelper, there is a simpler way by using Android SQLiteAssetHelper. Instructions are in the README.
- Note the database file needs to be copied into the assets/databases folder as that is where SQLiteAssethelper expects the file to be.
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53430832%2fhow-to-connect-sqlite-database-with-an-android-project%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
So, where should I put it ? in which folder of my project ?
Typically you'd put the database file into the assets folder or within a folder within the assets folder.
how can I connect them together ? just with SQLiteOpenHelper ?
You would typically then connect to the database after copying the database from the assets folder to a suitable location (easiest place is in data/data//databases).
Although you could do the above via a subclass of SQLiteOpenHelper, there is a simpler way by using Android SQLiteAssetHelper. Instructions are in the README.
- Note the database file needs to be copied into the assets/databases folder as that is where SQLiteAssethelper expects the file to be.
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
add a comment |
So, where should I put it ? in which folder of my project ?
Typically you'd put the database file into the assets folder or within a folder within the assets folder.
how can I connect them together ? just with SQLiteOpenHelper ?
You would typically then connect to the database after copying the database from the assets folder to a suitable location (easiest place is in data/data//databases).
Although you could do the above via a subclass of SQLiteOpenHelper, there is a simpler way by using Android SQLiteAssetHelper. Instructions are in the README.
- Note the database file needs to be copied into the assets/databases folder as that is where SQLiteAssethelper expects the file to be.
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
add a comment |
So, where should I put it ? in which folder of my project ?
Typically you'd put the database file into the assets folder or within a folder within the assets folder.
how can I connect them together ? just with SQLiteOpenHelper ?
You would typically then connect to the database after copying the database from the assets folder to a suitable location (easiest place is in data/data//databases).
Although you could do the above via a subclass of SQLiteOpenHelper, there is a simpler way by using Android SQLiteAssetHelper. Instructions are in the README.
- Note the database file needs to be copied into the assets/databases folder as that is where SQLiteAssethelper expects the file to be.
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
So, where should I put it ? in which folder of my project ?
Typically you'd put the database file into the assets folder or within a folder within the assets folder.
how can I connect them together ? just with SQLiteOpenHelper ?
You would typically then connect to the database after copying the database from the assets folder to a suitable location (easiest place is in data/data//databases).
Although you could do the above via a subclass of SQLiteOpenHelper, there is a simpler way by using Android SQLiteAssetHelper. Instructions are in the README.
- Note the database file needs to be copied into the assets/databases folder as that is where SQLiteAssethelper expects the file to be.
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
answered Nov 22 '18 at 19:14
MikeTMikeT
16.9k112642
16.9k112642
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
add a comment |
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
Where is the assets folder? I couldn`t find it .. also data/data
– Noor
Nov 25 '18 at 7:49
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
You may need to create assets folder app/main/src if using AssetHelper no need to worry about looking for data/data it will place the db into it. As it basically uses getDatabasepath() method, which will result in data/data/package_name/databases/
– MikeT
Nov 25 '18 at 20:09
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53430832%2fhow-to-connect-sqlite-database-with-an-android-project%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
5
Possible duplicate of How and where to add sqlite(.db) file in to an android project
– Ali
Nov 22 '18 at 12:19
check this stackoverflow.com/questions/513084/…
– Karan Mer
Nov 22 '18 at 12:19
Welcome to StackOverFlow, please look at the link : stackoverflow.com/help/how-to-ask
– Arash GM
Nov 22 '18 at 12:19
You really have to search before asking. If you did, you'd find an answer less than in a minute
– Vladyslav Matviienko
Nov 22 '18 at 12:24