josefnemec / litedbexplorer Goto Github PK

Add option to preview content of document or file without opening it. Display preview of document just when selecting it from main view.

Fields are currently order by name, which might not be wanted behavior. This will add option to choose between ordering fields by name or to respect position in original BSON documents.

Originally requested in #7

Installed version has problem with storing/modifying files in Program Files, please move storing files to user profile then...

This happens when trying to open db file via the Open file dialog.

I made some (a bit) changes to my fork.
Compile and run and see if you like it for a pull request or I follow standalone.

The next step will be a large refactor to allow tabs...

Note: This fork uses private fields camelCase with underscore.

I was able to load a database once, but now I just get errors.

When I try and load a database using File->Open I get:

Failed to open database: Access to the path 'C\Program Files (x86)\LiteDbExplorer\recentfiles.txt' is denied.

When I try to load the same database using the recent files drop down list I get:

Unhandled exception occurred.
Additional information written into: 'C\Program Files (x86)\LiteDbExplorer\explorer.log'
Application will shutdown.

I check the path for explorer.log but it doesn't exist.

I think these settings and log files should be written to app data or something like that instead of program files.

When the LiteDB has a value of {"$numberDecimal":"95.00"} in the field it will not show it in your Explorer

Hi @JosefNemec, first, nice work here. Thanks for contribute with open source community and LiteDB.

I'm working on next LiteDB and now I'm adding (back) support to shell commands inside LiteDB.dll. And I'm doing this to any LiteDB IDEs runs string commands. Support shell command will be great as used in Robomongo (https://robomongo.org/).

I always wanted create a GUI app to LiteDB, but I never worked with WPF 😄

Is there a recommended way to run LiteDbExplorer on macOS? Thanks.

Are there any plans to create an import process for exported data?

Hello,

The software is great.
It will be awesome if under each collection we can see all indexes of the collection.

Thanks again for made the software on your spare time. :)

Double-clicking a file (when associated to open using LiteDbExplorer) is a lot quicker than using the file open browse dialog.

Cool app, for quick look inside db.
Things im missing, ideas to improve - files metadata displayed, and if I click open to edit them it doesnt show anything.
remember last opened db when I reopen app.
paging of items when lots of them (using skip take from lite db.)- pagesize parameter in ui.
Longer future - Make it portable in .net core.

Best Regards

This is a fantastic tool. Thanks much. Wondering if you had any plans to allow for saving/loading of queries within the tool? Would be convenient instead of copying/pasting.

Currently it's not possible to edit values on multiple documents via single change. This issue will add bulk editing, which will allow to select multiple documents and apply changes from one edit dialog to all of them.

Hi, I built the version and also tested it under Portable (binaries) the result is the same:
no resizing, window maximized, something is not working in the Aero-UI screen.

Add option to copy documents, between collections and between different databases.

Hi.
Will MacOS be supported?
Is they any plan to make a build for MacOS?

Great program! When an exception is thrown though, the error message says "Unhandled exception occured. Additional information written into 'C:\Program Files (x86)\LiteDbExplorer\explorer.log'". First, the log file does not exist, which I would guess is because of the second problem, which is that Program Files folders are not supposed to be written to, and cannot be written to if the program is not running under an admin user. Data like log files should be written to an AppData folder.

Looks like the editor correctly highlights lines preceded with a double-dash, i.e. "--" in green, or between "/" and "/", thereby indicating they are recognized as comments. However, when pushing F5, the tool does attempt to run that as code and the comment does not get ignored, hence the following error would appear:

Error on Query 1:
'db.--'
Command 'db.--' is not a valid shell command.

Would be great to ignore commented out lines/blocks

Is this normal when the Cyrillic characters here are displayed? Is there anything you can do about it?

Hello,

is it possible to add a refresh option? I am developing an application and I can never see what I am doing. Opening the same database file again doesn't update it, F5 doesn't update it, there is no update button in the toolbar, there is no update item in the menu, no update item in the context menu of the database... I have to exit and start the program over and over again.

Thanks! Love the program so far!

Search currently doesn't allow any advanced search expressions. Probably implement (take) functionality from LiteDB shell's find function

Originally requested in #7

I have a simple test database generated by the following code. The problem is that when I delete all 4 records in LiteDbExplorer and then click "Refresh" button the last two reappear. For some reason the fields generated by DateTime.Now cannot be deleted.

public class LogSample
   {
       [BsonId]
       public DateTime Time { get; set; }
       public string Notes { get; set; }
   }

class Program
   {
       static void Main(string[] args)
       {
           using (var db = new LiteDatabase("Test.db"))
           {
               var collection = db.GetCollection<LogSample>("TestCollection");

               collection.Insert(new LogSample { Time = new DateTime(2017, 1, 1), Notes = "Note 1" });
               collection.Insert(new LogSample { Time = DateTime.Today, Notes = "Note 2" });
               collection.Insert(new LogSample { Time = DateTime.Now, Notes = "Note 3" });
               collection.Insert(new LogSample { Time = DateTime.Now.AddDays(-1), Notes = "Note 4" });

               var allEntries = collection.FindAll();
               foreach (var entry in allEntries)
               {
                   Console.WriteLine("Log entry: " + entry.Time + " " + entry.Notes);
               }
               Console.ReadKey();
           }
       }
   }

I have an existing LiteDB database.The moment i select the DB to open LiteDB explorer crashes.

Hi. I have strange behavior when it comes to editing data directly with LiteDb Explorer. When I try to modify existing row in random table, and then try to fetch that row from my WPF client application I get following exception:

This happens every time I try to temper with data directly through LiteDb Explorer. Looking at my code, I'm not using indexes at all (in my repository layer) since most of the tables will have no more then 10 rows in real life. I have to drop whole table and re-populate it using my WPF app. Any thought on this?

Thanks,

Bane

Explorer currently loads all items from collection into view. Implement some kind of lazy loading mechanism or limit view to pages with only limited number of items display at a time.

Implement search function, at least in root documents.

Are there any plans to support version 5? This tool beats the hell out of LiteDB Studio, but not being able to use it with version 5 makes it unusable for me :(

Currently you have to open new window. Adding simple expander will make it easier to preview nested documents.

Originally requested in #7