'Yarn can't find correct repository
I decided I wanted to get started in open source code, as an almost beginner. One of the projects that has been suggested to me is vscode. So, I am following the instructions in the following link:
https://github.com/microsoft/vscode/wiki/How-to-Contribute
I am on Fedora as platform, so I run the command for Red hat based linux. It succeded. Then, I forked on my github, i cloned my fork locally, as the rest of the guide suggest. SO, I entred this vscode directory, and run yarn. Here problems started, with the following error:
1/13] ⠂ @parcel/watcher
[2/13] ⠂ @vscode/ripgrep
[3/13] ⠂ @vscode/sqlite3
[4/13] ⠂ keytar
error /home/matteopossamai/open_source/vscode/node_modules/native-is-elevated: Command failed.
Exit code: 1
Command: node-gyp rebuild
Arguments:
Directory: /home/matteopossamai/open_source/vscode/node_modules/native-is-elevated
Output:
gyp info it worked if it ends with ok
gyp info using [email protected]
gyp info using [email protected] | linux | x64
gyp info find Python using Python version 3.9.7 found at "/usr/bin/python3"
gyp http GET https://electronjs.org/headers/v17.4.3/node-v17.4.3-headers.tar.gz
gyp http 200 https://artifacts.electronjs.org/headers/dist/v17.4.3/node-v17.4.3-headers.tar.gz
gyp http GET https://electronjs.org/headers/v17.4.3/SHASUMS256.txt
gyp http 200 https://artifacts.electronjs.org/headers/dist/v17.4.3/SHASUMS256.txt
gyp info spawn /usr/bin/python3
gyp info spawn args [
gyp info spawn args '/usr/lib/node_modules/npm/node_modules/node-gyp/gyp/gyp_main.py',
gyp info spawn args 'binding.gyp',
gyp info spawn args '-f',
gyp info spawn args 'make',
gyp info spawn args '-I',
gyp info spawn args '/home/matteopossamai/open_source/vscode/node_modules/native-is-elevated/build/config.gypi',
gyp info spawn args '-I',
gyp info spawn args '/usr/lib/node_modules/npm/node_modules/node-gyp/addon.gypi',
gyp info spawn args '-I',
gyp info spawn args '/home/matteopossamai/.cache/node-gyp/17.4.3/include/node/common.gypi',
gyp info spawn args '-Dlibrary=shared_library',
gyp info spawn args '-Dvisibility=default',
gyp info spawn args '-Dnode_root_dir=/home/matteopossamai/.cache/node-gyp/17.4.3',
gyp info spawn args '-Dnode_gyp_dir=/usr/lib/node_modules/npm/node_modules/node-gyp',
gyp info spawn args '-Dnode_lib_file=/home/matteopossamai/.cache/node-gyp/17.4.3/<(target_arch)/node.lib',
gyp info spawn args '-Dmodule_root_dir=/home/matteopossamai/open_source/vscode/node_modules/native-is-elevated',
gyp info spawn args '-Dnode_engine=v8',
gyp info spawn args '--depth=.',
gyp info spawn args '--no-parallel',
gyp info spawn args '--generator-output',
gyp info spawn args 'build',
gyp info spawn args '-Goutput_dir=.'
gyp info spawn args ]
gyp info spawn make
gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ]
make: ingresso nella directory «/home/matteopossamai/open_source/vscode/node_modules/native-is-elevated/build»
CXX(target) Release/obj.target/iselevated/src/iselevated.o
make: g++: File o directory non esistente
make: *** [iselevated.target.mk:121: Release/obj.target/iselevated/src/iselevated.o] Errore 127
make: uscita dalla directory «/home/matteopossamai/open_source/vscode/node_modules/native-is-elevated/build»
gyp ERR! build error
gyp ERR! stack Error: `make` failed with exit code: 2
gyp ERR! stack at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:194:23)
gyp ERR! stack at ChildProcess.emit (node:events:527:28)
gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:291:12)
gyp ERR! System Linux 5.13.16-200.fc34.x86_64
gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
gyp ERR! cwd /home/matteopossamai/open_source/vscode/node_modules/native-is-elevated
gyp ERR! node -v v16.15.0
I am not sure what the problem is and how to fix it. I would really like to start contributing and understand everything is going on, but I just started, so I have some lacks of knowledge.
The next step should be use yarn watch, but there is an error, that I think depend on the previous error.
Solution 1:[1]
SQL server has what is called free text indexing. Access does not.
However, what this means? Well, at the most basic level, you would need to normalize your data into "atomic" or so called individual values.
So, I might have say my animals table like this:
ID: autonumber Animal:
So I might then have this:
1: dog 2: cat 3: bird
so, that is our table of tags, and the Animal column is indexed.
Now, we might have say this table:
tblPeople: Firstname, Lastname and then say a long text column - maybe even memo called story:
In that big paragraph we might have say a child hood story, but we want to match out animals from that big chunk of text.
As noted, if you have SQL server, then you can create a "keyword" or so called free text indexing, and you can match/scan against such text column - and they are automatic broken down into a key words and index (each induvial word in the text paragraph is indexed for you.
So, what to do?
You would need to write some code on save of the one record on the form, and SPLIT OUT the text memo paragraph into separate words, and then save those to a child table.
So, we have tblpeople, and tblPeopleKeyWords.
In the after update event of the form save of the one record, then we would have code to take that text column/paragraph, and write out key words to the child table (tblPoepleKeyWords). The code is not hard. But before you attempt this, you might wall be able to say use Access, but adopt SQL server (even the free edition) as the database. (so the feature would be built in, and no code required).
However, assuming we don't have SQL server? Then the code to write out that text as keywords would look like this:
So, in above, we want to index "my story"
In the forms before update event? Well, we now this this setup:
So, what we will do is take EACH word in the "my story" column (a memo field), and split out each word, and then write out to our key words table.
Private Sub Form_BeforeUpdate(Cancel As Integer)
' builld key words table
If Me.MyStory.OldValue = Me.MyStory Then
' no change - exit - no need to re-index
Debug.Print "no change - no re-index"
Exit Sub
End If
Dim sBuf As String
sBuf = Me.MyStory
sBuf = Replace(sBuf, ",", " ") ' remove ,
sBuf = Replace(sBuf, vbCrLf, " ") ' remove each new line (if user hits enter key)
sBuf = Replace(sBuf, " ", " ") ' change all double spaces to one
' VERY tricky code to maintain the key list - so, just delete then all!!!!
CurrentDb.Execute "DELETE * FROM tblPeopleKeys WHERE People_ID = " & Me!ID
Dim MyKeys() As String
MyKeys = Split(sBuf, " ")
Dim sKey As Variant
Dim rstKeys As DAO.Recordset
Set rstKeys = CurrentDb.OpenRecordset("tblPeopleKeys")
For Each sKey In MyKeys
If sKey <> "" Then
rstKeys.AddNew
rstKeys!People_ID = Me!ID
rstKeys!KeyWord = sKey
rstKeys.Update
End If
Next
rstKeys.Close
End Sub
We now can join on that other table - this will perform instant - even with 50,000, or 100,000 rows. And thus you can find any keyword in that text, and event join against that table. After we run above, you in fact see this:
So, in effect, this gives you the sql server like "key word", or so called free text indexing of that text - and you can now join, or search for any keyword against that child table of keywords.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Albert D. Kallal |



