In this post we talk about SQLite so when you talk about the first question which is what is SQLite? So basically SQLite is a software in which you can write SQL queries, it’s a lightweight, no network access and embedded type of software in which you can use for different types of work. Second question, why we require SQLite? Now this is a bit tricky. We already have Oracle, we have post clips. Then why we require yet another DBMS or RDBMS? The thing is, if we talk about, Oracle this our client server what you say and if you talk about SQLite, this is stand alone. Now the problem is when you talk about this world now, so we are moving towards word which is called which is which will be working with which is Internet of Things. So everything around you will be Internet enabled, maybe your fans, your tube light, you’re AC, your fridge, your mobile phones. Your and anything you have, in fact, you'll watch. Now you can see Apple Watch. We have Samsung Gear, so we have all these devices which are connected with. Turn it right and somewhere these are intelligent devices in which you have a small amount of data. So example, let's say if I enter a room and if I if you have AC, so AC temperature will be changed depend upon the person, right? If a person let's say if I enter the room so I will be having a different temperature if my friend is entering the room. He will be getting a different temperature provided we are not in the we both are not in the same room at the same time on different timing. So your AC need to have something some data to calculate this. Now for the AC, you cannot have masculine stalled. You cannot have Oracle installed. So you can have SQL light switches installed. Which is lightweight, right? So you can have a small database inside those and that's why we require SQL Lite there. So first what is SQL Lite is just a software in which you can write SQL queries. Why we require ease? Because all these different dreams, they work with client server and they are bulky. To work with. How's it treason? Implement this. Now there's off Fished documentation provided by the team and they claim you can use SQL Lite anywhere provided that website or something. c. Example if you can use SQLite to build a website or you can do that, but the problem is if your website is getting. Around 1100 of 100,000 visits per day, that's OK. So where do we ask you like so we can use SQLite for embedded software? So let's say if you are building a project for embedded systems, so let's say you are building a project for maybe a telephone system maybe? I see on a fridge, so you can use a SQLite that when you're building an Android application. If you want to save huge amount of data, you can use masculine the server. Right, But if you want to save a small data from your Android, you can use SQLite as a database.
What is SQLite database used for?
SQLite is especially useful for a desktop application, such as your shop's accounts and books, or school records, or an oil company's. SQLite is in the form of a small file format. Which does not need to be installed. That is, when you sell any software to a customer after making it, there is no need to install Lite separately. It is in the form of a small file.
What is difference between SQL and SQLite?
SQLite is a sample database management system developed in ANSI-C. It does a limited job. And its function is to store, update, save and search data. We need it when we create a sample software.
what is sqlite database in android
First of all understand what is SQLite database in android So we already know this thing that the escalate is the lighter version. who do not know SQL, in a very common platform, database management is that of yours which means that which we call school in short form, full form is its structure query language means structure data store. Through query we can manage the data. This particular language is case sensitive and in this you can take and manage your database smoothly, so the lighter version of the same is already defined free inside Android.There are still platforms to win. If you worked in them, what do you do if you need a database make connections for example, connection which we do inside java, but in android there is no requirement to do some such connection, because android support itself and then define android be inside it i.e. whatever you If you also want to manage the data of your app, you can manage it internally help of database is fine then you should come for it so that you create database in one time, create tables in it, store your data in it and get your data modified. Now what exactly is an open source relational database? Now in the beginning we understood the meaning of open source, what is open source? Open for all and license free means you can design this particular platform according to your own and you do not have to give any license to use it. And what is the meaning of relational that you store multiple data which are stored in tables and you can produce a result data by creating relation in them. For example you have different data inside multiple tables, but you can combine these tables and produce one result data Combine into and more tables then we call this process or this particular process as relational. So these are some basic points.