From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lars Ingebrigtsen Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Mon, 06 Dec 2021 20:59:17 +0100 Message-ID: <87h7bljyi2.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <87sfv5ljxn.fsf@gnus.org> <8735n5leza.fsf@gnus.org> <835ys11pxy.fsf@gnu.org> <87pmq9jyv1.fsf@gnus.org> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="24656"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: emacs-devel@gnu.org To: Eli Zaretskii Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Dec 06 21:00:43 2021 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muKAF-0006EG-Bh for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 21:00:43 +0100 Original-Received: from localhost ([::1]:36980 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1muKAE-0000jY-4h for ged-emacs-devel@m.gmane-mx.org; Mon, 06 Dec 2021 15:00:42 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:57062) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muK8z-0007kR-0g for emacs-devel@gnu.org; Mon, 06 Dec 2021 14:59:26 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=58366 helo=quimby.gnus.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1muK8x-0006yL-Fi; Mon, 06 Dec 2021 14:59:24 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=7ZFb1PIadzrUUhX1ofvZhmHOFAgeul1EGp0zwEaMBvM=; b=MixzhWxM5IswSX9Nbiw/3oXEs5 mrbTI058a3awD4Tx5H8yPAGMIuaUDy+5Iuuvvp31B8zTmFDPAqcxiSk5s4Y6rJVbvpSFonLXtWPUs sRoBQbOdt+7LrM66MZH0q8eBRgQuLw7vL+ceTBqv4yHaV4X4XvSlxLYeMjwx8pp1NAVI=; Original-Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1muK8s-0008SA-LQ; Mon, 06 Dec 2021 20:59:21 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwAgMAAAAqbBEUAAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAADFBMVEX27dzLsaVyUVD/ //+KoilhAAAAAWJLR0QDEQxM8gAAAAd0SU1FB+UMBhM4NqyDpgcAAAFYSURBVCjPVZHBaoNAEEBn gyu0pwRcSXvLn1ioHnoy4gjxVA8KyVfk0kJupmQFe2uJAfcrO+Mm0c5hZ58zzL5dATDrsAYbArN+ PUI+AWMu8QR+R8Dd5XjEEAM7oNNHRFuiae2tDTDqz/EIJoV7uKadQN8GoMphHLjnHmT93JwG+NlK v17rJwZZPHkQvvshT8PCW4KE7O0VIAwL4dHHRRRxWykAHCnUAAUtjpBLl1UXwwngsOzshRZFu/VN Q9k7iKFJWVk5+KNVw5RTjvFw7VSrQHDFJdBKdUggcn7EzJim05gbAnMx1yDRttrZfUcT0irzK4aA QfDQjZ5zimES/8ABAdQSUAIM6QEI9uCzIqYeePO9LPkv5CYr2oPOe4DUfcy/VoeN3p2p4rpRuWo3 TVOTWxJ+bqtva4OoI2Qbe56EWhpzup3r3Q1Emo06s4dkBPGRsNk1yuS6/QPGEG84uJVNNQAAACV0 RVh0ZGF0ZTpjcmVhdGUAMjAyMS0xMi0wNlQxOTo1Njo1NCswMDowMIOKS40AAAAldEVYdGRhdGU6 bW9kaWZ5ADIwMjEtMTItMDZUMTk6NTY6NTQrMDA6MDDy1/MxAAAAAElFTkSuQmCC X-Now-Playing: The Durutti Column's _The Fruit of the Original Sin_: "The Eye and the Hand" In-Reply-To: <87pmq9jyv1.fsf@gnus.org> (Lars Ingebrigtsen's message of "Mon, 06 Dec 2021 20:51:30 +0100") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a01:4f9:2b:f0f::2 (failed) Received-SPF: pass client-ip=2a01:4f9:2b:f0f::2; envelope-from=larsi@gnus.org; helo=quimby.gnus.org X-Spam_score_int: -35 X-Spam_score: -3.6 X-Spam_bar: --- X-Spam_report: (-3.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:281165 Archived-At: Lars Ingebrigtsen writes: > Perhaps SQlite just sees it as a byte string? Indeed it does, according to some Q&A's from the sqlite people. So this happens to work because it's Emacs on both sides, but if somebody else has put binary data into the database, it'll make Emacs blow up. So we do indeed need to encode/decode in src/sqlite.c for strings. I'll fix that. -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no