C
C#12mo ago
ayman

❔ Database

Anyone knows a local .sqlite database module ?
19 Replies
Angius
Angius12mo ago
Just search "sqlite" on nuget
ayman
ayman12mo ago
Yeah but they use sql language
Angius
Angius12mo ago
And what would you like to use instead? If you want to avoid writing SQL, use EF Core with the SQLite driver
ayman
ayman12mo ago
C# I need an equivalent of mongoose
Denis
Denis12mo ago
Use ef core
ayman
ayman12mo 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
Angius12mo 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
Angius12mo 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
Angius12mo ago
Yeah, "relational" is right
jcotton42
jcotton4212mo ago
be aware that sqlite is a relational database it is not a document database like mongo
ayman
ayman12mo ago
Yeah I know Closer to Quickdb I guess
Joreyk ( IXLLEGACYIXL )
litedb would be an easy document database and very easy to use
jcotton42
jcotton4212mo ago
(most of the time you want a relational db tho, aiui)
Mayor McCheese
Mayor McCheese12mo ago
Document databases are drastically overused and frequently poorly used. ( opinion )
Angius
Angius12mo ago
100%
Accord
Accord12mo 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.