Search found 27 matches

by Qriist
08 Oct 2019, 10:48
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

kczx3 wrote:
08 Oct 2019, 10:27
So you're still having the problem though?
Nope! All is well. Not a library issue at all.
by Qriist
08 Oct 2019, 09:35
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

Two notes: AFAICS user_id_str is defined only for the table tweets . Yep, that was the issue. Revamped the code and all is well. Reform.query(query) <<<<< ????? I was trying a lot of things trying to figure out what was going on. revamped code: for k,v in tableset { QUERY .= "INSERT OR IGNORE INTO ...
by Qriist
07 Oct 2019, 21:19
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

As a workaround I guess I can export the dB to a third temporary dB and delete all records that aren't the present Id, then import THAT. would be slow but effective, I guess.
by Qriist
07 Oct 2019, 21:10
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

schema of dB with my pragma edits afterwards. The attached is a compilation of recent tweets with the word SQLite. It Is a nonsensitive representative of my dataset. What want is to separate into different external databases based on user_id_str. I'm annoyed because it feels like I'm doing it right....
by Qriist
07 Oct 2019, 20:52
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

No error, just a silent abort, I guess. @kczx3

I'll post a sample here shortly, along with the CreateDB schema it uses
by Qriist
07 Oct 2019, 19:39
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

no, it's from the main attached DB @kczx3

It's literally the WHERE clause causing the fail.
by Qriist
07 Oct 2019, 19:22
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2019-07-12

EDIT: NOT A LIBRARY ISSUE. just me I'm having a spot of trouble trying to do database exports. First of all, I'm using this as guide. I confirm the code works in SQLite Studio. So here's the issue: I'm trying to "cut up" some databases for other processing. I'm trying to sort them out based on a sp...
by Qriist
31 Jul 2019, 19:35
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 2176

Re: Photobucket bulk downloader

A big big thank to you, Qriist ! Just observed something very interesting, and be useful to you - when using the script / pb.txt as is, all exif info are removed from the resulting files. However, adding an "o" in the URLs - as in my case from "i12.photobucket.com" to "oi12.photobucket.com" does th...
by Qriist
31 Jul 2019, 19:31
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 2176

Re: Photobucket bulk downloader

You are running an AHK version that is 9 years old yet it is my script that is wrong? That's chuckle-worthy.

Try using the compiled version in the attachment.
by Qriist
19 May 2019, 12:42
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 2176

Re: Photobucket bulk downloader

@DavidJHowe Try this new version. Should solve the issue! :)
by Qriist
19 May 2019, 09:52
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 2176

Re: Photobucket bulk downloader

I tried those links, they do indeed download with watermarks. Let me do some research. Can't for a few hours though. While you wait, go ahead and try the methods found at https gist.github.com /philipjewell/a9e1eae2d999a2529a08c15b06deb13d Broken Link for safety
by Qriist
18 May 2019, 15:17
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 2176

Re: Photobucket bulk downloader

That's strange. I haven't encountered this issue and don't know how to help with that at this time. I just checked and my links download fine - appropriate quality with no watermarks...

Would you paste a couple of the links? Maybe you are grabbing the wrong set. Make sure you have the "Direct" set.
by Qriist
13 May 2019, 03:21
Forum: Scripts and Functions
Topic: Photobucket bulk downloader
Replies: 17
Views: 2176

Photobucket bulk downloader

This is a script to download manually gathered "direct" links from your photobucket account. Downloading via photobucket itself is... cumbersome. thanks to phaleth for the download(). Usage: 1) Tick any file on photobucket. 2) A "Select All" button in the top right becomes available. Press it. 3) Re...
by Qriist
20 Feb 2019, 19:18
Forum: Ask For Help
Topic: Alternative to iniread
Replies: 5
Views: 496

Re: Alternative to iniread

dang, just came in to say that.

For readability you can do

Code: Select all

states := {1: "AK"
	, 2: "AZ"
	, 3: "AR"
	, 4 : "XY" }
by Qriist
28 Oct 2018, 23:59
Forum: Scripts and Functions
Topic: RecordKill() - easy culling of related records from an array.
Replies: 0
Views: 484

RecordKill() - easy culling of related records from an array.

I had an issue where I had decoded hundreds of thousands of records from a collection of binary files into an array of parsed values, which then would be saved to a JSON - only it would take hours upon hours for my Json class to write the data out. Doing a little investigating I discovered that my a...
by Qriist
25 Sep 2018, 01:26
Forum: Wish List
Topic: [Request]: Official Library & Wrapper
Replies: 102
Views: 13861

Re: [Request]: Official Library & Wrapper

I can look around for info pertaining to aptget, sure, but I'm reasonably certain it only has download capabilities. It's meant to maintain your local system.

I'll look at the linked solutions tomorrow and examine their upload functions, if any.
by Qriist
25 Sep 2018, 01:05
Forum: Wish List
Topic: [Request]: Official Library & Wrapper
Replies: 102
Views: 13861

Re: [Request]: Official Library & Wrapper

I wasn't aware of such an interface. Carry on.
by Qriist
24 Sep 2018, 20:02
Forum: Wish List
Topic: [Request]: Official Library & Wrapper
Replies: 102
Views: 13861

Re: [Request]: Official Library & Wrapper

Working with the JSON format is reasonably easy to do, yes. I still argue that those submitting the tags would have an easier time when using .ini. JSON is useful for organizing a large collection of related material. Ini is more useful for a handful of settings.
by Qriist
24 Sep 2018, 17:44
Forum: Wish List
Topic: [Request]: Official Library & Wrapper
Replies: 102
Views: 13861

Re: [Request]: Official Library & Wrapper

Any package maintainer that is pushed forward should have an intuitive CLI, not unlike apt-get. The tag system is a great idea because you can easily require that submissions include a secondary file in .ini format. I would suggest that .ini is NOT used for the extension, rather, use .tag. Some libr...
by Qriist
01 Sep 2018, 13:28
Forum: Scripts and Functions
Topic: [Class] SQLiteDB - Update on 2019-07-12
Replies: 196
Views: 41415

Re: [Class] SQLiteDB - Update on 2016-03-28

Hello, thank your for your class. I'm still kind of new to SQLite. I have made a script that is compiling a bunch of non-sql data into a single database. My question is, how do I queue a bunch of INSERTS so that it will operate on MANY rows at once? After some extreme performance issues (talking 3ho...

Go to advanced search