A
A
Alexey Smirnov2018-11-10 21:35:30
SQLite
Alexey Smirnov, 2018-11-10 21:35:30

What is the advantage of SQLite over Excel?

Now I use Excel files to store time series data (for example, exchange rates, the MICEX index, etc.). To read and write data, I access Excel files through Python, C# and R code.
I thought about using SQLite to store data. But I don’t know what benefit I will get for myself from switching to SQLite (instead of Excel). I'm just wondering if it's worth learning SQL and switching to SQLite or not.
What are the benefits and disadvantages of switching to SQLite?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
D
DevMan, 2018-11-10
@ERAFY

the advantage of sqlite is that it is free, embedding, and, in fact, sql.
if you use excel only for yourself and it suits you, then you don't need the advantages of sqlite.

D
Dimonchik, 2018-11-10
@dimonchik2013

Advantage of SQLite - in SQL

A
Adamos, 2018-11-10
@Adamos

Now I ride in a wheelchair from Microsoft, and I have enough.
I thought about getting out of the wheelchair and trying to walk on my feet.
But I don't know what benefit I will get for myself.
I'm just wondering if it's worth trying or not.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question