C
C#2y ago
ayman

❔ Database

Anyone knows a local .sqlite database module ?
19 Replies
Angius
Angius2y ago
Just search "sqlite" on nuget
ayman
aymanOP2y ago
Yeah but they use sql language
Angius
Angius2y ago
And what would you like to use instead? If you want to avoid writing SQL, use EF Core with the SQLite driver
ayman
aymanOP2y ago
C# I need an equivalent of mongoose
Denis
Denis2y ago
Use ef core
ayman
aymanOP2y ago
Arlight
Joreyk ( IXLLEGACYIXL )
sqlite database is a file based database, it decides how to store and read stuff, but it doesnt do anythign on its own you need to interact with your "database" .. for column based databases its SQL frameworks can put a layer on top so it writes the sql for you
Angius
Angius2y ago
Since when is SQL a column db?
Joreyk ( IXLLEGACYIXL )
SQL == Structured Query Language, its for talking between 2 sources SQLITE can understand SQL
Angius
Angius2y ago
Yeah, but SQLite isn't a column-based database It's, like, an actual specific term in the database world Like document databases, graph databases, etc
Joreyk ( IXLLEGACYIXL )
its a "relational database" was wrong term
Angius
Angius2y ago
Yeah, "relational" is right
jcotton42
jcotton422y ago
be aware that sqlite is a relational database it is not a document database like mongo
ayman
aymanOP2y ago
Yeah I know Closer to Quickdb I guess
Joreyk ( IXLLEGACYIXL )
litedb would be an easy document database and very easy to use
jcotton42
jcotton422y ago
(most of the time you want a relational db tho, aiui)
Mayor McCheese
Document databases are drastically overused and frequently poorly used. ( opinion )
Angius
Angius2y ago
100%
Accord
Accord2y ago
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.

Did you find this page helpful?