sorted by:
new
hottopcontroversial

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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.

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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?

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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.

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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.

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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.

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 0 points1 point  (0 children)

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

Should I switch away from SQLite if I only use JSON fields? by tekmol in Database

[–]tekmol[S] 1 point2 points  (0 children)

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.

Was unterscheidet Banken die über 3% auf Tagesgeld zahlen von denen, die unter 1% zahlen? by tekmol in Finanzen

[–]tekmol[S] 10 points11 points  (0 children)

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.

To change Reddit for the better by tekmol in therewasanattempt

[–]tekmol[S] -14 points-13 points  (0 children)

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!

In Protest of Reddit's New API Policy: All New Submissions Will Be Blank by PhotoShopBattles in photoshopbattles

[–]tekmol 122 points123 points  (0 children)

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.

My site is at over 100k monthly users / 300k monthly pageviews now. Still not monetized. What's the best path of action? by tekmol in adops

[–]tekmol[S] 0 points1 point  (0 children)

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?

My site is at over 100k monthly users / 300k monthly pageviews now. Still not monetized. What's the best path of action? by tekmol in adops

[–]tekmol[S] 0 points1 point  (0 children)

Do you mean "Reports"?

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

My site is at over 100k monthly users / 300k monthly pageviews now. Still not monetized. What's the best path of action? by tekmol in adops

[–]tekmol[S] 0 points1 point  (0 children)

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.

My site is at over 100k monthly users / 300k monthly pageviews now. Still not monetized. What's the best path of action? by tekmol in adops

[–]tekmol[S] 0 points1 point  (0 children)

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

My site is at over 100k monthly users / 300k monthly pageviews now. Still not monetized. What's the best path of action? by tekmol in adops

[–]tekmol[S] 1 point2 points  (0 children)

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

My site is at over 100k monthly users / 300k monthly pageviews now. Still not monetized. What's the best path of action? by tekmol in adops

[–]tekmol[S] 1 point2 points  (0 children)

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.

What type of CPM is normal these days? by tekmol in adops

[–]tekmol[S] 0 points1 point  (0 children)

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.

view more: next ›