deGoogle

732 readers
1 users here now

founded 2 years ago
MODERATORS
26
27
 
 

I currently keep track of which model kits, brick building sets, and painting miniatures that I own and whether I have made progress on them in a Google Sheet. As part of my attempt to degoogle, I am looking into various alternatives.

My current preferences for an alternative are:

  • Accessible online
  • Can be edited online/in-browser (potentially through some frontend)
  • Loads relatively quickly/efficiently
    • Hardware is an issue here; my server computer is quite low end
  • Accessible on an Android device (does not have to be able to be edited on mobile)
  • Preferably can display linked images, whether on Nextcloud's filesystem or through hyperlinks

One of the alternatives I've already tried is the Nexcloud Office plugin for my existing Nextcloud server using Collabora Online as a backend. In addition to it loading quite slowly, I had issues editing any files created with the plugin, and after tinkering with it for a while I decided to put that solution aside. This was several months ago.

Another alternative I have considered is coverting this sheet into a database. I do not have much experience with databases (pretty much just creating one in MariaDB for Nextcloud), but from what I know about them this seems like a good use case for one. I do not know what would be best as a frontend; phpMyAdmin? DBeaver?

Any suggestions? If all else fails, I'll just keep an .ods document on Nexcloud and install LibreOffice Viewer on my phone, but I would prefer not to have to download and upload the .ods through Nextcloud every time I want to update my inventory (this is primarily an issue when I update it at work).

 

This is what I currently use:

Screenshot of a Google Sheet doc with information on multiple model kits

Markdown table with data type guesses if image does not load

Name Number Brand Grade/Type Line Year Image/Link Scale Retail Price Paid Assembled? Painted Yen
Gundam Barbatos Lupus (ASW-G-08) 5055446 Bandai HG (High Grade) I-BO 2016 [Formula1] 1/144 [Formula2]/[USD Retail] $10.19 Y/N/'- Y/N/'- 1000
[TINYTEXT] [VARCHAR] [TINYTEXT] [TINYTEXT] [TINYTEXT] [YEAR] [TEXT] [FLOAT]/[SMALLINT]/[TINYTEXT] [DECIMAL] [DECIMAL] [BOOLEAN] [BOOLEAN] [SMALLINT]

There are only a few formulae used:

  • One to both link to a webpage for that kit and display an image of it; these could be easily separated into two fields
    Formula 1: =HYPERLINK("https://bandai-hobby.net/item/5886/",IMAGE("https://bandai-hobby.net/images/157_5886_s_5pwg9tvxlm5v4gwrz49ly8ry3j8e.jpg"))
  • One to convert the Japanese retail of a product (in the Yen column) to equivalent USD in the release year (could easily be replaced with a manual conversion or a researched US retail)
    Formula 2: =M36&"円 / $"&TEXT(M36*VLOOKUP(F36,'Currency Rates'!$A$2:$B$52,2,FALSE),"#,##0.00")
  • And one to grab the current average conversion rate for the year (again, could be replaced with a quick search)
    Formula 3: =QUERY(GOOGLEFINANCE("CURRENCY:JPYUSD","price",DATE(A47,1,1),IF(DATE(A47,12,31)-TODAY()>0,TODAY(),DATE(A47,12,31)),"DAILY"),"select avg(Col2) where Col1 is not null label avg(Col2)''",1)

This last formula is used on a conversion sheet referenced in Formula 2, which looks like this:

Screenshot of a Google Sheet doc with historical JPY-USD conversion rates sorted by year

I appreciate any help.

28
29
 
 

Let 2026 the year to really write... I want to start with an update on my apps as I (and we) use everyday our smartphones. And a smartphone without Google shit on it is always better.

30
 
 

The hope is that this guide and website can act as a simple way to introduce newcomers - whether it’s you, friends or family - into this space and try something else besides the default options.

There is also a community-driven, open-source site ( https://purchasewithpurpose.io/category/email/ ) that aims to make this even easier. This includes screenshots, ratings and a larger feature list.

I’ve also started tracking impact to help keep the momentum. If there are any other stats, please share them so I can add them to the guides and, eventually, the website.

OC by @FallenWalnut@lemmy.world

31
32
 
 

Here's my Christmas gift for the community: a Firefox add-on that transforms links to create new Google Calendar events into ICS files you can import in your favorite calendar application.

Developer @BlackEco@lemmy.blackeco.com

33
 
 

Search with SearXNG natively on Android.

Source: https://codeberg.org/Linerly/searxist

34
 
 

I know most of the answers here, prefer Gecko over Chromium because Google is a monopoly, but honestly I would like to make the switch, the bad thing is that I still find the Firefox interface on Android old, I know it seems a bit silly to risk a little privacy for a comfortable and visually pleasing interface, but recently I saw that Chromium forks are even more secure than those using Gecko, that's why I still use Cromite

I take this opportunity to say that possibly the solution to this is WebLibre, a browser based on Gecko which is exactly what I'm looking for, unfortunately still in alpha but from what I've seen it's on the right track

35
7
submitted 4 months ago* (last edited 4 months ago) by david_@discuss.tchncs.de to c/degoogle@discuss.tchncs.de
 
 

Kagi (the search engine), where I am a customer, has just sent me this gift link, which up to three people can use to get three months of free access to Kagi.

If you decide to use it, please leave a note here so that others can know whether the link is still relevant: https://kagi.com/p/THANKSGIVINGB46565519A

36
 
 

I shared a version of this guide earlier this year, but felt a website was needed to unpack the different options fully. So after an unreasonable number of hours, I put together the necessary data and website.

I hope this is digestible enough for the average person to help those looking to take that first step, or for people who are equally passionate and want to get their friends or family involved.

Details:

Every time I post these guides, there is always feedback on things that can improve, or I got wrong. Please do share, as it is the best way for these to evolve!

OC by @FallenWalnut@lemmy.world

37
 
 

Google just can't stop being evil. Their latest ploy? Changing article headlines using AI. The results? Exactly as you'd expect.

38
39
40
 
 

Found this article, I think it's an interesting comparison

My source: https://mastodon.nz/@leighelse/115572223821306554

41
42
43
44
 
 

Hey everyone,

I have a promotion on my phone right now that is preventing me from unlocking my pixel to put GOS on. I can't unlock it until I pay it off.

I also noticed an option on T-Mobile in the US to temporarily unlock the device. Obviously this would be a loophole but my question is this:

Has anyone used the temporary unlock and been able to then OEM unlock the phone to install graphene?

OQB @ChocolateFrostedSugarBombs@lemmy.world

45
46
47
48
49
50
 
 

cross-posted from: https://discuss.tchncs.de/post/46277277

Recently Google decided that in the future for an app to be installable on an Android device, the developer of this app needs to be ID'd and registered at Google. They claim this is in order to "to better protect users". However, I think, this is a move to get more control over the Android ecosystem, and the data they can collect with it. If anyone who wants to develop an app for Android devices has to be registered with Google, this puts all the power of who to allow distributing an app to Google.

Furthermore F-Droid shows, that safe app stores can exist without registration, neither of users nor of developers. There is zero malware or spyware on the F-Droid store. What there is on F-Droid is thousands of beautiful, useful and, most importantly, safe apps. And this entire ecosystem is at risk, because Google wants to gain more control over its users and over the Android operating system.

view more: ‹ prev next ›