mbdavid/LiteDB

LiteDB - A .NET NoSQL Document Store in a single data file - www.litedb.org

Tim Moore

@tjmoore

I know LiteDB is probably not ideal for this, but is there any advice on deployment on a active/standby cluster?

Due to customer requirements project I'm working on has been deployed this way and the .db files are replicated to the standby. Failover occurs and in theory it picks up on the standby.

It appears to work in testing but there's concern that it may not be robust and have reports of some issues that haven't been reproduced (and no errors logged). May be totally unrelated, but want to check if anyone has deployed on such a cluster set up.

Long term the aim is to implement Mongo DB or similar for this.

Alex Sinitsky

@thryl

Hey guys, getting an exception while trying to do thebase.Insert(rec) - "this page should be in slot #0". Interestingly, the exception isn't thrown in debug, and Insert actually works correctly. I've checked why does it throw and found out the slot is 1 instead of 0, thus ENSURE throws an exception. Does anybody know what might be the issue here?

Paramjit Singh

@HobDev

Hello all

I want to save ordered items by date in LiteDb like this

IEnumerable<Destination> orderedList = destinations.OrderBy(d => d.TripStartDate);
tripContext.Destinations.Insert(orderedList);

But when I access the Destinations in the app it is not in correct order by StartDate

Am I doing something wrong. Please help

Matthew Oh

@newbiz90:matrix.org

[m]

image.png

1 reply

Shahab Ouraie

@th3r0b0t

Hello everyone @/all
I'm new to whole this, so plz correct me if I'm wrong:
1- A poco class when inserts into DB known as a Document;
2- If a poco class contains an object property of another poco class, this is a SubDocument;

Questions:
1- Does $ symbol refers to the main poco class/Document when used in LINQ-expressions?
2- Whats different between SELECT $ from students and SELECT * from students (Basically * and $)?
3- Whats is and the difference between Collection and Document ?

tnx in advance; Couldnt find out through docs...

ariana strangelove

@dangergrrl:matrix.org

[m]

Hi :)

oh nvm, i can read the source

Scott Wolf

@wolfson292

Is there any method to run a repair on a database. I am getting the following exception when trying to open a file.

System.Exception: LiteDB ENSURE: ReadFull must read PAGE_SIZE bytes [4096]
   at LiteDB.Constants.ENSURE(Boolean conditional, String message)
   at LiteDB.Engine.DiskService.ReadFull(FileOrigin origin)+MoveNext()
   at LiteDB.Engine.WalIndexService.<>c__DisplayClass19_0.<<CheckpointInternal>g__source|0>d.MoveNext()
   at LiteDB.Engine.DiskService.Write(IEnumerable`1 pages, FileOrigin origin)
   at LiteDB.Engine.WalIndexService.CheckpointInternal()
   at LiteDB.Engine.WalIndexService.TryCheckpoint()
   at LiteDB.Engine.LiteEngine.Dispose(Boolean disposing)
   at LiteDB.Engine.LiteEngine..ctor(EngineSettings settings)

Ilya Popov

@ijamon

@wolfson292 LiteDB Studio?

Hi guys, could you help. How can i do postgres-like "DO NOTHING" for Upsert on needed property?

Sébastien Duterte

@Feulito_gitlab

Hello guys !
I need some help with an error with a "LiteDB ENSURE exception : page type must be collection page".
Do you know how this error occurs ? Is it possible to get this error when the database is killed brutally (without dispose, for exemple) ?

@grofit

I am looking at integrating this with an existing project, so we already have data models etc but we already have a Guid based Id field, is there a way to hint/tell Lite DB to just use that field to be the id .

Not fussed if it duplicates the custom Id into _id or some other mechanism, I just need to be able to query on the Guid not the BsonValue based Id, although I appreciate I may externally use a Guid in my data access layer but internally it may have to just make a BsonValue on the fly or something...

Anyway any advice on this would be great as I assume its a common use case, just couildnt find much in the docs around it

@grofit

Also I have a query around dynamic style types, i.e I have a class with an interface property so when deserializing its not clear what C# type it is.

When I was using JSON.Net I had a custom JsonConverter which handled that part, but im not entirely sure here how to mimic that with LiteDB, historically all the data used to be pumped out to raw json files using JSON.Net so generally it seems a good fit for just moving each json file to be its own collection, but not quite sure how to work around that bit

@grofit

I have put a question about this on stack overflow so if anyone does read this and knows please put the answer in there https://stackoverflow.com/questions/73611168/any-way-to-mimic-jsonconverter-style-serializing-deserializing-of-complex-object

@grofit

For now im just going to introduce an intermediate JSON layer in our repositories which converts them into BsonDocuments and hope for the best :D

BuechnerA

@BuechnerA

Dim Result = m_Col.Find(Function(x) x.Name.StartsWith("F")).ToList
--> If an entry starting with "F" is found, I get this exception:

System.NullReferenceException: "The object reference was not set to an object instance.

--> If no entry starting with "F" is found, I get an empty list "Result" (LiteDB.LiteCollection(Of T)

Where is my problem? Thanks for quick help!

Sorry: list "Result" (List(Of T))

@grofit

are all the types correct in all the bits you use i.e all Generics match

and also are all the bits you expect to be populated/deserialized on the object populated in the collection store?

BuechnerA

@BuechnerA

I have found the cause: I had "only" a separate constructor with special parameters in the class and removed the standard constructor. Thanks for all the help.

Kevin Vuilleumier

@vekin03

Hello, thank you to all the team for this great project! I have two questions that I can't find the answer in the document, in the source code or in the issues...

How to write a SQL query with parameters in LiteDB?
I tried query.Where($"Name = @p0", "Arthur");, but it doesn't work. The parameter doesn't seem to be used.
However, it works well by doing query.Where(x => x.Name == "Arthur");

Kevin Vuilleumier

@vekin03

There is Query.Contains() but not Query.DoesntContains (or equivalent). How can we implement the expression "does not contain" with the Query class?

ChessSuite

@santafiora

Hi Guys i am completly new to litedb so my question is: Is there any compressing algo for Tabledata like huffman or on file basis ?

Sam Worth

@Ebandag203Worth_twitter

@mbdavid - how can I contact you directly?

Josh Burris

@joshburris2_gitlab

Is liteDB still being supported? See a number of PRs havent been merged in quite some time...

djcabrera

@djcabrera

There was a new release the other day: https://www.nuget.org/packages/LiteDB/

symphonic-navigator

@symphonic-navigator

hello

@mbdavid i would like to help you out with your questions regarding use of litedb but i can't answer them because none of the answers apply...

Ben Woodford

@BenWoodford

Yooo, we're using LiteDB for a long-running Windows Service and having a couple of issues. It seems sometimes our customers won't clean-shutdown their stuff which isn't really avoidable... we've had someone end up with a full drive so the log wasn't committing I guess, but they get this on restarting our service now (we run Rebuild to check for ENSURE errors, as we had someone stuff without the ability to run our application for no reason before as Inserts would fail... so if Rebuild fails we pull our data out and remake the DB entirely)

Rebuild operation requires no log file - run Checkpoint before continue

I've got a copy of their DB, but even running Checkpoint before Rebuild doesn't seem to actually achieve anything here? It still shows that error

RiddleTime

@RiddleTime

I like LiteDB, thank you!

I use it in one of my public repos, I think I weighted it against sqlite but I found LiteDB to be a lot more convenient.

Where communities thrive

People

Repo info

Activity