On 26-12-2019 23:18, Azathoth Hastur wrote:were only correct. 3.141 . I ran the code about 50 times, and there were no differences in the about 3-4 first numbers. Maybe the "bombing" method is not very good for this. I got the idea of it from schools programming lesson. I'm sure other
On Sunday, December 22, 2019 at 5:43:09 AM UTC-5, robamm...@gmail.com wrote:
pühapäev, 29. september 2019 18:41.47 UTC+3 kirjutas azathot...@gmail.com:
Anyone doing php psotgresql for this?I have used postgresql and php. And doing some statistical calculations in php. For example I have tried to calculate Pi. I used the so called "bombing"(method with random numbers). But the result came out so that the first 4 numbers of the number
The java framework craziness I see at work must have better alternatives! >>
Basically I think, if you can program, then there is no difference in which language you program.
With the best wishes,
Kristjan Robam
Why not use the postgresql to calculate and sort, and php to just get in put and output?
Ok, its not postgresql, i tried to do 'calculate pi' in MSSQL 2017:
WITH pi (x, f, a, kwartpi) as
(SELECT 1,1.0,1,
CONVERT(float(53), 0.0)
UNION ALL
SELECT x+2,-f,x,
CONVERT(float(53),kwartpi+(f/x)) from pi where x<20000 and x>=a
)
SELECT top 10
x, 4*kwartpi
FROM pi
order by x desc
OPTION(MAXRECURSION 10000)
Output:
x
----------- ----------------------
20001 3,14149265341197
19999 3,14169266341197
19997 3,14149263340797
19995 3,14169268341997
19993 3,14149261339597
19991 3,14169270343597
19989 3,14149259337597
19987 3,14169272345997
19985 3,14149257334797
19983 3,14169274349197
(10 rows affected)
Completion time: 2019-12-28T09:49:58.2239611+01:00
*Will postgresql be better in doing this job?*
Follow-up set to comp.databases.postgresql
--
Luuk
On 28-12-2019 11:22, robamman2019@gmail.com wrote:were only correct. 3.141 . I ran the code about 50 times, and there were no differences in the about 3-4 first numbers. Maybe the "bombing" method is not very good for this. I got the idea of it from schools programming lesson. I'm sure other
On Saturday, December 28, 2019 at 10:52:33 AM UTC+2, Luuk wrote:
On 26-12-2019 23:18, Azathoth Hastur wrote:
On Sunday, December 22, 2019 at 5:43:09 AM UTC-5, robamm...@gmail.com wrote:
pühapäev, 29. september 2019 18:41.47 UTC+3 kirjutas azathot....@gmail.com:
Anyone doing php psotgresql for this?
The java framework craziness I see at work must have better alternatives!
I have used postgresql and php. And doing some statistical calculations in php. For example I have tried to calculate Pi. I used the so called "bombing"(method with random numbers). But the result came out so that the first 4 numbers of the number
Basically I think, if you can program, then there is no difference in which language you program.
With the best wishes,
Kristjan Robam
Why not use the postgresql to calculate and sort, and php to just get in put and output?
Ok, its not postgresql, i tried to do 'calculate pi' in MSSQL 2017:
WITH pi (x, f, a, kwartpi) as
(SELECT 1,1.0,1,
CONVERT(float(53), 0.0)
UNION ALL
SELECT x+2,-f,x,
CONVERT(float(53),kwartpi+(f/x)) from pi where x<20000 and x>=a
)
SELECT top 10
x, 4*kwartpi
FROM pi
order by x desc
OPTION(MAXRECURSION 10000)
Output:
x
----------- ----------------------
20001 3,14149265341197
19999 3,14169266341197
19997 3,14149263340797
19995 3,14169268341997
19993 3,14149261339597
19991 3,14169270343597
19989 3,14149259337597
19987 3,14169272345997
19985 3,14149257334797
19983 3,14169274349197
(10 rows affected)
Completion time: 2019-12-28T09:49:58.2239611+01:00
*Will postgresql be better in doing this job?*
Follow-up set to comp.databases.postgresql
--
Luuk
What is the idea of this ?
I used a circle inside a square and Pi=(Circle area)*4/(Square area)
And by the way the First numbers of pi area 3.14159.
My algorithm: https://groups.google.com/forum/#!topic/eesti-programmeerijad/qieWYzn8RxI
With the best wishes,
Kristjan Robam
Ah, this methodOk. Proof.
it looks better than trying to calculate 4*arctan(1), which can be
written as the sum of 1 - 1/3 + 1/5 - 1/7 + 1/9 - 1/11 ......
But https://en.wikipedia.org/wiki/Squaring_the_circle pages says:
"In 1882, the task was proven to be impossible,"
--
Luuk
On 28-12-2019 13:55, robamman2019@gmail.com wrote:number were only correct. 3.141 . I ran the code about 50 times, and there were no differences in the about 3-4 first numbers. Maybe the "bombing" method is not very good for this. I got the idea of it from schools programming lesson. I'm sure other
On Saturday, December 28, 2019 at 1:32:27 PM UTC+2, Luuk wrote:
On 28-12-2019 11:22, robamman2019@gmail.com wrote:
On Saturday, December 28, 2019 at 10:52:33 AM UTC+2, Luuk wrote:
On 26-12-2019 23:18, Azathoth Hastur wrote:
On Sunday, December 22, 2019 at 5:43:09 AM UTC-5, robamm...@gmail.com wrote:
pühapäev, 29. september 2019 18:41.47 UTC+3 kirjutas azathot....@gmail.com:
Anyone doing php psotgresql for this?
The java framework craziness I see at work must have better alternatives!
I have used postgresql and php. And doing some statistical calculations in php. For example I have tried to calculate Pi. I used the so called "bombing"(method with random numbers). But the result came out so that the first 4 numbers of the
Ok. Proof.
Basically I think, if you can program, then there is no difference in which language you program.
With the best wishes,
Kristjan Robam
Why not use the postgresql to calculate and sort, and php to just get in put and output?
Ok, its not postgresql, i tried to do 'calculate pi' in MSSQL 2017:
WITH pi (x, f, a, kwartpi) as
(SELECT 1,1.0,1,
CONVERT(float(53), 0.0)
UNION ALL
SELECT x+2,-f,x,
CONVERT(float(53),kwartpi+(f/x)) from pi where x<20000 and x>=a >>>> )
SELECT top 10
x, 4*kwartpi
FROM pi
order by x desc
OPTION(MAXRECURSION 10000)
Output:
x
----------- ----------------------
20001 3,14149265341197
19999 3,14169266341197
19997 3,14149263340797
19995 3,14169268341997
19993 3,14149261339597
19991 3,14169270343597
19989 3,14149259337597
19987 3,14169272345997
19985 3,14149257334797
19983 3,14169274349197
(10 rows affected)
Completion time: 2019-12-28T09:49:58.2239611+01:00
*Will postgresql be better in doing this job?*
Follow-up set to comp.databases.postgresql
--
Luuk
What is the idea of this ?
I used a circle inside a square and Pi=(Circle area)*4/(Square area)
And by the way the First numbers of pi area 3.14159.
My algorithm: https://groups.google.com/forum/#!topic/eesti-programmeerijad/qieWYzn8RxI
With the best wishes,
Kristjan Robam
Ah, this method
d = 2r
Pi = C / 2r
Here we need a picture. Please look at : https://www.basic-mathematics.com/proof-of-the-area-of-a-circle.html
Area of a circle = (1/2)r*2Pi*r
Area of a Circle=r*r*Pi
Area of a Square=(2r)*(2r)=4r*r
r*r*Pi Points in Circle
------- =~ -----------------
4r*r Points in Square
So Pi =~ 4*(Points in Circle)/(Points in Square)
The bigger the Square, the more precise Pi we have.
it looks better than trying to calculate 4*arctan(1), which can be
written as the sum of 1 - 1/3 + 1/5 - 1/7 + 1/9 - 1/11 ......
But https://en.wikipedia.org/wiki/Squaring_the_circle pages says:
"In 1882, the task was proven to be impossible,"
--
Luuk
If i do more steps, my result should get more precise (but it is not
because of precision of used tool )
Doing it your way you have to do a lot of steps to get, close to, a
correct value.
--
Luuk
On 28-12-2019 18:40, robamman2019@gmail.com wrote:
The BigNumber library is available at : https://github.com/MikeMcl/bignumber.js/ .
I modified this code a little bit.
For example with width 5000 square The Pi came out 3.1415....
It took about 1 minute.
Ok, my script loads within 1 second, and does not need an input, and pi
came out with 15 decimals as: 3.141592653589793
<html>
<head>
<meta charset="utf-8">
<title>Calculating pi</title>
<script type="text/javascript">
function findnumber() {
var pivalue=Math.atan(1)*4;
document.getElementById("pi").innerHTML=pivalue;
}
</script>
</head>
<body onload="findnumber();">
<h1>Pi</h1>
<p id="pi"></p>
</body>
</html>
for now, i will keep it with this simple approach, and YES, i kno that Math.PI also exists, but than what calculation am i doing anywayz?.
--
Luuk
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 70:22:50 |
Calls: | 6,488 |
Calls today: | 1 |
Files: | 12,096 |
Messages: | 5,275,488 |