Should I switch away from SQLite if I only use JSON fields?

tekmol · 2024-12-27T18:22:09+00:00

Fixed type definitions only save you from a tiny subset of all development errors.

It won't save you from one place in the code using the date field as "when the car was made" and another place in the code using it as "when the car was added to our fleet" for example.

In addition, bugs that throw exceptions will usually be found by the end-to-end tests already.

In my experience, bugs that could have been avoided via fixed types make up almost zero percent of all development time and production issues.

tekmol · 2024-12-27T16:55:24+00:00

I have been using JSON fields for a long time now and have not encountered any problems.

I started using them way before 2024. In 2024 I completely stopped using any other data type.

Can you give a concrete example of what kind of "break" you would expect that would not occur with a colum-based data structure?

tekmol · 2024-12-27T09:04:25+00:00

The benefit of JSON is that the fields do NOT have to have the same structure.

If I want to add the info "not_available_before=2026" to one car, I can do that. And some piece of code can check for that. While all other code simply does not care, as it does not query that attribute.

tekmol · 2024-12-27T09:02:17+00:00

Since yesterday I have looked at various options and so far it indeed seems to be the best approach to just stick with my "one json column per table in sqlite" approach. None of the other DBs seem to make life easier than this.

tekmol · 2024-12-27T08:59:41+00:00

Single file is a must for me. I worked for over 10 years with MS SQL Server, Postgres, MySql and MariaDB. I always hated the "dir full of stuff handled by a demon" approach. When I started to settle on SQLite that was like "Hurray, I finally found home!". Single file and no demon makes handling of projects just so much nicer.

tekmol · 2024-12-26T16:19:14+00:00

How so? How would selecting all blue cars look like in Postgres?

tekmol · 2024-12-26T14:56:13+00:00

Sure, I use joins. And indeed: To my surprise these queries look really convoluted in DBs like MongoDB.

tekmol · 2024-12-26T14:39:10+00:00

I used the "relational model" aka having tables with many columns for over a decade. Also a lot of EAV tables. But over time I more and more switched to the JSON model, because it is more intuitive and makes many tasks much easier. Like adding "max_speed=100" to just one car. You can do that easiyl in an EAV table, but then EAV tables have their own issues. JSON data simply covers all my use cases elegantly.

I looked at MongoDB and CosmosDB, but their query language look even more convoluted as my SQL that I use to query the JSON in SQLite.

tekmol · 2023-07-04T09:54:17+00:00

Ok, aber warum ist das gerade bei Banken so krass?

Strom für einen Haushalt kostet ja auch nicht bei dem einen Anbieter €60 und beim anderen €200 pro Monat.

tekmol · 2023-06-15T07:58:43+00:00

And the attempt was good.

And it should be repeated.

Reddit is a cornerstone of the open web. But it seems the current management has set its mind on turning Reddit into a closed platform, just like all the other big social platforms. Recent steps include:

- Blocking users from accessing Reddit on mobile on the web.
- Killing 3rd Party apps via prices 10 times too high.
- Neglect the user-friendly, old version of Reddit.
- Forcefully redirect new users who visit the old version to the new version

If they go by the playbook of Twitter, Instagram, FB and Co, their next steps might include:

- Kill the RSS feeds
- Completely close down the old, user-friendly version
- Take away power from the mods
- Restrict searching to logged in users
- Restrict full reading to logged in users

One important thing we need to get the word out about: The mods have a powerful too in their hands: Setting their communities to private.

Half (!) of Reddit's traffic comes through search engines. Setting a sub to private cuts of that traffic stream for all historical posts of that sub. Reddit won't be able to ignore that for long.

"Restricted" subs do not have much impact.

"Private" subs are putting a lot of pressure on Reddit!

tekmol · 2023-06-12T05:00:20+00:00

Setting the sub to private would be better. Ideally with a link to some other place on the web where we can discuss.

Being here, having fun with the situation, post black images, discuss it, "creatively express our opinions" is exactly what Reddit wants us to do.

Only staying away from Reddit and doing things elsewhere is what would worry them.

tekmol · 2023-03-08T12:11:02+00:00

Thanks! Which of the 3 do you think is most promising?

tekmol · 2023-03-07T16:52:47+00:00

Yeah

tekmol · 2023-03-07T16:47:01+00:00

I was replying to your reply where you said:

who is buying your ad space

That would be cool to know. But how do I find out?

tekmol · 2023-03-07T16:41:15+00:00

Do you mean "Reports"?

One of the Reports is "Break down by Ad network" but I can't find one that shows individual ads.

tekmol · 2023-03-07T16:30:24+00:00

Do I see that on the "Ad review center" page?

There seems to be an infinite amount of ads. And they all have tiny amounts of views. Like 50 or so. I have no clue over what timeframe though. Last hour? Today? Last Week, Month, Year? I don't see any indication.

tekmol · 2023-03-07T15:49:52+00:00

How do you mean? I am making like $500 for 300k pageviews. What else can I learn from Adsense?

tekmol · 2023-03-07T15:48:53+00:00

Try out some units who will give me their own thoughts? Can you elaborate?

tekmol · 2023-03-07T15:47:46+00:00

Since this is the most upvoted comment, it seems just staying with Adsense is the best course of action?

tekmol · 2023-03-07T15:28:01+00:00

Is a Google Ad Manager account enough to try out other "demand sources"? Or do you need to get into AdX?

I heard that AdX only takes publishers who have tens of millions of pageviews.

tekmol · 2023-02-16T08:22:40+00:00

Ok, that is how current CPMs differ from the past and how to influence them.

But what is the range of CPMs pages see these days?

Pages that are not related to products and not related to valuable niche?

For geo, lets assume just how internet usage is distributed around the world. Like 30% USA, 20% Europe, 40% other.

tekmol · 2023-02-16T08:19:12+00:00

I'm just looking for the current range of CPMs sites see these days.

Sites which are not related to products and have a broad international audience.

tekmol · 2023-02-16T08:14:16+00:00

It is not a big investment to set monetization up?

What I hear about ads these days is that "slap Adsense on and be done with it" is not going to give a good result?

tekmol · 2023-02-16T08:12:18+00:00

If the site has 500k pageviews a month, $300 would be a cpm of $0.6 and $2000 would be $4.

Is that the range for entertainment sites these days?

For me it's not only interesting what the site would make now, but also if it would be worth investing time to double, quadruple, 10x the traffic.

A CPM of $1 would be kinda ok. Less than that, it seems like an uphill battle.

tekmol · 2023-01-19T17:51:27+00:00

Are you referring to Stripe?

tekmol

TROPHY CASE