16 Years

This blog you are reading now has been online for 16 years!

To be exact that is 5870 days

It was created back in Oct 3, 2007☝

How much money can you make with patreon?

A formula

https://blog.patreon.com/figuring-out-how-much-you-might-make-on-patreon

How many followers?
From these followers, how many are active?
How many of these followers could convert to patrons?

Let's have an example - Teal Swan:
Current subscriptions on youtube - 589K
15% are active - 88K
7$ by Patrons (on average) - Teal might cash 618K per month!

Jessica Nigri:
Instagram followers : 3.7m (these don't convert easily to Patrons)
only 0.1% of instagram followers in average will convert
Youtube followers: 1.2m
15% are active - 180K
7$ by Patrons (on average) - Jessica might cash 1.2m per month!

Now the actual revenue for Miss Nigri is coming from 2736 Patrons - with an estimate of 19K per month - source: https://www.patreon.com/JessicaNigri

Bonus
https://www.youtube.com/watch?v=9ye7Ri8S1t0

Who are the Top Patreon Creators?

https://creatorhype.com/top-patreon-creators/

SQLite: Using a table to loop

Loop

You want to create a table with lots of records for testing purposes - in SQL you could make a loop using something like this:

while (@i <= 10000)
 begin
  insert into table1 values ( 'field1' + cast (@i as char).
 'field2'+ cast (@i as char).
...
)
set @i+=1
end
go

Unfortunately in SQlite loops are not implemented - but you could use this trick instead
It will use a tIndex table, and a tRange table to generate some records in a tTarget table.

The tTarget table  is for the result:
create table target (i text);

This table will receive the result as text

tRange table

create table tRange (start, finish);
insert into tRange (1, 100) ;

And then afterward you can change the start and finish parameters using:
update tRange set start = 3 ;
update tRange set finish = 90 ;

tIndex table

This one is tricky because it has to contain as many records as possible - you will have to create this table via a Java program (see previous post) - by default there will be 10,000 records.

Now the Loop trick 

insert into tTarget(i)
select ('Record number '||tIndex.id)
from tIndex join tRange
on (tIndex.id >= tRange.start and tIndex.id <= tRange.finish) ;

This will generate Record Number + start ...  up to Record Number+ finish