In this post, you have learned to use it and take the first steps with it. This way we will be able to have a database of considerable sizes with an amazing speed. With SQLite we will have the certainty of using a good database manager but without spending too many resources. Now, you can start to work with SQLite on CentOS 8. Then, Check the results: > SELECT * FROM example 6.- Using SQLite on centOS 8 Then, you can insert some data: > INSERT INTO example(id,name,last_name) VALUES(1,'Angelo','Osradar)
> ) 5.- Creating a new table with SQLite on CentOS 8 Of course in daily work, these tables will be long and complex. :~$ sqlite3 example.db 4.- Creating a new database on SQLiteĪnd on it create a new table with a simple structure like the one I will do. If you want to create a new permanent database, you must exit the shell and execute the sqlite3 command followed by the name of the database to be created. At least at the beginning, it is good to do it. :~$ sqlite3 2.- Access to the SQLite command shellĪ second step I recommend is to show the SQLite help to know which commands we can apply. There you create a temporary database to start the work. To enter the SQLite command console, simply type the SQLite command. Then, proceed to install SQLite using the following command: :~# dnf install sqlite 1.- Install SQLite on CentOS 8Īt the end of the download to install will be ready for work. There is no native interface within WHM/cPanel to manage SQLite databases however at this time.
That module has support/drivers for SQLite: PHP: SQLite (PDO) - Manual. With this your system will be more secure and stable. In EasyApache youll want to enable phppdo for your version (s) of PHP. This way you will have all the security patches installed correctly in your system.
#How to install sqlite to php update
This makes the installation really simple.įirst, open a terminal and update the system: :~$ su In this new version of CentOS, we have a very recent version of SQLite in the official repositories. Finally, there is no need to worry about the data, because they are perfectly compatible with the popular MySQL or PostgreSQL.
0 kommentar(er)
