Groups > comp.os.linux.advocacy > #347652 > unrolled thread

Can anyone here defend LibreOffice crapware against the masterful MS Office?

Started by	DFS <nospam@dfs.com>
First post	2016-03-26 18:50 -0400
Last post	2016-03-27 13:10 +0000
Articles	20 on this page of 34 — 13 participants

Back to article view | Back to comp.os.linux.advocacy

Page 1 of 2 [1] 2 Next page →

#347652 — Can anyone here defend LibreOffice crapware against the masterful MS Office?

From	DFS <nospam@dfs.com>
Date	2016-03-26 18:50 -0400
Subject	Can anyone here defend LibreOffice crapware against the masterful MS Office?
Message-ID	<nd73he$i6u$1@dont-email.me>

If I want to count all the tables and rows in any Access database, it's 
just:

    Dim db As Database, td as TableDef
    Dim tablesCnt As Integer, dbRecords As Long
    Set db = OpenDatabase(path to source file)
    For Each td In db.TableDefs
      If td.Attributes = 0 Then
        tablesCnt = tablesCnt + 1
        dbRecords = dbRecords + td.RecordCount
      End If
    Next


Add a few lines of code to time it, and the output from an actual 
database of mine is:

2,099,101 rows were found in 114 tables (0.02 seconds)

http://i.imgur.com/2s7JrUT.jpg


2/100ths of a second?

FOSS can't compete.

[toc] | [next] | [standalone]

#347657

From	John Gohde <john.h.gohde@gmail.com>
Date	2016-03-26 16:26 -0700
Message-ID	<158c0305-afc2-4d54-b4a6-ccf537019d8f@googlegroups.com>
In reply to	#347652

On Saturday, March 26, 2016 at 6:50:25 PM UTC-4, DFS wrote:
> If I want to count all the tables and rows in any Access database, it's 
> just:
> 
>     Dim db As Database, td as TableDef
>     Dim tablesCnt As Integer, dbRecords As Long
>     Set db = OpenDatabase(path to source file)
>     For Each td In db.TableDefs
>       If td.Attributes = 0 Then
>         tablesCnt = tablesCnt + 1
>         dbRecords = dbRecords + td.RecordCount
>       End If
>     Next
> 
> 
> Add a few lines of code to time it, and the output from an actual 
> database of mine is:
> 
> 2,099,101 rows were found in 114 tables (0.02 seconds)
> 
> http://i.imgur.com/2s7JrUT.jpg
> 
> 
> 2/100ths of a second?
> 
> FOSS can't compete.


What does a DooFuS know about anything except where sun don't shine?

[toc] | [prev] | [next] | [standalone]

#347666 — How to put off an appile funded idiot posting on behalf of microshaft crocporation

From	7 <7@enemygagets.com>
Date	2016-03-26 23:48 +0000
Subject	How to put off an appile funded idiot posting on behalf of microshaft crocporation
Message-ID	<dlolfbFftbU4@mid.individual.net>
In reply to	#347652

DFS wrote:

> If I want to count all the tables and rows in any Access database, it's
> just:
> 
>     Dim db As Database, td as TableDef
>     Dim tablesCnt As Integer, dbRecords As Long
>     Set db = OpenDatabase(path to source file)

The problem you have is clear.

You became an idiot when you copy and pasted code.

Your code doesn't work because you should have
put the path in for the source file instead of
copying and pasting code you don't understand.

That is the problem with trolls like being allowed
to go anywhere near a puter.

Learn to code in Python. Its a lot smarter than you are.

Its available free for Linux:

http://www.distrowatch.com
http://www.livecdlist.com
http://www.ubuntu.com

[toc] | [prev] | [next] | [standalone]

#347668

From	DFS <nospam@dfs.com>
Date	2016-03-26 20:06 -0400
Message-ID	<nd780k$57v$1@dont-email.me>
In reply to	#347666

On 3/26/2016 7:48 PM, 7 wrote:
> DFS wrote:
>
>> If I want to count all the tables and rows in any Access database, it's
>> just:
>>
>>      Dim db As Database, td as TableDef
>>      Dim tablesCnt As Integer, dbRecords As Long
>>      Set db = OpenDatabase(path to source file)
>
>
> The problem you have is clear.
>
> You became an idiot when you copy and pasted code.
>
> Your code doesn't work because you should have
> put the path in for the source file instead of
> copying and pasting code you don't understand.

I didn't cut and paste a thing, and it works perfectly well if you're 
not stupid.




> That is the problem with trolls like being allowed
> to go anywhere near a puter.

Admission of LibreOffice crapware defeat noted.  And that's from a way 
old version of Access (2003).




> Learn to code in Python. Its a lot smarter than you are.

I actually am doing some Python.  And unlike you, lying fraud, I'll post 
the code when I finish my Python project.



> Its available free for Linux:
>
> http://www.distrowatch.com
> http://www.livecdlist.com
> http://www.ubuntu.com
>

[toc] | [prev] | [next] | [standalone]

#347672 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

From	Chris Ahlstrom <OFeem1987@teleworm.us>
Date	2016-03-26 20:12 -0400
Subject	Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation
Message-ID	<nd78hq$63g$3@dont-email.me>
In reply to	#347666

7 wrote this copyrighted missive and expects royalties:

> DFS wrote:
>
>> If I want to count all the tables and rows in any Access database, it's
>> just:
>> 
>>     Dim db As Database, td as TableDef
>>     Dim tablesCnt As Integer, dbRecords As Long
>>     Set db = OpenDatabase(path to source file)
>
> The problem you have is clear.
>
> You became an idiot when you copy and pasted code.
>
> Your code doesn't work because you should have
> put the path in for the source file instead of
> copying and pasting code you don't understand.
>
> That is the problem with trolls like being allowed
> to go anywhere near a puter.
>
> Learn to code in Python. Its a lot smarter than you are.
>
> Its available free for Linux:
>
> http://www.distrowatch.com
> http://www.livecdlist.com
> http://www.ubuntu.com

And even if Doof's "solution" is simpler, it's Microsoft-specific,
and not worth putting up with Windows.

Any fool can djinn up their optimized "example", and challenge someone to
do better in another product.

-- 
Afternoon very favorable for romance.  Try a single person for a change.

[toc] | [prev] | [next] | [standalone]

#347685

From	DFS <nospam@dfs.com>
Date	2016-03-26 23:28 -0400
Message-ID	<nd7jrq$3g8$1@dont-email.me>
In reply to	#347672

On 3/26/2016 8:12 PM, Chris Ahlstrom wrote:
> 7 wrote this copyrighted missive and expects royalties:
>
>> DFS wrote:
>>
>>> If I want to count all the tables and rows in any Access database, it's
>>> just:
>>>
>>>      Dim db As Database, td as TableDef
>>>      Dim tablesCnt As Integer, dbRecords As Long
>>>      Set db = OpenDatabase(path to source file)
>>
>> The problem you have is clear.
>>
>> You became an idiot when you copy and pasted code.
>>
>> Your code doesn't work because you should have
>> put the path in for the source file instead of
>> copying and pasting code you don't understand.
>>
>> That is the problem with trolls like being allowed
>> to go anywhere near a puter.
>>
>> Learn to code in Python. Its a lot smarter than you are.
>>
>> Its available free for Linux:
>>
>> http://www.distrowatch.com
>> http://www.livecdlist.com
>> http://www.ubuntu.com
>
> And even if Doof's "solution" is simpler, it's Microsoft-specific,
> and not worth putting up with Windows.

Idiot (no quotes).  You "put up with Windows" most of your "career".


> Any fool can djinn up their optimized "example", and challenge someone to
> do better in another product.

So far, no one can do better in LibreOffice.  That's my point, Creepy. 
See the Subject?

And what do you mean 'optimized'?  That's one of several acceptable ways 
to do it, all offering excellent performance.

The slowest way is "SELECT COUNT(*)" on each table, but even that runs 
in 0.15 seconds.

LibreOffice can't compete.

[toc] | [prev] | [next] | [standalone]

#347705 — Re: Can anyone here defend LibreOffice crapware against the masterful M Office?

From	"Henry" <henry@alpha.org>
Date	2016-03-27 13:56 +0200
Subject	Re: Can anyone here defend LibreOffice crapware against the masterful M Office?
Message-ID	<6e2e5a0c5ddcc44b5d4c7bd2173e665d@dizum.com>
In reply to	#347685

"DFS" <nospam@dfs.com> wrote in message news:nd7jrq$3g8$1@dont-email.me...
> On 3/26/2016 8:12 PM, Chris Ahlstrom wrote:
>> 7 wrote this copyrighted missive and expects royalties:
>>
>>>> If I want to count all the tables and rows in any Access database, it's
>>>> just:
>>>>
>>>>      Dim db As Database, td as TableDef
>>>>      Dim tablesCnt As Integer, dbRecords As Long
>>>>      Set db = OpenDatabase(path to source file)
>>>
>>> The problem you have is clear.
>>>
>>> copying and pasting code you don't understand.
>>>

Highly confusing things like "OpenDatabase" are too complicated for your typical linux user to understand.

Linux users do spinning 3d cube desktops. Something like "OpenDatabase" is beyond their skill set.

>> And even if Doof's "solution" is simpler, it's Microsoft-specific,
>> and not worth putting up with Windows.
> 

Only a linux user would think "OpenDatabase" is MS-specific.

> Idiot (no quotes).  You "put up with Windows" most of your "career".
> 
Not just him. Him and his entire family, cousins, aunts and every person he knows.

> 
> The slowest way is "SELECT COUNT(*)" on each table, but even that runs 
> in 0.15 seconds.
> 
> LibreOffice can't compete.
>

SELECT COUNT(*) is one of those Windows specific things linux users are afraid of. Do you want to see a screenshot of my spinning 3d cube desktop?

[toc] | [prev] | [next] | [standalone]

#347786

From	owl <owl@rooftop.invalid>
Date	2016-03-27 18:37 +0000
Message-ID	<x003afa3h.4p39@rooftop.invalid>
In reply to	#347685

DFS <nospam@dfs.com> wrote:
> On 3/26/2016 8:12 PM, Chris Ahlstrom wrote:
>> 7 wrote this copyrighted missive and expects royalties:
>>
>>> DFS wrote:
>>>
>>>> If I want to count all the tables and rows in any Access database, it's
>>>> just:
>>>>
>>>>      Dim db As Database, td as TableDef
>>>>      Dim tablesCnt As Integer, dbRecords As Long
>>>>      Set db = OpenDatabase(path to source file)
>>>
>>> The problem you have is clear.
>>>
>>> You became an idiot when you copy and pasted code.
>>>
>>> Your code doesn't work because you should have
>>> put the path in for the source file instead of
>>> copying and pasting code you don't understand.
>>>
>>> That is the problem with trolls like being allowed
>>> to go anywhere near a puter.
>>>
>>> Learn to code in Python. Its a lot smarter than you are.
>>>
>>> Its available free for Linux:
>>>
>>> http://www.distrowatch.com
>>> http://www.livecdlist.com
>>> http://www.ubuntu.com
>>
>> And even if Doof's "solution" is simpler, it's Microsoft-specific,
>> and not worth putting up with Windows.
> 
> Idiot (no quotes).  You "put up with Windows" most of your "career".
> 
> 
>> Any fool can djinn up their optimized "example", and challenge someone to
>> do better in another product.
> 
> So far, no one can do better in LibreOffice.  That's my point, Creepy. 
> See the Subject?
> 
> And what do you mean 'optimized'?  That's one of several acceptable ways 
> to do it, all offering excellent performance.
> 
> The slowest way is "SELECT COUNT(*)" on each table, but even that runs 
> in 0.15 seconds.
> 
> LibreOffice can't compete.
> 

But sqlite3 can.
And this is with select count(*) on each table.  It's written in C, but
there's a shell script speed comparsion of basically the same algorithm
at the bottom.  Imagine how fast it could be if I knew what I was doing?

anon@lowtide:~/scripts/database$ file dfs
dfs: SQLite 3.x database
anon@lowtide:~/scripts/database$ ls -lh dfs
-rw-r--r-- 1 anon anon 23M Mar 27 14:18 dfs
anon@lowtide:~/scripts/database$ time ./count
table count: 114
row count: 2099196

real	0m0.027s
user	0m0.004s
sys	0m0.020s
anon@lowtide:~/scripts/database$ time ./count
table count: 114
row count: 2099196

real	0m0.037s
user	0m0.016s
sys	0m0.020s
anon@lowtide:~/scripts/database$ time ./count
table count: 114
row count: 2099196

real	0m0.027s
user	0m0.012s
sys	0m0.012s
anon@lowtide:~/scripts/database$ sqlite3 dfs
SQLite version 3.8.7.1 2014-10-29 13:59:56
Enter ".help" for usage hints.
sqlite> create table blah0 (id integer primary key autoincrement, goo char(10));
sqlite> create table blah1 (id integer primary key autoincrement, goo char(10)); 
sqlite> create table blah3 (id integer primary key autoincrement, goo char(10)); 
sqlite> create table blah2 (id integer primary key autoincrement, goo char(10)); 
sqlite> insert into blah0 (goo) values ('hah');
sqlite> insert into blah0 (goo) values ('hah');
sqlite> insert into blah0 (goo) values ('hah');
sqlite> insert into blah1 (goo) values ('hah');
sqlite> insert into blah1 (goo) values ('hah');
sqlite> insert into blah1 (goo) values ('hah');
sqlite> insert into blah2 (goo) values ('hah');
sqlite> insert into blah2 (goo) values ('hah');
sqlite> insert into blah3 (goo) values ('hah');
sqlite> insert into blah3 (goo) values ('hah');
sqlite> .quit
anon@lowtide:~/scripts/database$ time ./count
table count: 118
row count: 2099206

real	0m0.026s
user	0m0.008s
sys	0m0.016s
anon@lowtide:~/scripts/database$ time ./count
table count: 118
row count: 2099206

real	0m0.022s
user	0m0.008s
sys	0m0.012s
anon@lowtide:~/scripts/database$ time ./count
table count: 118
row count: 2099206

real	0m0.042s
user	0m0.028s
sys	0m0.012s
anon@lowtide:~/scripts/database$ ./foo.sh
table count: 118
row count: 2099206
anon@lowtide:~/scripts/database$ time ./foo.sh
table count: 118
row count: 2099206

real	0m0.653s
user	0m0.168s
sys	0m0.108s
anon@lowtide:~/scripts/database$ time ./foo.sh
table count: 118
row count: 2099206

real	0m0.538s
user	0m0.084s
sys	0m0.060s
anon@lowtide:~/scripts/database$

[toc] | [prev] | [next] | [standalone]

#347800

From	DFS <nospam@dfs.com>
Date	2016-03-27 18:56 -0400
Message-ID	<nd9o8v$t6i$1@dont-email.me>
In reply to	#347786

On 3/27/2016 2:37 PM, owl wrote:
> DFS <nospam@dfs.com> wrote:
>> On 3/26/2016 8:12 PM, Chris Ahlstrom wrote:
>>> 7 wrote this copyrighted missive and expects royalties:
>>>
>>>> DFS wrote:
>>>>
>>>>> If I want to count all the tables and rows in any Access
>>>>> database, it's just:
>>>>>
>>>>> Dim db As Database, td as TableDef Dim tablesCnt As Integer,
>>>>> dbRecords As Long Set db = OpenDatabase(path to source file)
>>>>
>>>> The problem you have is clear.
>>>>
>>>> You became an idiot when you copy and pasted code.
>>>>
>>>> Your code doesn't work because you should have put the path in
>>>> for the source file instead of copying and pasting code you
>>>> don't understand.
>>>>
>>>> That is the problem with trolls like being allowed to go
>>>> anywhere near a puter.
>>>>
>>>> Learn to code in Python. Its a lot smarter than you are.
>>>>
>>>> Its available free for Linux:
>>>>
>>>> http://www.distrowatch.com http://www.livecdlist.com
>>>> http://www.ubuntu.com
>>>
>>> And even if Doof's "solution" is simpler, it's
>>> Microsoft-specific, and not worth putting up with Windows.
>>
>> Idiot (no quotes).  You "put up with Windows" most of your
>> "career".
>>
>>
>>> Any fool can djinn up their optimized "example", and challenge
>>> someone to do better in another product.
>>
>> So far, no one can do better in LibreOffice.  That's my point,
>> Creepy. See the Subject?
>>
>> And what do you mean 'optimized'?  That's one of several acceptable
>> ways to do it, all offering excellent performance.
>>
>> The slowest way is "SELECT COUNT(*)" on each table, but even that
>> runs in 0.15 seconds.
>>
>> LibreOffice can't compete.
>>
>
> But sqlite3 can.

sqlite3 is a nice piece of work.  Their code is well-documented (also
public domain) and their documentation is excellent.

Main issue I have with it is their dynamic data typing: "[the column
data] type is recommended, not required. Any column can still store any
type of data."  (except an INTEGER PRIMARY KEY column)



> And this is with select count(*) on each table.  It's written in C,
> but there's a shell script speed comparsion of basically the same
> algorithm at the bottom.

Where's the source code for the C and shell scripts?



> Imagine how fast it could be if I knew what I was doing?

That's what they say at Canonical every day.

(you seem to fake it 'til you make it...)


> anon@lowtide:~/scripts/database$ file dfs dfs: SQLite 3.x database
> anon@lowtide:~/scripts/database$ ls -lh dfs -rw-r--r-- 1 anon anon
> 23M Mar 27 14:18 dfs anon@lowtide:~/scripts/database$ time ./count
> table count: 114 row count: 2099196
>
> real	0m0.027s user	0m0.004s sys	0m0.020s
> anon@lowtide:~/scripts/database$ time ./count table count: 114 row
> count: 2099196
>
> real	0m0.037s user	0m0.016s sys	0m0.020s
> anon@lowtide:~/scripts/database$ time ./count table count: 114 row
> count: 2099196
>
> real	0m0.027s user	0m0.012s sys	0m0.012s
> anon@lowtide:~/scripts/database$ sqlite3 dfs SQLite version 3.8.7.1
> 2014-10-29 13:59:56 Enter ".help" for usage hints. sqlite> create
> table blah0 (id integer primary key autoincrement, goo char(10));
> sqlite> create table blah1 (id integer primary key autoincrement, goo
> char(10)); sqlite> create table blah3 (id integer primary key
> autoincrement, goo char(10)); sqlite> create table blah2 (id integer
> primary key autoincrement, goo char(10)); sqlite> insert into blah0
> (goo) values ('hah'); sqlite> insert into blah0 (goo) values
> ('hah'); sqlite> insert into blah0 (goo) values ('hah'); sqlite>
> insert into blah1 (goo) values ('hah'); sqlite> insert into blah1
> (goo) values ('hah'); sqlite> insert into blah1 (goo) values
> ('hah'); sqlite> insert into blah2 (goo) values ('hah'); sqlite>
> insert into blah2 (goo) values ('hah'); sqlite> insert into blah3
> (goo) values ('hah'); sqlite> insert into blah3 (goo) values
> ('hah'); sqlite> .quit


That's 2 columns per table.

Mine has 8.5 (it's amazing)




> anon@lowtide:~/scripts/database$ time ./count table count: 118 row
> count: 2099206
>
> real	0m0.026s user	0m0.008s sys	0m0.016s
> anon@lowtide:~/scripts/database$ time ./count table count: 118 row
> count: 2099206
>
> real	0m0.022s user	0m0.008s sys	0m0.012s
> anon@lowtide:~/scripts/database$ time ./count table count: 118 row
> count: 2099206
>
> real	0m0.042s user	0m0.028s sys	0m0.012s
> anon@lowtide:~/scripts/database$ ./foo.sh table count: 118 row count:
> 2099206 anon@lowtide:~/scripts/database$ time ./foo.sh table count:
> 118 row count: 2099206
>
> real	0m0.653s user	0m0.168s sys	0m0.108s
> anon@lowtide:~/scripts/database$ time ./foo.sh table count: 118 row
> count: 2099206
>
> real	0m0.538s user	0m0.084s sys	0m0.060s
> anon@lowtide:~/scripts/database$


0.653s?  glacial...

You may need to get yourself some VBA.


-------------------------------------------------------------------------------------

2,099,101 rows
114 tables
971 columns
   text:      503
   boolean:   4
   numeric:   351
   date-time: 108
   binary:    5
309 indexes (25 foreign keys)
333,533,184 bytes on disk
Time: 0.17 seconds

-------------------------------------------------------------------------------------

Dim startTime As Single, endTime As Single
startTime = Timer

Dim db As Database, td As TableDef, rs As Recordset
Dim countTbl As Integer, countCol As Integer
Dim countIdx As Integer, countFKs As Integer, countRow As Long

Dim fieldType As Byte
Dim countFldBool As Integer, countFldByte As Integer, countFldInts As
Integer
Dim countFldLong As Integer, countFldCurr As Integer, countFldSngl As
Integer
Dim countFldDbls As Integer, countFldDate As Integer, countFldText As
Integer
Dim countFldOLEs As Integer, countFldMemo As Integer, countFldReps As
Integer
Dim countFldDecs As Integer, countFldBins As Integer, countFldNbrs As
Integer

Set db = OpenDatabase("D:\development\Access\test_data.mdb")

For Each td In db.TableDefs
   If td.Attributes = 0 Then

     countTbl = countTbl + 1
     countCol = countCol + td.Fields.Count

     For Each fld In td.Fields
       fieldType = fld.Type
       countFldBool = countFldBool + IIf(fieldType = 1, 1, 0) 'BOOLEAN
       countFldByte = countFldByte + IIf(fieldType = 2, 1, 0) 'BYTE
       countFldInts = countFldInts + IIf(fieldType = 3, 1, 0) 'INTEGER
       countFldLong = countFldLong + IIf(fieldType = 4, 1, 0) 'LONG INT
       countFldCurr = countFldCurr + IIf(fieldType = 5, 1, 0) 'CURRENCY
       countFldSngl = countFldSngl + IIf(fieldType = 6, 1, 0) 'SINGLE
       countFldDbls = countFldDbls + IIf(fieldType = 7, 1, 0) 'DOUBLE
       countFldDate = countFldDate + IIf(fieldType = 8, 1, 0) 'DATETIME
       countFldBins = countFldBins + IIf(fieldType = 9, 1, 0) 'BINARY
       countFldText = countFldText + IIf(fieldType = 10, 1, 0) 'TEXT
       countFldOLEs = countFldOLEs + IIf(fieldType = 11, 1, 0) 'OLE
       countFldMemo = countFldMemo + IIf(fieldType = 12, 1, 0) 'MEMO
       countFldReps = countFldReps + IIf(fieldType = 15, 1, 0) 'REP ID
       countFldDecs = countFldDecs + IIf(fieldType = 20, 1, 0) 'DECIMAL
     Next

     Set rs = db.OpenRecordset("SELECT COUNT(*) AS ROWS FROM [" & td.Name
& "];")
       If rs.RecordCount > 0 Then countRow = countRow + rs("ROWS")
     rs.Close

     countIdx = countIdx + td.Indexes.Count
     For Each idx In td.Indexes
       If idx.Foreign Then countFKs = countFKs + 1
     Next idx

   End If
Next

'COMBINE SOME DATA TYPES
countFldText = countFldText + countFldMemo
countFldNbrs = countFldByte + countFldInts + countFldLong +
                countFldCurr + countFldSngl + countFldDbls +
                countFldDecs
countFldBins = countFldBins + countFldOLEs


'PRINT TO SCREEN
Debug.Print Format(countRow, "#,#") & " rows"
Debug.Print countTbl & " tables"
Debug.Print countCol & " columns"
Debug.Print "  text:      " & countFldText
Debug.Print "  boolean:   " & countFldBool
Debug.Print "  numeric:   " & countFldNbrs
Debug.Print "  date-time: " & countFldDate
Debug.Print "  binary:    " & countFldBins
Debug.Print countIdx & " indexes (" & countFKs & " foreign keys)"
Debug.Print Format(FileLen(db.Name), "#,#") & " bytes on disk"

db.Close
Set db = Nothing

endTime = Timer
Debug.Print "Time: " & Format((endTime - startTime), "0.00") & " seconds"


-------------------------------------------------------------------------------------

[toc] | [prev] | [next] | [standalone]

#348064

From	owl <owl@rooftop.invalid>
Date	2016-03-29 19:44 +0000
Message-ID	<ghjdi903t.at4og@rooftop.invalid>
In reply to	#347800

owl <owl@rooftop.invalid> wrote:
> DFS <nospam@dfs.com> wrote:

>> 
>> 2,099,101 rows
>> 114 tables
>> 971 columns
>>   text:      503
>>   boolean:   4
>>   numeric:   351
>>   date-time: 108
>>   binary:    5
>> 309 indexes (25 foreign keys)
>> 333,533,184 bytes on disk
> 
> Didn't think there was that much porn in the universe.
> 
>> Time: 0.17 seconds
>> 
> 
> I'll fiddle with larger number of columns, more rows, etc. and try
> to build a comparable test database.
> 

And... 

anon@lowtide:~/scripts/database$ file blah
blah: SQLite 3.x database
anon@lowtide:~/scripts/database$ ls -lh blah
-rw-r--r-- 1 anon anon 345M Mar 29 15:36 blah
anon@lowtide:~/scripts/database$ time ./count blah
table count: 114
row count: 2099196

real	0m0.263s
user	0m0.092s
sys	0m0.168s
anon@lowtide:~/scripts/database$

[toc] | [prev] | [next] | [standalone]

#348073

From	DFS <nospam@dfs.com>
Date	2016-03-29 16:23 -0400
Message-ID	<ndeo22$54a$1@dont-email.me>
In reply to	#348064

On 03/29/2016 03:44 PM, owl wrote:
> owl <owl@rooftop.invalid> wrote:
>> DFS <nospam@dfs.com> wrote:
>
>>>
>>> 2,099,101 rows
>>> 114 tables
>>> 971 columns
>>>    text:      503
>>>    boolean:   4
>>>    numeric:   351
>>>    date-time: 108
>>>    binary:    5
>>> 309 indexes (25 foreign keys)
>>> 333,533,184 bytes on disk
>>
>> Didn't think there was that much porn in the universe.
>>
>>> Time: 0.17 seconds
>>>
>>
>> I'll fiddle with larger number of columns, more rows, etc. and try
>> to build a comparable test database.
>>
>
> And...
>
> anon@lowtide:~/scripts/database$ file blah
> blah: SQLite 3.x database
> anon@lowtide:~/scripts/database$ ls -lh blah
> -rw-r--r-- 1 anon anon 345M Mar 29 15:36 blah
> anon@lowtide:~/scripts/database$ time ./count blah
> table count: 114
> row count: 2099196
>
> real	0m0.263s
> user	0m0.092s
> sys	0m0.168s
> anon@lowtide:~/scripts/database$


Kewl, but...

I calculated and reported 11 measures in 0.17 seconds.

You did 2 in 0.26 seconds.

ACCESSPLUSVBAEQUALSWIN

And where's your code for 'count'?

[toc] | [prev] | [next] | [standalone]

#348077

From	owl <owl@rooftop.invalid>
Date	2016-03-29 20:43 +0000
Message-ID	<fhju00a3f.ag@rooftop.invalid>
In reply to	#348073

DFS <nospam@dfs.com> wrote:
> On 03/29/2016 03:44 PM, owl wrote:
>> owl <owl@rooftop.invalid> wrote:
>>> DFS <nospam@dfs.com> wrote:
>>
>>>>
>>>> 2,099,101 rows
>>>> 114 tables
>>>> 971 columns
>>>>    text:      503
>>>>    boolean:   4
>>>>    numeric:   351
>>>>    date-time: 108
>>>>    binary:    5
>>>> 309 indexes (25 foreign keys)
>>>> 333,533,184 bytes on disk
>>>
>>> Didn't think there was that much porn in the universe.
>>>
>>>> Time: 0.17 seconds
>>>>
>>>
>>> I'll fiddle with larger number of columns, more rows, etc. and try
>>> to build a comparable test database.
>>>
>>
>> And...
>>
>> anon@lowtide:~/scripts/database$ file blah
>> blah: SQLite 3.x database
>> anon@lowtide:~/scripts/database$ ls -lh blah
>> -rw-r--r-- 1 anon anon 345M Mar 29 15:36 blah
>> anon@lowtide:~/scripts/database$ time ./count blah
>> table count: 114
>> row count: 2099196
>>
>> real  0m0.263s
>> user  0m0.092s
>> sys   0m0.168s
>> anon@lowtide:~/scripts/database$
> 
> 
> Kewl, but...
> 
> I calculated and reported 11 measures in 0.17 seconds.
> 
> You did 2 in 0.26 seconds.
> 

Yeah, it's slower.

> ACCESSPLUSVBAEQUALSWIN
> 
> And where's your code for 'count'?
> 

I posted the files earlier in tarball.  It included a README, the foo.sh
script, and a "create" file for building a dummy database.  Here's the
code for "count" (and remember, this is amateur hour):

-------------------------------------
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "sqlite3.h"

#define BUFFER_SIZE 256

int table_count_callback(void *,int , char **, char **);
int table_names_callback(void *,int , char **, char **);
int row_count_callback(void *,int , char **, char **);

int row_count=0;
int t_count=0;
char table_names [1024*1024]={0};

int main(int argc, char *argv[]) {

 sqlite3 * db;
 char * sErrMsg = 0;
 const char s[2] = "\n";
 char table_count_SQL [BUFFER_SIZE] = {0};
 char table_names_SQL [BUFFER_SIZE] = {0};
 char row_count_SQL [BUFFER_SIZE] = {0};
 char *token;
 char token_SQL [BUFFER_SIZE] = {0};
 char *filename;

 if(argc!=2)
 {
   fprintf(stderr,"argc!=2\n");
   fprintf(stderr,"usage: %s <database>\n",argv[0]);
   exit(1);
 }

 filename=argv[1];

 sqlite3_open(filename, &db);

 sprintf(table_count_SQL, "select count(*) from sqlite_master where type='table' and name!='sqlite_sequence'");

 sqlite3_exec(db, table_count_SQL, table_count_callback, &t_count, &sErrMsg);

 printf("table count: %d\n",t_count);

 sprintf(table_names_SQL, "select name from sqlite_master where type='table' and name!='sqlite_sequence'");

 sprintf(row_count_SQL, "select count(*) from (select name from sqlite_master where type='table' and name !='sqlite_sequence')");

 sqlite3_exec(db,"BEGIN TRANSACTION",NULL,NULL,&sErrMsg);

 sqlite3_exec(db, table_names_SQL, table_names_callback, &row_count, &sErrMsg);

 token = strtok(table_names,s);

 while(token!=NULL)
 {
   sprintf(token_SQL,"select count(*) from %s",token);
   sqlite3_exec(db, token_SQL, row_count_callback, &row_count, &sErrMsg);
   token=strtok(NULL,s);
 }

 sqlite3_exec(db, "END TRANSACTION", NULL, NULL, &sErrMsg);

 printf("row count: %d\n",row_count);

 sqlite3_close(db);

 return 0;
}

int table_count_callback(void *pArg,int argc,char **argv,char **columnNames)
{
  *(int *)pArg+=atoi(argv[0]);
  return 0;
} 

int table_names_callback(void *pArg,int argc,char **argv,char **columnNames)
{
  strcat(table_names,*argv);
  strcat(table_names,"\n");
  return 0;
} 

int row_count_callback(void *pArg,int argc,char **argv,char **columnNames)
{
  int i=0;
  for (i=0;i<argc;i++)
  {
    *(int *)pArg+=atoi(argv[0]);
  }
  return 0;
} 

-------------------------------------

[toc] | [prev] | [next] | [standalone]

#348096

From	DFS <nospam@dfs.com>
Date	2016-03-29 19:22 -0400
Message-ID	<ndf2hj$e4b$2@dont-email.me>
In reply to	#348077

On 03/29/2016 04:43 PM, owl wrote:
> DFS <nospam@dfs.com> wrote:
>> On 03/29/2016 03:44 PM, owl wrote:
>>> owl <owl@rooftop.invalid> wrote:
>>>> DFS <nospam@dfs.com> wrote:
>>>
>>>>>
>>>>> 2,099,101 rows
>>>>> 114 tables
>>>>> 971 columns
>>>>>     text:      503
>>>>>     boolean:   4
>>>>>     numeric:   351
>>>>>     date-time: 108
>>>>>     binary:    5
>>>>> 309 indexes (25 foreign keys)
>>>>> 333,533,184 bytes on disk
>>>>
>>>> Didn't think there was that much porn in the universe.
>>>>
>>>>> Time: 0.17 seconds
>>>>>
>>>>
>>>> I'll fiddle with larger number of columns, more rows, etc. and try
>>>> to build a comparable test database.
>>>>
>>>
>>> And...
>>>
>>> anon@lowtide:~/scripts/database$ file blah
>>> blah: SQLite 3.x database
>>> anon@lowtide:~/scripts/database$ ls -lh blah
>>> -rw-r--r-- 1 anon anon 345M Mar 29 15:36 blah
>>> anon@lowtide:~/scripts/database$ time ./count blah
>>> table count: 114
>>> row count: 2099196
>>>
>>> real  0m0.263s
>>> user  0m0.092s
>>> sys   0m0.168s
>>> anon@lowtide:~/scripts/database$
>>
>>
>> Kewl, but...
>>
>> I calculated and reported 11 measures in 0.17 seconds.
>>
>> You did 2 in 0.26 seconds.
>>
>
> Yeah, it's slower.
>
>> ACCESSPLUSVBAEQUALSWIN
>>
>> And where's your code for 'count'?
>>
>
> I posted the files earlier in tarball.  It included a README, the foo.sh
> script, and a "create" file for building a dummy database.

Eternal-september must've dropped the post.



> Here's the code for "count" (and remember, this is amateur hour):

Not to worry - I don't criticize others code  (unless they're pricks 
like Kohlmann or Fabian).

And if I can see possible improvements, it's because it's easier to edit 
than to create.



> -------------------------------------
> #include <stdio.h>
> #include <stdlib.h>
> #include <string.h>
> #include "sqlite3.h"
>
> #define BUFFER_SIZE 256
>
> int table_count_callback(void *,int , char **, char **);
> int table_names_callback(void *,int , char **, char **);
> int row_count_callback(void *,int , char **, char **);
>
> int row_count=0;
> int t_count=0;
> char table_names [1024*1024]={0};
>
> int main(int argc, char *argv[]) {
>
>   sqlite3 * db;
>   char * sErrMsg = 0;
>   const char s[2] = "\n";
>   char table_count_SQL [BUFFER_SIZE] = {0};
>   char table_names_SQL [BUFFER_SIZE] = {0};
>   char row_count_SQL [BUFFER_SIZE] = {0};
>   char *token;
>   char token_SQL [BUFFER_SIZE] = {0};
>   char *filename;
>
>   if(argc!=2)
>   {
>     fprintf(stderr,"argc!=2\n");
>     fprintf(stderr,"usage: %s <database>\n",argv[0]);
>     exit(1);
>   }
>
>   filename=argv[1];
>
>   sqlite3_open(filename, &db);
>
>   sprintf(table_count_SQL, "select count(*) from sqlite_master where type='table' and name!='sqlite_sequence'");
>
>   sqlite3_exec(db, table_count_SQL, table_count_callback, &t_count, &sErrMsg);
>
>   printf("table count: %d\n",t_count);
>
>   sprintf(table_names_SQL, "select name from sqlite_master where type='table' and name!='sqlite_sequence'");
>
>   sprintf(row_count_SQL, "select count(*) from (select name from sqlite_master where type='table' and name !='sqlite_sequence')");
>
>   sqlite3_exec(db,"BEGIN TRANSACTION",NULL,NULL,&sErrMsg);
>
>   sqlite3_exec(db, table_names_SQL, table_names_callback, &row_count, &sErrMsg);
>
>   token = strtok(table_names,s);
>
>   while(token!=NULL)
>   {
>     sprintf(token_SQL,"select count(*) from %s",token);
>     sqlite3_exec(db, token_SQL, row_count_callback, &row_count, &sErrMsg);
>     token=strtok(NULL,s);
>   }
>
>   sqlite3_exec(db, "END TRANSACTION", NULL, NULL, &sErrMsg);
>
>   printf("row count: %d\n",row_count);
>
>   sqlite3_close(db);
>
>   return 0;
> }
>
> int table_count_callback(void *pArg,int argc,char **argv,char **columnNames)
> {
>    *(int *)pArg+=atoi(argv[0]);
>    return 0;
> }
>
> int table_names_callback(void *pArg,int argc,char **argv,char **columnNames)
> {
>    strcat(table_names,*argv);
>    strcat(table_names,"\n");
>    return 0;
> }
>
> int row_count_callback(void *pArg,int argc,char **argv,char **columnNames)
> {
>    int i=0;
>    for (i=0;i<argc;i++)
>    {
>      *(int *)pArg+=atoi(argv[0]);
>    }
>    return 0;
> }
>
> -------------------------------------


Thanks.

At some point I'll get around to testing it, and see if I can update it 
to count columns and indexes.

[toc] | [prev] | [next] | [standalone]

#348386

From	DFS <nospam@dfs.com>
Date	2016-04-02 16:11 -0400
Message-ID	<ndp8s1$ieo$5@dont-email.me>
In reply to	#348077

On 3/29/2016 4:43 PM, owl wrote:

> I posted the files earlier in tarball.  It included a README, the foo.sh
> script, and a "create" file for building a dummy database.

Care to repost it?  Eternal-september must've dropped it.  Did it have a 
link to download the files?

> Here's the code for "count" (and remember, this is amateur hour):

This is comp.os.linux.advocaca: we all have clown noses.

[toc] | [prev] | [next] | [standalone]

#347801 — How to put off an appile funded idiot posting on behalf of microshaft crocporation

From	7 <7@enemygadgets.com>
Date	2016-03-28 00:05 +0100
Subject	How to put off an appile funded idiot posting on behalf of microshaft crocporation
Message-ID	<dlr79mFju7kU3@mid.individual.net>
In reply to	#347685

DFS wrote:

> On 3/26/2016 8:12 PM, Chris Ahlstrom wrote:
>> 7 wrote this copyrighted missive and expects royalties:
>>
>>> DFS wrote:
>>>
>>>> If I want to count all the tables and rows in any Access database, it's
>>>> just:
>>>>
>>>>      Dim db As Database, td as TableDef
>>>>      Dim tablesCnt As Integer, dbRecords As Long
>>>>      Set db = OpenDatabase(path to source file)
>>>
>>> The problem you have is clear.
>>>
>>> You became an idiot when you copy and pasted code.
>>>
>>> Your code doesn't work because you should have
>>> put the path in for the source file instead of
>>> copying and pasting code you don't understand.
>>>
>>> That is the problem with trolls like being allowed
>>> to go anywhere near a puter.
>>>
>>> Learn to code in Python. Its a lot smarter than you are.
>>>
>>> Its available free for Linux:
>>>
>>> http://www.distrowatch.com
>>> http://www.livecdlist.com
>>> http://www.ubuntu.com
>>
>> And even if Doof's "solution" is simpler, it's Microsoft-specific,
>> and not worth putting up with Windows.
> 
> Idiot (no quotes).  You "put up with Windows" most of your "career".

Linux development has taken up most of my career by factor of 3
compared to competing osen.

More Linux and OSX developers out there developing for their
current versions of osen than windooosh developers
developing for their current version (3rd ranking).

http://www.itproportal.com/2016/03/21/os-x-and-linux-rise-developer-market-
threaten-windows/

Windopws developers are 3rd rate.

No wonder microshaft felt obligated to release their crap VC compiler
for free to hook and bait developers that are moving on en-masse to Linux
and OSx.

Far too late to make a difference. Its not the compiler they want free,
its microshaft they want to be free of (TM).

[toc] | [prev] | [next] | [standalone]

#347803 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

From	DFS <nospam@dfs.com>
Date	2016-03-27 19:50 -0400
Subject	Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation
Message-ID	<nd9rf3$6gj$1@dont-email.me>
In reply to	#347801

On 3/27/2016 7:05 PM, 7 wrote:

> Linux development has taken up most of my career by factor of 3
> compared to competing osen.

You're a liar and a fraud.  Everything you've built on Linux was unpaid 
hobby crapola.  You know it and I know it.

> More Linux and OSX developers out there developing for their
> current versions of osen than windooosh developers
> developing for their current version (3rd ranking).
 >
> http://www.itproportal.com/2016/03/21/os-x-and-linux-rise-developer-market-
> threaten-windows/

Extremely meaningless.  Plus, you have no clue what date releases of OSX 
or Linux they're using.

Windows: 52.2%
OSX:     26.2%
Linux:   21.7%

Windows 7:    22.5%
Windows 10:   20.8%
Windows 8:     8.4%
Windows Vista: 0.4%
Windows XP:    0.1%

Ubuntu: 12.3%
Debian: 1.9%
Mint:   1.7%
Fedora: 1.4%

http://stackoverflow.com/research/developer-survey-2016#technology-desktop-operating-system

> Windopws developers are 3rd rate.

3 rates above 6th rate FOSS hobbyware "developers".

> No wonder microshaft felt obligated to release their crap VC compiler
> for free to hook and bait developers that are moving on en-masse to Linux
> and OSx.

More of your lying bullshit.  The free Express and Community Editions 
are limited versions.  Visual Studio is the most popular IDE in the 
survey, and the full-fledged VS Pro is still very expensive.

http://stackoverflow.com/research/developer-survey-2016#technology-development-environments

> Far too late to make a difference. Its not the compiler they want free,
> its microshaft they want to be free of (TM).

Too bad you're not talented enough to break away from your Windows job.

[toc] | [prev] | [next] | [standalone]

#347841 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

From	7 <7@enemygadgets.com>
Date	2016-03-28 15:55 +0100
Subject	Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation
Message-ID	<dlsuv1F2s7rU1@mid.individual.net>
In reply to	#347803

DFS wrote:

>> Linux development has taken up most of my career by factor of 3
>> compared to competing osen.
> 
> You're a liar and a fraud.  Everything you've built on Linux was unpaid
> hobby crapola.  You know it and I know it.

You don't know fsck troll!!

You are a lying weepy doxing internet criminal and internet 
roll and you should be turning yourself in to the police.

The police should be taking your details down as you already
admit to running from them over a dope charge.
And you are going to go on and committ more internet crimes
with all thse vast files you keep on internet users and
post every so often through your criminal intent to dox internet users.

As a born fsckwit, you must be proud as well now?

>> More Linux and OSX developers out there developing for their
>> current versions of osen than windooosh developers
>> developing for their current version (3rd ranking).
>  >
>> http://www.itproportal.com/2016/03/21/os-x-and-linux-rise-developer-
market-
>> threaten-windows/
> 
> 
> Extremely meaningless

If an internet troll like you posting from USA says it, it must be true?

OSX and Linux developers overtake microshaft which shatters and fragments
-------------------------------------------------------------------------

It had to happen some time.

The news is Earth shattering - OSX takes no.1 spot for developers,
while Linux is close behind 21.7% share ahead of windopws 10
which is stuck at 20.8%.

Outdated versions of windowps make up the rest which don't
really count for much because those trolls can't move forward with
projections with outdated and unsupported microshaft osen.

Linux software is easy enough to write once and it
will work on all other distros. And it will work on future
distros, and vast armies of maintainers to improve
the software if it has any traction with them.

http://www.itproportal.com/2016/03/21/os-x-and-linux-rise-developer-market-
threaten-windows/

By next year, windopws will fade with less than 50%.
By then Linux developers would probably have overtaken
OSX.

So its looking Linux is the most demanding set of skills
out there for everyone to study up and kit up.

[toc] | [prev] | [next] | [standalone]

#347842 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

From	chrisv <chrisv@nospam.invalid>
Date	2016-03-28 11:03 -0500
Subject	Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation
Message-ID	<bukifb5f7ikmln5rhmherbhg26vr9rv9jd@4ax.com>
In reply to	#347841

President 7 wrote:

> some dumb fsck wrote:
>> 
>> Everything you've built on Linux was unpaid hobby crapola.  You know it and I know it.

Nothing like a completely unfounded, unsubstantiated accusation of
"lying", from a shitty liar like the dumfsck...

>You don't know fsck troll!!
>
>You are a lying weepy doxing internet criminal and internet 
>roll and you should be turning yourself in to the police.

He should be throwing himself off a cliff.  As buzzard food, he might
actually serve some good purpose.

>The police should be taking your details down as you already
>admit to running from them over a dope charge.
>And you are going to go on and committ more internet crimes
>with all thse vast files you keep on internet users and
>post every so often through your criminal intent to dox internet users.
>
>As a born fsckwit, you must be proud as well now?

I'm sure that his shitty pal Ezekreep is proud of him...

-- 
"How's your financial health fraud. Too bad you got shit-canned from
your low-level puke job where a 50 year old loser like you was making
way less than a McDonalds manager."  -  Ezekreep

[toc] | [prev] | [next] | [standalone]

#347994

From	DFS <nospam@dfs.com>
Date	2016-03-29 09:24 -0400
Message-ID	<nddvgj$vdf$1@dont-email.me>
In reply to	#347842

On 3/28/2016 12:03 PM, shitv wrote:
> President 7 wrote:
>
>> some dumb fsck wrote:
>>>
>>> Everything you've built on Linux was unpaid hobby crapola.  You know it and I know it.
>
> Nothing like a completely unfounded, unsubstantiated accusation of
> "lying", from a shitty liar like the dumfsck...
>
>> You don't know fsck troll!!
>>
>> You are a lying weepy doxing internet criminal and internet
>> roll and you should be turning yourself in to the police.
>
> He should be throwing himself off a cliff.  As buzzard food, he might
> actually serve some good purpose.
>
>> The police should be taking your details down as you already
>> admit to running from them over a dope charge.
>> And you are going to go on and committ more internet crimes
>> with all thse vast files you keep on internet users and
>> post every so often through your criminal intent to dox internet users.
>>
>> As a born fsckwit, you must be proud as well now?
>
> I'm sure that his shitty pal Ezekreep is proud of him...


Nobody's proud of you, turd.

[toc] | [prev] | [next] | [standalone]

#347997

From	DFS <nospam@dfs.com>
Date	2016-03-29 09:34 -0400
Message-ID	<nde03d$3le$1@dont-email.me>
In reply to	#347842

On 3/28/2016 12:03 PM, shitv wrote:
> President 7 wrote:
>
>> some dumb fsck wrote:
>>>
>>> Everything you've built on Linux was unpaid hobby crapola.  You know it and I know it.
>
> Nothing like a completely unfounded, unsubstantiated accusation of
> "lying", from a shitty liar like the dumfsck...

Seriously, shit-for-brains?  You're going to stand there and defend the 
lying, babbling idiot 7?

I have no doubt that moron walks around with head-injury bandages on at 
all times.

[toc] | [prev] | [next] | [standalone]

Page 1 of 2 [1] 2 Next page →

csiph-web

Can anyone here defend LibreOffice crapware against the masterful MS Office?

Contents

#347652 — Can anyone here defend LibreOffice crapware against the masterful MS Office?

#347657

#347666 — How to put off an appile funded idiot posting on behalf of microshaft crocporation

#347668

#347672 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

#347685

#347705 — Re: Can anyone here defend LibreOffice crapware against the masterful M Office?

#347786

#347800

#348064

#348073

#348077

#348096

#348386

#347801 — How to put off an appile funded idiot posting on behalf of microshaft crocporation

#347803 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

#347841 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

#347842 — Re: How to put off an appile funded idiot posting on behalf of microshaft crocporation

#347994

#347997