Repository navigation
blog/version-3-13-1-rc1-released/ #35
Description
Activity
I cannot find anywhere to download this
In the blog post (which you've replied to) should contain a bunch of assets.
For the avoidance of doubt, the blog post is here.
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.13.1-rc1So if you click that blog post (which you've replied to), do you see assets at the bottom of the page? You may need to scroll down as they're at the bottom of the page.
1 remaining item
@chrisjlocke It's a new account with almost no activity. Might just be a bot.
Reacted by Chris Locketab "Browse Data" , render all "Date" value as "0" / Null
But Version 3.13.0 is OK
@thechanon Are you able to share a database with us which has this happen for you?
Just so we can test if it happens when we try it, which will help us understand what's going wrong. 😄
@justinclift Yes. may you download example file from:
https://drive.google.com/drive/folders/1_inM9fH8kf06nEiz3xqZ7_OxgDE_mzdX?usp=sharing
@mgrojo Want to take a look? 😄
tab "Browse Data" , render all "Date" value as "0" / Null
But Version 3.13.0 is OK
Can you provide a screenshot?
Your database (https://dbhub.io/chrisjlocke2/example.db) seems OK to me.
Have you set a display format for the column? Can you provide a screenshot of what you've done?Yes. Please see capture image.
https://drive.google.com/file/d/1V_zvDYisgVkhGUBPwmnr2TKDAZYgYeLo/view?usp=sharing
Number (1) show: 2024-04-01
Number (2) show: 0Expected : Number (2) show the same content as Number (1)
Well, yes, that makes sense. You've used a 'DATE' data type, which isn't a sqlite standard. SQLite only knows about text, integer, real and blobs.
https://www.sqlite.org/datatype3.htmlCHAR(512) is also an unknown type.
Change it to text, and all is well again in the world. Birds continue to sing and dolphins squeak happily.
SQLite only knows about text, integer, real and blobs.
AGain, for the avoidance of doubt, this is a SQLite thing, which is the database layer, not a DB4S thing - its not like DB4S only supports certain types. So there is no fault in DB4S. Its not the applications fault. This is how SQLite works.
Reacted by Justin CliftIf you edit a table, DB4S handily gives you the field types it knows about
Although this is a free-type field, and you can put what you like in there, and SQLite even allows integer in text fields, text in integer fields and everything in between, the DB4S application is a bit more strict and only displays the text thingy properly for field types it knows are text fields. This is so it doesn't corrupt data. Its trying to be helpful.
Since updating I'm getting the following pop-up every time I open the application.
Unable to enumerate family ' "FantasqueSansMono Nerd Font Mono" 'Closing the pop-up, the application works well.
This is running on Windows 10, after having used the MSI-64 installation.
I tried (re)installing the following fonts, but the pop-up didn't go away:FantasqueSansMNerdFont-Bold.ttf FantasqueSansMNerdFont-BoldItalic.ttf FantasqueSansMNerdFont-Italic.ttf FantasqueSansMNerdFont-Regular.ttf FantasqueSansMNerdFontMono-Bold.ttf FantasqueSansMNerdFontMono-BoldItalic.ttf FantasqueSansMNerdFontMono-Italic.ttf FantasqueSansMNerdFontMono-Regular.ttf FantasqueSansMNerdFontPropo-Bold.ttf FantasqueSansMNerdFontPropo-BoldItalic.ttf FantasqueSansMNerdFontPropo-Italic.ttf FantasqueSansMNerdFontPropo-Regular.ttfInstead of installing the fonts, have you tried removing them?
Just to say that none of the download links on this blog post work (any more? probably did when it was written!) - this isn't a big issue as you can just click 'Download' in the top nav and get the files there. I'm only mentioning it because the app itself takes you to this page, not the download page, so it's a bit confusing for a moment as all the links 404.
Aah yes, we removed the download server and instead just relied on Github for storage. The blog post will ideally need amending...
Thanks for reporting. 😁👍I'm in a bit of a predicament with my SQLite database and could really use some advice. Here's what happened:
I regularly back up my SQLite database, either by copying or saving the file. Recently, my computer started consuming excessive memory while I was working on the database, leading to a scenario where the database file becomes unresponsive (displaying a transparent white screen). Usually, I just wait it out for about an hour and things go back to normal.
However, this time things took a turn for the worse. The database unexpectedly closed on its own. When I tried to reopen it, I was greeted with a "database is read-only" error and couldn't access my data. In the past, I've resolved similar issues by deleting the db-journal file, which allowed me to open the database from the last save point.
Before attempting any fixes this time, I copied both the database file and the journal file onto a different USB drive for backup. Then, I proceeded to delete the original journal file. Now, to my dismay, the database is only showing about one-third of the entries that were there before.
I still have the copied files (both the database and the journal) and am hoping there's a way to recover all of my data. Has anyone here faced a similar issue or knows how to resolve this? Any help would be immensely appreciated. I'm really hoping to get all my files back.
Version 3.13.1-rc1 released - DB Browser for SQLite
https://sqlitebrowser.org/blog/version-3-13-1-rc1-released/