text:
Review: Card Captor Sakura Clear Card arc TV Anime – Episode 16
© CLAMP・ST/講談社・NEP・NHK
Episode 16 – Sakura and Meiling's Friend
Card Captor Sakura Clear Card TV Anime is being broadcast in several countries around the world via online services in a simultaneous or semi-simultaneous fashion. Please check the guide below to see if your country is included:
Where can I watch Card Captor Sakura Clear Card TV Anime? – A useful guide
If you watch the anime via one of these channels, you'll be supporting the creators and helping to make Card Captor Sakura even more popular worldwide.
OMG WHO ELSE HAD STRONG X VIBES WHEN SAKURA USED SIEGE TO PROTECT THE MANSION? And I LOLed at Meiling's "WTF" scream xD
And of coooourse Sakura is powerful enough to use SIEGE to protect the whole mansion area. We know she's capable of much more than that 😉 I loved how Kero looked at her with a mix of admiration and astonishment.
So in the end it really was an earth-based card. SWING. A very big change between the manga and the anime, as we haven't seen that card in the manga yet.
Lots to talk about in the scene with Kaito and Akiho. First of all, why is he wearing his butler uniform? I think that looks weird. Then, once again Akiho mentions that Sakura invited her to visit Fujitaka's library. It really does seem like this is gonna be very important. They are building up way too much for this moment. And THEN, we see Kaito using his magic for the first time! And it's practically syncronized with the manga (we're going to see him using his magic for the first time in the next manga chapter). Ohkawa is making sure that the secrets are being revealed in the right time, without having the anime spoiling the manga.
Does anyone have any idea of what are those three words — Tina Rie Triax — that Kaito said? We learn that he uses his pocket watch to control Akiho's memories. Of course, this may not be its solo purpose. However it is aligned with a theory I have that Akiho's memories (and magic?) have been erased upon her own request. Kaito here is likely only doing his job once given by Akiho herself (that's my theory). The thing that triggered Kaito to do it was the mention of Sakura's father. Hummm.
Two cards on the same episode (to compensate the lack of cards on recent episodes). STRUGGLE. It was really nice seeing Sakura and Meiling's interaction to secure this card. Nice way of saying goodbye to Meiling. And this is something that Sakura had wished for: being able to do/achieve something with Meiling.
Where can I book my therapy sessions with Meiling? Some real mature talk there.
SO CUTE Meiling asking Sakura to call her by her first name! I was moved by that scene (more than the SyaoSaku scenes, what's wrong with me?). Meiling is the true meaning of character development and I envy her maturity now.
Now that Meiling is gone, looks like we'll finally get back to following the manga by the next episode, in which APPEAR shall appear.
Card Captor Sakura TV Anime
← Card Captor Sakura ~Clear Card arc~ #4 fourth week sales report
Card Captor Sakura – Clear Card arc – Chapter 23 →
34 thoughts on "Review: Card Captor Sakura Clear Card arc TV Anime – Episode 16"
cutesherry says:
Most of the episode went more or less like most of us imagined: Sakura captured 2 cards, one of them while fighting together with Meiling (the preview was pretty clear haha) and this was also the episode Meiling left for HK and called Sakura by her first name ^^ (we saw that one coming too! XD)
Wise words she said, about Sakura and Syaoran tendencies of caring too much about the people surrounding them and not enough about themselves, this is pretty much their temperaments and their very natures, but they could indeed think it twice before doing anything too drastic… This is clearly pointed at Syaoran first and foremost, but I think this applies very much to Sakura too, who would very likely also go too far to protect others too…
The thing with Syaoran is a bit contradictory: why so much preparing/training for so long with the assistance of Eriol/his family, to end up making some huge life threatening sacrifice in the end? ^^;; I can totally see him pushing himself too hard, but doing something from the get-go that would make him loose his life? I don't think he has the sort of mindset to just get himself killed without fighting above and beyond his utmost limits first.
On the other side, there are red flags in both the anime and the manga about the safety of Syaoran…
Of course, the sort of sacrifice he could make might not be loosing his life but something else… which, as we learned in TRC and xxxHolic, doesn't make things better at all ^^;
The 'surprise': it felt VERY random, so I think Ohkawa/Madhouse staff really just wanted to show it off as a new information: Kaito's ability to turn back time for a couple of minutes using his pocket watch and a spell!
Not sure what we are supposed to make out of it, so I will simply leave this one fact at the back of my mind for the time being ^^
Ah, the other thing is about Masaki-san: when I heard from users on discord that he was in the title of episode 20 + someone said he was also mentioned in this episode (that was before I watched it myself…), I thought it was a "done deal" that ep20+ would be animating the latest chapters.
Nonetheless, after watching the ep myself, I see that Sonomi-san said 2 things which didn't really match: her grand father is wondering what she was doing this Summer, and 'at the villa again' (meaning this is the place she went before in the Clow Card arc, which was located in the middle of mountains).
Furthermore, the full title is "Sakura, the rainbow and grand father": a rainbow has really NOTHING to do with the last chapters of the manga but has, on the other side, EVERYTHING to do with "EP16-Sakura and the Rainbow of Memories".
I can only assume this will either be something completely different unrelated to what we've seen in the manga, and yet again, another wink to the previous series; else they changed a LOT of details to say the least: the house is not the same, it will forcefully have to be some sort of family vacation if they have go there in car (it is not a place they can get to walking like they did in the manga), how is Syaoran going to be included in that? In the anime, there is virtually no contact between the Kinomoto men and Syaoran so far (other than the glaring in ep9 with Touya), and since their uniforms didn't change yet, it's not Summer in the manga either…
I just don't know! -dizzy-
Well! ^__^
This is again the same thing: we will have to wait and see how it turns out! 🙂
That's all for this episode! ^^
"The thing with Syaoran is a bit contradictory: why so much preparing/training for so long with the assistance of Eriol/his family, to end up making some huge life threatening sacrifice in the end? ^^;; I can totally see him pushing himself too hard, but doing something from the get-go that would make him loose his life? "
this seems to be syaorans natural self destruct button. when the person he loves the most has their very life at risk syaoran goes into this reckless (unintentional self harming) self destruct mode- remember trc, c! syaoran, r!syaoran and watanuki are very much this, its actually a main theme in both trc and Holic. and i actually think ccs sakura has this tendency too. back in sakura card arc when yue and yukito were vanishing, kero and yue instinctively kept this info from sakura cause they just knew she'd do something reeeallly reckless to stop it cause of how much she loved them. this self destruct , stubborn, over caring/ protective streak is definitely an inherited quality they get most likely from clow ^^ (common relative)
And this is a recurring theme in CLAMP works too 😉
I noticed that too. Well, given that the whole Nadeshiko subplot seems to be cut from the anime, maybe they don't need to show her room when she was a child. Maybe that will be manga-only.
triax is a type of watch. (its a nike triax watch) no idea about the other two words though. well, tina is a persons name, but i highly doubt thats what was meant when he said it. i wondered if it was a sort of code for counting or something.
Thierry says:
I had the x vibe as well. I was hoping that it would fix the damage after being canceled but apparently not. I noticed as well how precuse the reveals calendar between manga and anime was. Yuna s magic is pretty stylish imo and the moon phases calls yuuko s circle.
I was half-expecting that it would fix the damage too xD
oh this episode has to be one of my favourites for this series with out a doubt! i just so love the special familial relationship that meiling and sakura have. they totally balance each other out. sakura softens the fiery meiling, and meiling pushes the sweet naive sakura. meiling seems to have this ability to open sakura eyes without spelling out the obvious. she just gives her a much needed super deep mature pep talk and a little nudge and bam! sakuras back on track. meiling literally does what i was hoping kero and yue would be doing for her by now. syaoran and meilings character development is perhaps my favourite in the anime series .
oh my god i loved that fight sequence! its what ive missed for sure. AND the first human shaped card!! how cool to see sakura and meiling team fighting. and sakura did fantastic! this re-enforces my head canon of sakura being taught by syaoran/yelan everything the li family already know from fighting to magical knowledge. she's already really athletic so she'd pick up martial arts pretty quick i imagine. i got strong kurogane/c!syaoran (early trc) vibes watching meiling teaching sakura how to fight like her. sakura is such a natural! it was so refreshing seeing this more badass side of sakura surface once again. and she applied it to a card capture rather than just sports!
meiling found herself comparing sakura to syaoran a lot after staying with sakura for a few days. and she found she has to give them similar advise too.
wow! CLAMP sure are doing a good job of making kaito sinister! i love his character more and more! that time reversal scene was awesome! and at the mere mention of fujitaka ! 😮 i also think this all has something to do with a wish or request made by akiho, and kaito has taken a role of guardian both in caring sense and magical sense, only he's a sorcerer rather than created being. but i really do wonder what all this time reversal stuff is doing to akihos mind! @@
when sakura said she knew something was off, at first watch i thought she meant syaoran, but watching the episode again i wonder if she also meant she sensed something like the time reversal (without her knowing that). so whats will all this time reversal stuff do to sakura &co? i wonder if its effected eriol too? i mean his house has come back in the anime… he's avoiding sakura for a strong reason…
im fearing for syaoran after seeing just what it is he is doing when he's "too busy" to be with sakura. and now meiling said that dreaded foretelling sentence "if something were to happen to you, sakura would cry…" my heart sank into my stomach when i heard that…. but, but! as sakura says, everything will surely be alright!
it is keeping things fresh for ccs to have all this foreboding danger/ sinister and dark characters, and also first real threat for sakura to deal with. now sakura has broken away from clows lovingly built container it's put a whole new spin on the ccs story. but not so much that it completely changes the stories formula.
ah! forgot to talk about the swing card. first off i thought it was gonna be some sort of giant mole the way it was pushing the earth up like that! and i was not expecting it to be called swing at all! i dont get that name for it ^^; maybe something more like shake or tremble, not swing… anyhow i really loved its design! and sakura was awesome in this seal too, manipulating siege like that! she was so focused!
rofl!! meiling screaming at siege! compared to tomoyo just calm closing her eyes waiting for the balloon to pass over her.
winterbat says:
"and i was not expecting it to be called swing at all! i dont get that name for it ^^; maybe something more like shake or tremble, not swing…"
Working with Japanese students learning English, I'm not at all surprised by the weird translation. It's a combination of looking up a word in the dictionary and not knowing the subtle differences between multiple words listed, and just choosing a word that sounds "cool." The original series was quite good with their English word choice (although I always wondered why the elemental cards were named with their adjective instead of the noun like the other cards, especially with the use of "The ~"), and it's a slight shame that this series doesn't have quite the same quality. A minor thing that probably doesn't bother anyone that much, but it stands out to me a lot because of the nature of my work. Looking at the kanji, yes, you got it right, "Shake" would be a better translation, but I'm assuming because they use the word "shake" in Japanese for "milkshake," it probably sounded goofy to them. It can also be translated as "rocking, wobbling, oscillation, fluctuation, and swinging." "Swing" was probably the easiest to say for a Japanese accent, and sounds better than the the rest. "Siege" suffers this problem too, the Japanese word for it can be translated to "surround, entrap, enclose" but I'm sure "Siege" sounded cooler, even though the card's power is not so big on offense as the word "siege" implies.
"Lucid" too, I mean doesn't the word "lucid" mean exactly the opposite of what the card does? lol I'm sure they saw the word "lucid" as being a synonym for "clear" or "transparent" without realizing that the meaning of those words in this case was "something obvious or intelligible." And it sounds cool, what with "lucid dreaming" and whatnot.
renanenrique says:
Maybe the 'bad translations' have to do with (~theory~) Sakura unconsciously being the one creating those cards? We all know she's just not goot at English.
Sakura84 says:
Thought the same. It might not be just a matter of bad translation. 🙂 If it really turns out like this, I'll bow at CLAMP !
ozakatomoe says:
According to the Merriam-Webster, lucid can mean kind of "transparent" as in "snorkeling in the lucid sea", but it sure doesn't usually describe human being, even Harry Potter under his invisibility cloak. "Sane" or "easy to understand" for what the word is used in a normal conversation.
Picking the one word in a bilingual dictionary which prononciation sounds the best to Japanese hear really most be the explanation.
Huh...? says:
I don't think that "Swing" is the equivalent of "Earthy", since appearance wise, the order of the elements of Clear Cards have been similar to Sakura capturing the Clow Card (i.e., first "Windy", next "Watery", then "Fiery" and lastly "Earthy").
As for the name "Swing", it would have been better if they used something like 'Tremor' instead, as "Swing" is a really odd name.
Today I came across this kanji again at work in a different context, and I realized that it can also be translated as "unrest, turmoil, being shaken (about something)." Knowing what Sakura was going through, and what we now know about the cards, this seems pretty clever naming for the Japanese name. Maybe they thought "Swing" was like "mood swing?" Maybe it should have been translated as "Agitation."
I was surprised by the rather easy capture of the Swing Card. They showed off Sakura's awesome growth of magical ability by surrounding the whole mansion with the Siege Card, but then it was just a matter of getting in front of the card's true form and sealing it. Maybe her desperation in saving her friends trapped in the house caused a sudden burst of magic in her that allowed her to overcome it and seal it away without weakening it?
So this episode confirmed time travel/manipulation is a thing now. And it seems that it's not the first time that Kaito has used it since their arrival in Tomoeda. He mentioned Sakura's father and his collection of books, a detail that Akiho has told him before but doesn't remember because of his rewinding of time, and he was all "Oh crap" and had to make her forget his slip-up. Although honestly, he probably could've played it off as "Yeah, you did, don't you remember?" since she's very trusting; I mean, when we see him rewinding time in this episode, she's obviously noticed the time jump but he easily distracts her with other conversation. She didn't seem to be accusing him of anything by questioning him before, but I guess he wants to make doubly sure that there are no discrepancies in her memory. How does the time magic work though, does it only affect anyone inside the magic circle? Just Akiho herself?
The mentioning of her travels to other countries seems significant; so they travel in search of books and immediately leave after they get it. I wonder if it's because they get those books by unsavory means… I had theorized it was because they were on the run from the Magician's Society, guess I was wrong there! Seems like we're being promised a trip to Sakura's family library, perhaps Akiho will somehow stumble across The Clow/Sakura book in her room, with all the cards gone clear? Maybe that will kick-off a showdown. Doesn't the inside cover have strange writing too? I know everyone was saying the language in Akiho's book was the same as Fay's magic in TRC, but I was wondering about the writing in the Clow book, I'll have to check sometime.
The build up of Sakura and Meiling's relationship over the past few episodes seem to have culminated in Struggle's capture. I was surprised at just how quick Sakura picked up on Meiling's fighting skills; athletic ability is one thing, reflexes are quite another. But I guess it shows just how in sync they are with each other, almost on par with Meiling and Syaoran's relationship. And the end with Meiling asking to call her by first name was a fitting farewell.
Come on, Syaoran!! Don't be so standoffish with your girlfriend!! I know you're focused on important things and it's all for her sake, but don't forget your important loved one in the moment!! When Sakura said "I won't have to settle for phone calls and letters anymore?" when you guys reunited, were you lying to her?!! XD I'm kinda sad that they have so little screentime together this season, in comparison to Sakura's time with everyone else.
I was surprised by the rather easy capture of the Swing Card. They showed off Sakura's awesome growth of magical ability by surrounding the whole mansion with the Siege Card, but then it was just a matter of getting in front of the card's true form and sealing it.
Although honestly, he probably could've played it off as "Yeah, you did, don't you remember?" since she's very trusting; I mean, when we see him rewinding time in this episode, she's obviously noticed the time jump but he easily distracts her with other conversation. She didn't seem to be accusing him of anything by questioning him before, but I guess he wants to make doubly sure that there are no discrepancies in her memory. How does the time magic work though, does it only affect anyone inside the magic circle? Just Akiho herself?
Yeah, indeed, Akiho seems pretty easy to "talk it out". There was no need to use magic for THAT. But I see it as a plot device just to show what's he's been doing xD And I think the magic only affects Akiho.
Doesn't the inside cover have strange writing too? I know everyone was saying the language in Akiho's book was the same as Fay's magic in TRC, but I was wondering about the writing in the Clow book, I'll have to check sometime.
Yeah, it does, but the language looks very different from the one in Akiho's book.
I was surprised at just how quick Sakura picked up on Meiling's fighting skills; athletic ability is one thing, reflexes are quite another.
Me too! I thought that was a bit forced xD
warpio says:
[i]I was surprised by the rather easy capture of the Swing Card. They showed off Sakura's awesome growth of magical ability by surrounding the whole mansion with the Siege Card, but then it was just a matter of getting in front of the card's true form and sealing it. Maybe her desperation in saving her friends trapped in the house caused a sudden burst of magic in her that allowed her to overcome it and seal it away without weakening it?[/i]
I thought this worked pretty well. Sakura is definitely strong enough now that she can capture most cards without weakening them just by being close enough, and the struggle can still be about getting close enough to the card to capture it. In this case it was thanks to Sakura's quick thinking with Siege, and the Fly card putting in everything it had to make sure Sakura got to it in time before it smashed the house.
Last week with all the "long hair" talk I was thinking that the only way that we will get to watch Sakura with a new hair style would be with a time jump, now that seems possible.
I feel the animation when they were capturing Strugle wasn´t as fluent as it was back then when they captured The twin, so that flashback was kind of unfair.
At the end of the episode when Sakura and Meiling were talking , at Sakura´s room, did they acknowledge the trip to China from the first movie, since they were showing pics of the places they visited??
And for sure Meiling why she has to go?? 😦
Now, we got a possible explanation about what happened with Eriol house, but if the house is still there do we have to worry about The void?? Maybe the "earthquake " now was in fact an "earthquake": I was thinking about all the rewriting, in the original ending of the anime Sakura´s tears created one card that showed her love for Shaoran, but with the OVA we didn´t see it (if I recall correct); so even if Void was a thing they wouldn´t have a way to captured or at least there is no The hope card… anyway as others have stated I am wondering how much Kaito has affected Sakura´s word and if she would need those cards?? Is thies important?? .
Now about Sakura going to visit Masaki-san, and given what we know from the anime maybe just maybe and if it is going in the same way and he gives to Sakura the same present: Kaito isn´t looking for that clock, but I feel it will give to Sakura a way to fight the time powers that Kaito has, neither it will help to give her similar powers (then the warning that Nadeshiko gave to Sakura), a chance to fix what Kaito had altered or just a way to not allow him use them. Given that it maybe will happen at episode 20 maybe they will wrap the story in 2 episodes. 😦
I´m as well worried about Shaoran and Touya.
Director Asaka confirmed in one of the latest interviews that those are postcards/pictures sent by Syaoran during the time they had a long distance relationship 🙂
Oh! That´s better 🙂 Thanks.
Episode 16 was sooo full of emotions!!
I'll start, as usual, by the technical aspect, which is also the one I'm more salty about, so we can get out of my system the bad part and proceed with the rest of the episode, which was good.
The animation quality for this episode was really meh, but most of all, they broke the tradition of the fight scenes for Meiling, which featured (both in episode 43 and 60) outstanding animation sequences. This time it was full of still frames and I felt so disappointed. Yes, I do understand that there might have been a problem of timing and budget (we're steadily progressing towards the climax) but still. Meh.
I only appreciated the Akiho/Yuna scene, which for its directing choice it really seemed interesting to me. The street is the same where the SyaoSaku reunion in episode 1 happened, and it was really trying to deliver some kind of romantic tension between the two, in the beginning. And then, the punch in the stomach, but I'll talk about this later.
AAAAND now that I took that out of myself, let's proceed with the storyline!
I honestly thought Swing would completely destroy Tomoyo's house, I pulled my hair at one point, I liked the tension and how the card seemed "scary". This definitely got a meaning (rif. upcoming chapter 23). AND YES I THOUGHT OF X 's KEKKAIs!!
Everything was justified with the earthquake, but still it did quite some damage. I think this is just an earth-type kind of card, but not the counterpart of Earthy yet. I'll still stand by my theory, for the moment.
Kaito and Akiho's scene was sooooo creepy. I was kinda disappointed by him in this episode, while I still kinda trusted him before, now I see some other side of him that I don't like. I'll explain myself better: he rewinded time because he mentioned Fujitaka's job when Akiho didn't even talk about Fujitaka yet, to him. She was going to find out or become suspicious of him, so he needed to revert back time (what a noob, Kaito).
Despite Akiho's scared look, he did that anyway. I still think Kaito is one of those Clamp-ish characters who start with good intentions and end up overdoing things, even stepping on the feelings of the person they're trying to protect in the first place (another reference to upcoming chapter 23). And that's not a good excuse so yeah, I'm a bit wary of Kaito right now. If your theory ends up being true, I might change my mind, but for the moment……
So he REWINDed time (ED theme reference) with that seemingly made up spell (it's not latin, apparently). It's also VERY interesting to note that what he says in Japanese is very similar to Sakura's old release spell, especially in the part of "meiyaku no moto" (basing on the oath) and "keiyaku no moto" (basing on the contract).
So we had a taste of Kaito's time rewinding magic in the anime, before it even happened in the manga (but we'll see something else in chapter 23).
Back to Meiling and Sakura, I LOVED how these two girls bonded over this short vacation. They really are like sisters now. Meiling taught SO MUCH to Sakura during her stay, and she finally let us know why she came in the first place. She wanted to check on Sakura and give her the necessary strength, because she surely felt her insecurity over the phone (that "don't get hurt or you'll make everyone cry" was already a warning).
I loved the contrast to the old series, how she didn't exactly came here for Syaoran (not directly at least) but for Sakura.
And that first name basis switching………I begged for it to happen, and they delivered it!! Just before she left, as I predicted! I am so happy, you have no idea!! The "Sakura" name rolls so perfectly from her tongue XD
And, before leaving Tomoeda, she left her last warnings to Syaoran too. First, he must talk to Sakura. And not about the card thingies he knows, but as a general rule for their relationship. IF there's something he wants to say, something he wants to know, he has to speak to her directly. Meiling telling him teasingly "Why don't you ask her directly?" was lowkey pointing to that. No relationship works if there isn't communication, and guess what those two are lacking right now?
And the last warning, is to not do anything reckless in order to bring his goal to a completion, because if anything happened to him, the one who would feel devastated would be Sakura nonetheless. And Meiling right now loves Sakura too much for letting him ruin their relationship and Sakura's smile like that. Basically Mei loves them both way too much and she won't allow anyone to make them sad, not even Sakura or Syaoran themselves. Syaoran's "Yes.", however, seemed like a lie to me. I've drawn a parallel with a scene in the Sealed Card movie that frankly got me quite worried. Will Sakura really manage to open his eyes? I hope so.
Gosh I'm gonna miss Meiling so much. These 4 episodes had little plot advancement, but huge character and relationships development. HUGE.
Next time, we'll be back on track with Appear (WTF is that monster in the preview?????) and I think we'll start the steady trip to the climax.
SIGH. I don't want it to be over and honestly I do think it needs a movie to explain properly all the secrets.
another movie and another series! not just cause i LOVE ccs like crazy, but also cause i think all these major character and plot developments clear card arc has delivered need space to breathe and get tied up and/or pushed further, and i think another series would do that perfectly. lets see sakura face another non clow reed related enemy. lets see sakura grow her hair enough to braid it! lets see syaoran open his eyes and communicate with his much beloved girlfriend! lets see the Li family (aka the secret magical mafia family) pleeeeaaassseee!!!
I forgot to write about the animation on this episode but I fully agree with you: it was meh.
About Kaito, you know CLAMP needs a suspicious character, someone for the readers to believe it's the villain, but we all know that's not the case. I am not saying you're still gonna love him after everything is revealed xD you might still hate him.
It's also VERY interesting to note that what he says in Japanese is very similar to Sakura's old release spell, especially in the part of "meiyaku no moto" (basing on the oath) and "keiyaku no moto" (basing on the contract).
Yeahhhhh I noticed that. To whom did he make a contract with?
No relationship works if there isn't communication, and guess what those two are lacking right now?
Yeah, it's really weird. Like, what happened? They look so distant. I understand Syaoran is hiding things for Sakura's own protection, but poor Sakura ^^" I would be feeling miserable if I was in her shoes. I think Syaoran should "fake" more that everything is fine.
These 4 episodes had little plot advancement, but huge character and relationships development. HUGE.
I might still be salty at him for quite a while, yes XD I've been holding a grudge against Eriol for years, after all. Now I love him, btw.
"I would be feeling miserable if I was in her shoes. I think Syaoran should "fake" more that everything is fine."
She is feeling bad, but she's chosen to wait. My opinion? She's gonna get tired of waiting rather soon, especially if she starts to see things escalating (in a bad way). I want to see Sakura getting a bit mad at Syaoran, is that possible?
"I want to see Sakura getting a bit mad at Syaoran, is that possible?"
i think so! she definitely has a fiery streak to her and she has no trouble getting mad at touya and kero when pushed. touya is her bro and kero is like family to her. so i think this more fiery (?) side of sakura will spread to syaoran if he pushes her enough.
i kinda like that CLAMP are showing that syaoran and sakuras relationship is in no way perfect or easy. i was a little afraid that CLAMP would make their relationship too perfect but the was their relationship is being shown in clear card makes it more real.
*the way
"The animation quality for this episode was really meh, but most of all, they broke the tradition of the fight scenes for Meiling, which featured (both in episode 43 and 60) outstanding animation sequences. This time it was full of still frames and I felt so disappointed."
I agree, I remember when I was in elementary school with dreams of being a badass martial artist, I'd replay Meiling's fighting scenes over and over and try to recreate them myself. This episode is REALLY lacking by comparison.
"I think this is just an earth-type kind of card, but not the counterpart of Earthy yet. I'll still stand by my theory, for the moment."
I was thinking that too, just because the kanji at the top of the card has nothing to do with earth stuff, not like Gale and Aqua's kanji.
Right? What was his promise, I wonder?? And to who??
Totally agree, and I'm glad the anime is taking the time to point this out, this problem happens way too often in couples portrayed in anime. I half wonder if Sakura's references to something being off with these card captures is Syaoran's frequent absences during them.
"And the last warning, is to not do anything reckless in order to bring his goal to a completion, because if anything happened to him, the one who would feel devastated would be Sakura nonetheless. And Meiling right now loves Sakura too much for letting him ruin their relationship and Sakura's smile like that. Basically Mei loves them both way too much and she won't allow anyone to make them sad, not even Sakura or Syaoran themselves."
Meiling made me realize, Tomoyo has really been off the ball in this series. I love that Meiling has matured so much and is looking out for both Sakura and Syaoran, but Tomoyo used to be the voice of reason and motherly advice. I'm kinda sad that Tomoyo has been reduced to comic relief with Kero. Meiling is certainly in a better position to offer insight on Syaoran, but Tomoyo used to be quite perceptive.
"Next time, we'll be back on track with Appear (WTF is that monster in the preview?????)"
I wonder if the anime will expand on Appear's magic. Reading the manga, I couldn't quite tell what it was that Appear did differently from Action. Appear took the desserts everyone made and made them move. Action made the trees move. You'd think Appear would be more like The Create, but…
EXACTLY, exactly! I might go as far as to say that they're trying to use it as a red herring, people now are thinking that she captured the Earth card….and then when the real Earthy counterpart will appear, hell is gonna break loose and it'll be the final showdown.
"Meiling made me realize, Tomoyo has really been off the ball in this series."
I think Tomoyo's moment is about to arrive. They wanted Meiling to play an important part because she's a pretty loved character in Japan, but now that she's out of the picture, the one who will support Sakura through the end will be Tomoyo. And I'm still waiting for Tomoyo and Syaoran's heart-to-heart talk.
Before reading what other people have to say, I'll summarize my own thoughts on the episode here.
This episode was a great breath of fresh air, starting right off with some Card Captor action in the first 5 minutes and then fitting in another card fight in the same episode, as opposed to all of the slice of life focus we've gotten throughout most of this season.
I loved seeing Sakura display her competency at using her powerful card magic. She instantly knew to use Seige to trap the card so that it can't cause more damage, and then the Fly card acting on its own and rocketing her towards the earth dragon so that she can capture it just as it's about to smash Tomoyo's house, and then celebrating with her by flying around in circles, that was great. Even though most of these cards don't have a humanoid form, it's nice to see that at least some of them have a personality.
The 2nd card fight in this episode was mostly Meiling's time to shine, but Sakura was still able to display her competency in capturing cards by realizing that its weak point was both of its shoulders. They looked really cool fighting it together, and I'm glad that Meiling got to play a vital role in capturing a card before leaving (and it's probably for the better anyway, to not have to keep tampering with the manga's plot to include her in some way).
It makes sense that Meiling was acting so mature and motherly towards Sakura, because she's always had a big matriarchal family while Sakura has only had her dad and big brother, so she's sort of filling in the void of a mother figure for Sakura while she's visiting. I didn't know this would be when Meiling would go back to Hong Kong, but this was a perfect send-off for her. She's such a great ally and friend to Sakura, and this episode established that extremely well, and that part where she reminded Sakura of her invincible spell, that gave me goosebumps.
I get the feeling that Kaito is doing some sort of convoluted magic ritual involving Akiho's dreams, the book that she's reading, and the Clear Cards… And the dreams that Sakura has been having show that their goal is ultimately to steal Sakura's key, and the book of Clow is probably the book that Akiho came to Japan to search for… Akiho getting her memory erased by Kaito could be some sort of way of blocking Akiho's powers so that Sakura can't sense anything from her. And I'm pretty sure that Sakura's cards have been lost in the dream world ever since they turned clear. That's about all I can guess for now.
Honestly this might be the best episode yet in this arc. Both the action and the emotional character development stuff were really good, and despite the somewhat recycled card plot content (Swing and Struggle being just like Earthy and Fight/Twin), the character development is so good that it easily makes up for that.
Oh yeah the nod to X's Kekkai magic in this episode, but I also just realized, the way Struggle seemed like a literal fighting machine, maybe she's a nod to CLAMP's Angelic Layer?
It seems I forgot to comment, things have kept me busy last week. *sigh*
Let me get back to the scene with Kaito. It seems he has been investigating on Fujitaka on his own and him mentioning there may be interesting books in his library, means there should be more Clow books in his possessions. Talking of which, since he isn't Clow's reincarnation in the anime, it would be nice to learn own he came by THE CLOW book.
Then Kaito rewind time, to erase his mistake. It probably only affected he and Akiho, but Akiho didn't remember a thing while he did. A brand new magic circle. It's been over 15 years we got a new one, which was Yuuko's. Every other character since used Clow's, the Lee family's or Sakura's. Even Feiwang Read, Watanuki and Xinghuo used Clow's circle. This mean Kaito probably isn't related to any of them. There's still an opening for Fay, as we never seen a magic circle from him, but more probably, his magic isn't of that nature. Then the formula, tina rie triax… It doesn't sound like any proper language, maybe it's the same as the one the Alice in Clockland book is written in? It remind me of Fay again, his "vi la prinshia" he said to clone Sakura when she came back from her suicide trip in Tokyo. Not that it has to be the same language, more like the same kind of magic language cryptic sound.
Anyway, the scene gave me a Tokyo Babylon Seishirou vibe, when he make Subaru and Hokuto sleep so he can be rough with their opponent.
Other than that, I'm sad Meiling is leaving, she was adding a lot more introspection in the series. we are back to wonder what the characters can be thinking.
For the technical part, the storyboard was done by Sakata Shun'ichi, who also did episode 13. Episode director is Nishihata Yuki who did episode 6. Supervising the image diretors is Hamada Kunihiko, the chara designer, he has been on the job since episode 9. Under is order are Yoshikawa Kaori and Horiuchi Hiruyuki, the first worked on episode 6 and the second is new. So not some major team on this episode, I guess they should have hired one of their action image directors, both card capture would have benefit.
lol! forget what I just said about the staff, that's for episode 17. For episode 16, the story board is Oohara Minoru, same as episode 6, then the rest of the staff is the same as episode 8. IIMURA Masayuki as episode director, with Yamamoto Keiko and Nasuno Fumi as image directors, but they are under Hamada Kunihiko supervison this time.


text:
Fuissé ist eine französische Gemeinde mit  Einwohnern (Stand: ) im Département Saône-et-Loire in der Region Bourgogne-Franche-Comté. Die Gemeinde ist Teil des Arrondissements Mâcon und Teil des Kantons La Chapelle-de-Guinchay. Die Einwohner werden Fuisséens genannt.

Geografie
Fuissé liegt in der Landschaft Beaujolais, im Weinbaugebiet Bourgogne; hier wird aus den Trauben vor allem der Crémant de Bourgogne produziert.

Umgeben wird Fuissé von den Nachbargemeinden Solutré-Pouilly im Norden und Nordwesten, Charnay-lès-Mâcon im Nordosten, Mâcon im Osten, Vinzelles im Osten und Südosten, Chaintré im Südosten, Leynes im Süden und Südwesten sowie Chasselas im Westen.

Bevölkerungsentwicklung

Sehenswürdigkeiten
 alte Kirche
 Kirche Saint-Germain
 Burg Fuissé aus dem 10. Jahrhundert

Weblinks

Ort in Bourgogne-Franche-Comté
Weinbauort in Frankreich

redpajama_set_name: RedPajamaWikipedia


text:
Q: HTTPS WCF Service on Windows Phone 8.0 : Cannot authenticate i'm experiencing problems on my WP8.0 app, I want to access a HTTPS WCF service from it with BASIC authentication.
Everything is already working on a C# console app which uses .NET framework 4.5
WORKING CONSOLE APP CODE :
App.config :
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
    <system.serviceModel>
        <bindings>
          <basicHttpsBinding>
                <binding name="WS_CubicusMobileSOAPBinding">
                  <security mode="Transport">
                    <transport clientCredentialType="Basic" proxyCredentialType="Basic" realm="xxxxxx.xx.xx" />
                  </security>
                </binding>
            </basicHttpsBinding >

      </bindings>
        <client>
            <endpoint address="https://xxx.xxx.xx/xxx/awws/xxxxx.awws"
                binding="basicHttpsBinding" bindingConfiguration="WS_CubicusMobileSOAPBinding"
                contract="ServiceReference1.WS_CubicusMobileSOAPPortType"
                name="WS_CubicusMobileSOAPPort" />
        </client>
    </system.serviceModel>
</configuration>

And this C# code :
ServiceReference1.WS_CubicusMobileSOAPPortTypeClient proxy = new WS_CubicusMobileSOAPPortTypeClient();
proxy.ClientCredentials.UserName.UserName = "xxxxxx";
proxy.ClientCredentials.UserName.Password = "xxxxxx";
var e = proxy2.ConnexionTestWP(anObject);

NOT WORKING WP8.0 CODE :
ServiceReferences.ClientConfig :
<configuration>
  <system.serviceModel>

    <bindings>
      <basicHttpBinding>
        <binding name="WS_CubicusMobileSOAPBinding" maxBufferSize="2147483647"
          maxReceivedMessageSize="2147483647">
          <security mode="Transport" />
        </binding>
      </basicHttpBinding>
    </bindings>
    <client>
      <endpoint address="https://xxxxx.xxxxx.xxx/xxxxx/awws/xxxxx.awws"
        binding="basicHttpBinding" bindingConfiguration="WS_CubicusMobileSOAPBinding"
        contract="ServiceReference1.WS_CubicusMobileSOAPPortType" name="WS_CubicusMobileSOAPPort" />
    </client>

  </system.serviceModel>

</configuration>

The C# code is exactly the same than the console app one (except it's Async).
I receive a CommunicationException saying "Additional information: The remote server returned an error: NotFound."
The only thing Fiddler sees :
http://i.stack.imgur.com/VzYhf.png
I heard that Silverlight clients needs crossdomain.xml on client side to work, so I included this file on the server root. Still not working...
I feel like I tried every binding (like custombinding), every c# code (like adding the Authorization header inside the WCF request manually), every kind of configuration etc... Nothing is working.
Please help me out i'm desperate !

A: You're using basicHttpBinding in Windows Phone but basicHttpsBinding in console app. Have you turned off http on the server?

redpajama_set_name: RedPajamaStackExchange


It never ceases to amaze one as to how many people are attracted by an event promising gormet food at its core. We had our largest turnout ever and were still able to comfortably seat and apportion all the delicious food.
The evening commenced with two slideshows which included images submitted by 32 members. Our outing show was the Firelight Lantern Festival, coupled with some images from Pumpkinferno at Upper Canada Village. These venues were great tests of high ISO, hand-held, night photography. The month's theme slideshow was entitled Abstract, which forced some people far out of their normal comfort zone. In addition, we rapidly realized that we do have a number of really "warped" individuals in our midst! Both slideshow image sets have been posted to our Facebook page.
The food tables were absolutely incredible. The variety of superb entrees and delicious (low-cal???) deserts was endless. Needless to say, no-one left the premises hungry.
In hour two, David Gilbert and I took to the stage, to recognize and reward some tremendous imagery from our members. After reviewing in excess of 3400 images submitted over the course of the past 12 months, the very best were assigned to 19 separate categories, eventually ending up with four contenders for each award category - not all that original (Oscars anyone?) but very effective just the same! In addition, the club recognized the 2016 Photographer of The Year - a most deserving award for our overall winner - Mr. Dave Tugwood.
Will I Ever Outlive This?
Congratulations to all our 2016 CFC Award winners. The full Awards Presentation is now available for viewing on our Youtube channel.
Our next meeting will be on January 8th and our theme challenge for December is entitled Member's Choice. Our January theme challenge is Winter Ways - Laneways, Roadways, Railways, Pathways, ... – do have fun with this one.
Thanks to everyone who came out to our annual Gala event and a very special thanks to Margaret and her helpers who created a great festive atmosphere for our special night.


text:
Q: Weird String won't split (Whitespaces or Tabs) I am having troubles splitting this string into the different values.
When splitting it using R, there is no problem splitting it using sep="\t".
But in Java I cannot make it work.
I copied the string from the file that I am reading from and it seems to be reproducible in the online java fiddlers.
I've already tried "\s+", "\t+", "\t", "\t", "\t+".
Maybe the String is not tab delimited? But why does R work then?
public class JavaFiddle {

  static String s = "   1   0   3        150.00";

  public static void main(String[] args) {
      System.out.println(s.split("\\t+")[0]);
  }
}

A: I think you can use the \\s :
public class JavaFiddle {

  static String s = "   1   0   3        150.00";

  public static void main(String[] args) {
      String[] split = s.trim().split("\\s+");
      for(int i=0; i < split.length; i++){
      System.out.println(i + "-->" + split[i]);
      }
  }
}

And the output is:
0-->1
1-->0
2-->3
3-->150.00


text:
Q: .submit don't work when I use ajax in rails I build a website ,
the user need to sign up their information and a "special key"
if they didn't input the key , they will be normal user
if they use right key , they will be super user
but if key is wrong they will not pass until they use the right
the key used ajax to ckeck in controller
and return json {status:"ok"} or  {status:"error"}
here's my code
$('#btn').click(function(e){
    if(keystring.length > 0){
        $.ajax({
        type: "POST",
        url: "check",
        data: { key:keystring  },
        dataType:'json',
        async:false,
        success: function( datajson ) {
            if(datajson.status == "wrong"){
                alert("wrong, please input the right key");
            }else{
                $('#confirm').submit();
            }
        }
        });
     }else{
          $('#confirm').submit();
     }
});

the problem is
if I input right key or no key
$('#confirm').submit();  won't execute !!
why?
submit will execute when not using ajax
Thanks for Help
here's my controller
def check
    @key = KeyChain.find_by({ code: params["key"]})
    if @user_info.present?
        datajson = { status:"ok" }
    else
        datajson = { status:"wrong"}
    end
    respond_to do |format|
     format.json {
        render :json => datajson.to_json
     }
    end
end

A: What is the value of keystring? Is it defined, is it string, does it exist inside the closure? Try to show value of keystring with alert to see if it is OK.
$('#btn').click(function(e){
alert(keystring);
if(keystring.length > 0){
    $.ajax({
    type: "POST",
    url: "check",
    data: { key:keystring  },
    dataType:'json',
    async:false,
    success: function( datajson ) {
        if(datajson.status == "wrong"){
            alert("wrong, please input the right key");
        }else{
            $('#confirm').submit();
        }
    }
    });
 }else{
      $('#confirm').submit();
 }
});


After meeting some amazing animals at the Wildlife Park, Hugman and the little boy wish they could have an animal at home. Using their bricks and a bit of imagination, the little boy transforms Hugman into a variety of animals. Creativity and construction are central themes as Hugman is built antlers, wings and webbed feet. But is that what Hugman really wants?


Clue 3 released this past Saturday. I started and finished it on Sunday, quick heels, and it's one of my favorities, the short row heel.
Took me a minute to get pictures, but voila! Oh and no Mods.
Stay tuned for the next clue, which is the foot and then all that is left is the toe!


text:
Number of relationships between abnormal values in oral glucose tolerance test and adverse pregnancy outcome
Burak Bayraktar, Meriç Balikoglu, Miyase Gizem Bayraktar, Ahkam Göksel Kanmaz
Department of Obstetrics and Gynecology, University of Health Sciences Tepecik Training and Research Hospital, Izmir, Turkey
Dr. Burak Bayraktar
Department of Obstetrics and Gynecology, University of Health Sciences Tepecik Training and Research Hospital, Izmir
Objective: The aim of this study is to investigate the effect of detecting one or more positive values in 75 g oral glucose tolerance test (OGTT) performed between 24 and 28 gestational weeks on neonatal biometry (macrosomia, newborn weight, head circumference, and body length of newborn), obstetric results, and treatment requirement. Materials and Methods: Between January 2019 and December 2020 at the University of Health Sciences Tepecik Training and Research Hospital, pregnant women who underwent 75 g OGTT between 24 and 28 gestational weeks and had singleton pregnancy were included in the study. Multiple pregnancies, pregnancies with gestational age <37 and ≥42 weeks, pregestational diabetes mellitus, pregnancies with intrauterine growth retardation, those with chromosomal and/or congenital anomalies, those with thyroid disease, pregnant women whose information could not be reached, and/or whose information was deficient were excluded from the study. These pregnant women were classified into Group 1 with a positive single value, Group 2 with two positive values, and Group 3 with all positive values according to 75 g OGTT values. Results: Two hundred and eighty-three singleton-term and gestational diabetic pregnant women who met the inclusion criteria were included in the analysis. The age of pregnant women and their body mass index (pre-pregnancy and at during test) increased from Group 1 to Group 3, and the differences between all groups were significant (P < 0.001, P < 0.001 and P < 0.001, respectively). The number of pregnant women treated with insulin increased significantly from group 1 to group 3 (P<0.001). Birth weight and body length of new-borns were significantly higher in Group 3 as compared to Group 1 and Group 2 (P = 0.033 and P = 0.017, respectively). Macrosomia prevalence was the highest in Group 3 with 21.7% (P < 0.001). Conclusion: The number of positive values detected between 24 and 28 weeks of gestation in 75 g OGTT was associated with the birth weight, body length, and macrosomia of the newborn and also could be used as an early biomarker to mother's insulin requirement.
Bayraktar B
Balikoglu M
Bayraktar MG
Kanmaz AG
glucose value
pregnancy outcome

redpajama_set_name: RedPajamaCommonCrawl


This portable power bank has large real capacity of 6000mAh, yet still very compact, making it portable for you to bring with you wherever you go, especially on holidays. Meanwhile the design of the power bank makes it interesting and attractive too. It also has a protective design that prevents over-charging, over-discharging and short circuit.


From time to time I lose my motivation to write. When I attend the writers group meetings, I gain inspiration that helps me to find new content. Not only is attending writers group meetings a way to help cure writer's block, but you are able to discuss the problem with other writers. You'd be surprised at how many good writers have had to overcome writer's block. You are likely to benefit from listening to the techniques they may have used to jump-start their writing efforts.
There are also books that contain helpful hints for starting writing projects. I recently purchased 62 Blog Posts to Overcome Blogger's Block, written by Marcie Hill. This book has helped me to get started on writing projects that I had pushed aside. For me, Marcie's book provided the "kick" I needed to start reviewing those drafts. I was motivated to polish up content that I can now use for my blog, for Open Mic presentations, or to create inspirational posters. Even published authors can benefit from the material covered in 62 Blog Posts to Overcome Blogger's Block.
If you are in a writing slump, try writing about what may have attributed to your writer's block. The thought process will help you to move forward. You can then share your experience with other writers who may need inspiration.
Writing is a platform from which you can reach people, and inspire positive change. We are all connected by words–use yours creatively to uplift the world.
The book I mentioned is an excellent tool for writers. For more information, visit marciehill.com.
Next post: Who's Minding Our Rights?


Mums the word: The free Barberton Mum Festival concludes Sunday. Lake Anna Park will come to life with 17,000 chrysanthemums, creating more than a million mum blooms. There will be displays, activities, food and entertainment. For more, visit cityofbarberton.com.
Butterflies: There will be a Migrating Monarchs program at Stan Hywet Hall & Gardens at 10 a.m. Sunday. Cost is $12 for adults and $9 for kids. As a part of the program, butterflies will be tagged. For more, visit stanhywet.org.
Abuzz: The Akron Zoo is hosting its first Honey Harvest Festival on Sunday. The event, which is included in regular zoo admission, will run from 10 a.m. to 5 p.m. There will be zookeeper talks, beekeepers, music and crafts, along with honey wine tastings and related treats.


text:
Home > World > Kim Jong Nam's Son Reveals His Father Was 'Killed'
Kim Jong Nam's Son Reveals His Father Was 'Killed'
Kim Jong Il and Kim Jong-nam pose together with others (Photo : Choongang Monthly Magazine/Newsmakers)
A video uploaded on YouTube has shown a man who claimed to be Kim Han-sol, Kim Jong-Nam's son. He revealed that his father was assassinated, contrary to North Korea's latest statement about how Kim Jong-un's half-brother died from a heart attack.
Ri Tong-il, North Korea's former deputy ambassador to the United Nations, said that Kim Jong-Nam had a history of heart disease. Moreover, Ri also noted that "under normal conditions, he cannot travel without medicine for heart disease, as well as for diabetes and high blood pressure." With this, he concluded that Kim Jong-Nam died from a heart attack instead of assassination.
The announcement came after North Korea was accused of being the one behind Kim Jong-Nam's death. South Korean and U.S. officials believed that Kim Jong-Nam, who had spoken up against his family's dictatorship of North Korea, had been assassinated by agents of the reclusive country.
Currently, Kim Han-sol has come out and was featured in a YouTube video, which can be seen below. Kim Jong-Nam's son revealed that his father was assassinated.
"My name is Kim Han-sol, from North Korea, part of the Kim family," he said. "My father has killed a few days ago. I'm currently with my mother and sister and we're very grateful to... and we hope this gets better soon."
He showed his passport as proof but his personal information was blurred. The video was uploaded by Cheollima Civil Defense, which is a civic group helping North Korea defectors.
The National Intelligence Service has verified the man in the video to be Kim Han-sol. It is unclear where the clip was filmed and why he appeared in it.
Cheollima Civil Defense said that the video would be the "first and last statement on this particular matter and the present whereabouts of this family will not be addressed." It has also thanked the Netherlands, China, the U.S. and an unknown "fourth government" which helped moved the family.
North Korea Accused By Malaysia Of Holding Citizens Captive
Lotte Store Closures In China Reported Amid Political Tension
North Korean Ambassador Declared Persona Non Grata By Malaysia
North Korea: Kim Jong Nam's Death Was Caused By Heart Attack
North Korean Visitors To Malaysia Will Soon Be Required To Apply For Visa
Kim Jong-nam Kim Han Sol Death North Korea South Korea Malaysia


text:
Kenny Florian explains why Conor McGregor needs to 'stick to the UFC'
Kenny Florian breaks down Conor McGregor's options after his fight with Floyd Mayweather
30 August, 2017 03:41 Damon Martin
Despite his underdog status with no professional experience on his resume, Conor McGregor managed to last more than nine rounds with arguably the greatest boxer of this generation when he faced Floyd Mayweather last Saturday night in Las Vegas.
McGregor not only held his own against Mayweather but he won rounds against the multi-division champion, who retired after the fight with a perfect 50-0 record.
After the fight was over, McGregor wasn't ready to commit to what's next for him while hinting that his future might lie in both boxing and mixed martial arts.
Former UFC title contender and current FOX analyst Kenny Florian commends McGregor on his performance against Mayweather in his boxing debut, but he still feels that the 29-year old Irishman will be best served by sticking to his chosen profession in mixed martial arts.
"I think he needs to stick to the UFC. That's what he does best," Florian explained on the latest Fight Society podcast. "I think he can create a similar legacy to what Floyd Mayweather did in boxing, he can do that very same thing in the UFC. He's a bigger star now but at the end of the day he's got money for three lifetimes. Does he want money for five lifetimes? I don't fault him for that if he wants even more but I still think he's a very talented and passionate mixed martial artist. That's what he does best and that's what he should do but it does get tricky when you think about it and you go 'listen I might be able to make $40, $50 million fighting Paulie Malignaggi in a boxing match and maybe make $20 million fighting Nate Diaz in a trilogy fight. What would you do? I don't know.
"For me, I just don't want to see Conor McGregor in his second boxing match going up there with an 0-1 record. I just don't think that's a good look. He had nothing to lose fighting the best ever. At this point, I think this is where the mission returns and he should stick to what he does best and that's fighting in the UFC."
KENNY FLORIAN NAMES TWO OPPONENTS PERFECT FOR CONOR MCGREGOR
While it's definitely possible that McGregor could cash a huge payday for fighting someone like Malignaggi, who is a former champion in his own right, Florian believes that there's still a massive fight awaiting him in the UFC as well.
"I think it's pretty simple. I think the biggest fight out there is the Nate Diaz trilogy fight," Florian said. "I think that's the one they've go to do. I think that's the biggest fight that could happen right now. I think you do that at 155 pounds for the belt. I think Nate Diaz is absolutely deserving of it and just in terms of hearing everybody talking about it, that's the one everyone wants to see. I think that's the one you've got to make."
McGregor will undoubtedly look to renegotiate his deal with the UFC should he plan his return to the Octagon in the near future, especially considering the drawing power he'll hold following the record breaking event with Mayweather.
Add to that, McGregor's first pair of fights against Diaz have resulted in two of the biggest pay-per-views in UFC history so a third matchup would undoubtedly result in a huge draw for the promotion as well.
Assuming McGregor could settle the rivalry with Diaz, Florian says there's an even bigger fight on the horizon in the future that would keep the Irishman in the UFC while taking on arguably the other biggest pay-per-view draw in the history of the company.
"If I'm able to look a little bit further ahead, there's this Georges St-Pierre guy out there as well, which I think would be an interesting fight for the fans as well," Florian teased. "Whether that's at maybe a catchweight at 165 or 170, I know Conor would probably be down for it.
"I know Georges St-Pierre would be down for it as well."
Listen to Kenny Florian and coach Angelo Reyes on the latest Fight Society podcast via Libsyn or download and subscribe to the show via iTunes.
Conor McGregorDamon MartinFight SocietyFloyd MayweatherGeorges St-PierreKenny FlorianNate Diaz
Conor McGregorExclusiveFight Society PodcastGeorges St-PierreMayweather vs. McGregorNate DiazPodcastsufcz-Latest news
Showtime Offering Some Refunds for Mayweather vs. McGregor After Lawsuit Filed
Damon Martin - Aug 29, 2017
Conor McGregor launching his own clothing line in 2018


Subharanjan - Subh's playground for WordPress sports.. !!
You have a BuddyPress enabled Job site. Now you need display your resume in BuddyPress Profile. So here is a cool plugin for it. https://shop.opentuteplus.com/product/buddypress-my-resume/ It simply adds resume to your BuddyPress Profile. This plugin needs BuddyPress, WP Job Manager and WP Job Manager Resume to be installed.


If you are interested in large lattice section , zhejiang jovyea plastic profile co.,ltd If you are interested in 4related results, so you can compare and shop! Try finding the one that is right for you by choosing the price range, brand, or specifications that meet your needs.
The lattice fence is a beautiful and stylish fence, and it can provide you with privacy. You can see the scenery outside the yard, but the people outside can not see you. You can do what you want to do,I think it's happy for you.
Privacy fence Save labors, install one set of fence in 5 minutes. Pvc fence how to install privacy fence ?


Though liking the look of denim on black I've always find denim outerwear to be restricting. I own a well fitted denim button up from topshop that I wear by itself or as an outerwear, my heart broke when its pearl button got scratched. I then went to get a cheap fake dark denim (meaning just your regular navy blue button up) that probably wasn't that cheap at all, to wear it as an outerwear since it's cotton and not actually denim.
Nothing beats the real deal so I went on a hunt for the perfect denim but my friend heard my struggle and had a denim button up to spare to which I gladly accepted. It's been sitting in my closet for a good 11 months now; wanted to wear it for Christmas dinner last year but I took it off before heading out because man, it was so HUMID I was not in to put up with the movement restriction crap.


Remus Lupin is a favorite character for many fans, and now you can add this Remus Lupin POP Vinyl to your Hogwarts collection! Lupin is a powerful wizard with strong convictions, but he also has a dark secret that his plagued him through life. Have you ever tried defeating the Dark Arts while also being a werewolf? It's pretty hard!


The first time I read about drop crotch pants in a Nylon article early last fall, I could not believe the absurdity. The article, though I cannot remember its exact words, contained something of a word of warning, telling girls to be prepared to loosen up and get ready to wear the crotch of their pants a little lower.
As anyone who has browsed through a recent issue of Vogue would know, the drop crotch is a staple of a lot of Spring 2009 collections for both men and women. Of course, back in early fall my initial reaction was of disgust. I thought, has fashion exhausted all of its creative resources to the point that designers, what I call "the fashion gods," would have us "the petty mortals" to wear something so bizarrely ugly?
My first real life experience with drop crotch pants was in October when I visited one of my favorite stores, Zara, and there they were. Black, straight legged slacks with the crotch down to the knees. I could not believe that the day had come, that these were actually going to be sold in stores and people were going to buy them, let alone wear them in public. The fashion apocalypse was here and we were all doomed, I thought.
Now as the last of Fall/Winter 2008 collections are being picked off the clearance racks, my hardheaded ways are, too, a thing of the past. A couple of days ago, I cracked. I went to San Francisco and bought a pair of drop crotch pants. Though they are not the most drastic pair, it's a start. I still maintain that drop crotch pants are neither an attractive nor a flattering piece of clothing, but I have a newfound amusement and appreciation for their freshness.
I remember when I was in high school, super low-rise pants were very in. Every time a girl sat down, everyone behind her would see half of her behind. For the past couple of years, high-waisted pants have dominated. Sure, these are classic and will always have their place, but I think our generation needs to have something to claim as uniquely ours. That something is drop crotch pants. For you all skeptics out there, drop crotch pants range from drastically low to only slightly baggy. Mine, needless to say, fit the latter description. Let me just say, they are super comfortable and can be paired with a feminine top (lace and lively colors being a must this spring) and heels to dress them up, or a t-shirt with sandals or flats for a more casual ensemble.
Perhaps in a year we will scoff at the drop crotch and call it a 2009 fashion faux pas, but right now it doesn't matter. What matters now is that we have a uniquely creative garment that is so preposterous that we call it beautiful, and we should embrace it. Fashion is an art, don't forget. As drop crotch pants make if off the runway to more affordable stores, I am more and more convinced that the time has come to loosen things up down there.
Ha! This is a great article. Nicely written Nastia. Don't think I'll ever be made to get a pair of these though.
This is great Nastia..I'm tempted to experiment...but I think it will be one of those things only girls appreciate and guys don't understand!
I love drop crotch pants! They're so comfortable- it has the look of a skirt but the comfort of pants. At first I was a little hesitant as well, but I decided to take a risk anyway and get a pair. Now Im so glad I bought them!
"I think our generation needs to have something to claim as uniquely ours. That something is drop crotch pants"


text:
Earn Extra 2 Points
Our brand Lifestyle International (P) Ltd, is a part of the prestigious Dubai based Landmark Group. We started our operations in India with the launch of the first Lifestyle store in Chennai in…
The name "POTHYS" is synonymous with Silks and garments for the entire family. POTHYS has got a rich tradition of four generations standing in the field of textile trade. We are…
We are the No.1 in south India for Purity of 916 gold and have won the best Diamond showroom for four years; At GRT, our single minded focus on customer satisfaction soon made GRT a house hold…
C. Krishniah Chetty & Sons are considered as one of the world's finest Heritage Jewellers. With a legacy dating back to 1869, C. Krishniah Chetty & Sons has been a jeweller to the…
In existence for over a decade, Pai International is a successful brand in retailing Electronics, Appliances, Mobiles, Laptops & more. Today we have 59 outlets across Karnataka & other…
Copyright © - 2020 Loylty Rewardz Mngt Pvt Ltd. All rights reserved.


text:
Antitype jonis is een vlinder uit de familie uilen (Noctuidae). De wetenschappelijke naam is voor het eerst geldig gepubliceerd in 1865 door Lederer.

De soort komt voor in Europa.

jonis
Dier uit het Palearctisch gebied


We are consistently ranked as the top agents in the Toronto Real Estate market and we focus on providing award winning service to our clients. If you are looking for 45 Dovercourt Rd condos for sale or thinking about selling your 45 Dovercourt Rd condo, contact us at 416-494-7653.
Fill our the form below if you wish to receive an email of all 45 DOVERCOURT RD CONDOS FOR SALE now. Once new listings come on the market, you will automatically be sent an email before they hit the public MLS.
Looking for 45 Dovercourt Rd. floor plans?
Just contact me below and ask for the 45 Dovercourt Rd. Report.


When you have back splash tiles adhering on the wall, then the blot similar to the dye might be removed quite easily. Besides, there are several types of tiles you may choose and a number of them are even stain resistant. So, if you are now doing your own closet re-modeling and also you usually do not consist of back-splash on your list, put in it now because you fully desire it. You will need this to make your closet appears fresh and amazing all enough full time for certain. That is just why try to own diy closet have a plain wall need more closet space build your own closet my home decor at this time.
Why Is It That People Pick diy closet have a plain wall need more closet space build your own closet my home decor?
Tile for counter-top from closet is stain proof, dirt and moisture resistant. Tile can withstand heat and hot water. The designs and also the shades make tile easy to become customized at the installation practice. You can combine tiles with various designs and colours altogether. Tile for closet counter-top is more cheap. It ranges from $10 to $50 for every square foot. Additionally, home owner may also replace vinyl when it can damage. If you can't afford to install stone slab, then tile can be the ideal option. Lots of people also pick tile for his or her closet as it is water immunity. For this cause, tile has durability compare to other low-cost counter-tops. Nevertheless, in time, without any appropriate care tile could chip or crack up. how to closet is among the least expensive chimney which individuals love due to the beautiful patterns, colors, and price tag.
Black-White. Black and white is the perfect combination and they're always cool and classic at an identical moment. They also go nicely with any varieties of closets, in the very traditional for the exact modern day. White walls that are accompanied with vanity, sink, cabinets, and closet with black color will definitely a great thought.
diy closet have a plain wall need more closet space build your own closet my home decor would be the most chosen and popular closet counter-tops now. Corian will give you natural stone search, notably granite and quartz, using affordable price tag. The price tag on fundamental corian closet countertops is roughly $40 to $60 per squarefoot. To get corian closet counter-tops with higher quality, so you want to spend $50 to $70 per squarefoot. Generally, the values is all for example installation and materials.
As an storage selection, you also may use builtin storage thing as part of your small storage thing. Maximize your storage areas by ground to ceiling integrated closets.


Moles feed on small invertebrate animals living under ground e.g. earthworms & other soil inhabiting insects and their various life stages. Moles remove many damaging insects and grubs from lawns and gardens. However, their burrowing habits destroy lawns and parks beauty, destroy flower beds, tear up the roots of grasses and not welcome by most property owners.


text:
PM Imran Khan terms the addition of Pakistan to Amazon's verified seller list as 'great development'
Aleena Jawaid
The United States e-commerce giant, Amazon has decided to add Pakistan to its verified sellers' list, and our Prime Minister Imran Khan has described this occurrence as a 'great development', according to the PM, it would allow the country's young entrepreneurs to enter the global export market.
"A great development as Amazon has finally approved that our sellers can export their goods through its system," the Prime Minister tweeted on Thursday. "Amazon starting operations in Pak will open opportunities for our youth as it will enable a new breed of young men & women entrepreneurs to join the export market."
Read more: Amazon adds Pakistan to its verified seller list
Furthermore, Imran Khan said that the recent progress will assist in creating opportunities for the young generation in the country and it will also increase the exports for the country. The announcement of the addition was made by the PM's Advisor on Commerce and Investment, Abdul Razzak Dawood stating, "We have finally made it. We have been engaged with Amazon since last year and now it's happening," he had said on his official Twitter account. He further stated that it is a great opportunity for the youth, small and medium businesses, and female entrepreneurs.
Read more: Jeff Bezos will be stepping down as the chief executive of Amazon
In addition to it, the ministry of commerce and Pakistan Consulate General Los Angeles were pushing to deliver this good news to the entire nation before Eid-ul-Fitr. Moreover, Economic Counsellor, Pakistan's Permanent Mission to the WTO and Additional Secretary Ministry of Commerce, Aisha Moriani said that the endorsement would serve the Small and Medium Enterprises (SMEs), small scale investors, and individual freelancers.
Furthermore, she told that the brand-new era of e-commerce inflation for Pakistan was about, to begin with, a landmark decision. Aisha Moriani has been actively involved in the means of obtaining approval for Pakistan in the Amazon sellers list. However, she informed the people concerned with the e-commerce business to maintain the worldwide standard of their products, or else their accounts could be blocked permanently.
ImranKhan
Previous articleOverseas Pakistanis will now be able to cast their vote electronically
Next articleEthereum's 27-year-old founder, Vitalik Buterin became the world's youngest crypto billionaire
Aleena Jawaid is a Writer at Technologistan.pk. She is a tech enthusiast and focused on reporting all the tech advancements in Pakistan. In her spare time, she'll be found either with a book or enjoying music.


Sometimes I want a red traffic light to take its time when there's an amazing light show at twilight. I took this photo at intersection of the The Alameda and Highway 156 in San Juan Bautista, which I enhanced with the art filters in Photoshop. The Husband and I were on our way home to Hollister, after stopping for a glass of Brewery Twenty-Five's Many Moons Stout at Vertigo Coffee. The cafe now offers craft beers on tap. Whooo-hooo!
The things that catch your eye when you're driving a windy road. For instance, up on Lone Tree Road the other day, I saw this huge rock on a hillside. It was quite handsome standing near the top in the late afternoon sunlight.
I wonder how the huge rock got there and if it used to sit among boulder mates. From what I could see, the big guy is surrounded by smaller rocks, which reminded me of a sheepdog tending its flock.


text:
Are there any plans / chances of supporting a RETURNING clause?
Chronological Unformatted History
(1) By anonymous on 2021-01-08 15:19:56 [link] [source]
I've recently been re-using sqlite for personal software, and got annoyed several times at the necessity to work around the lack of RETURNING clauses when inserting rows, especially bulk-insert (even more so with upserts), as well as deleting rows.
I understand that since sqlite remains a single-writer system the concurrency aspects of RETURNING are not really a concern regardless of the operation, but RETURNING is oft extremely convenient, and quite simplifies the application code. I think it would be a boon.
(2) By ddevienne on 2021-01-08 16:19:27 in reply to 1 [link] [source]
(3) By tom (younique) on 2021-01-08 17:57:20 in reply to 2 [link] [source]
(4) By anonymous on 2021-01-10 12:10:33 in reply to 1 [link] [source]
tl;dr; would love to see this feature, it would make sqlite, personally, go from 'meh, easier to just use json/xml files' to a critical tool in the toolbox.
So much this, every few years I come and check on SQLite to see if it has the returning clause yet, it never does =(.
I'd even be willing to toss money into the pot to support its development, but currently only see 1 way to fund development and that is the 85k/year business subscription....
Me too. I would pay for a more complete ALTER TABLE support, but cannot afford the business subscription. Imho, there should be a possibility for private customers to donate, too!
(13) By anonymous on 2021-01-27 08:06:15 in reply to 5 [link] [source]
take a look at this repo that I developed to workaround the missing full ALTER TABLE support: https://github.com/marcobambini/sqlite-createtable-parser
Marco Bambini
(6) By Richard Hipp (drh) on 2021-01-10 22:56:09 in reply to 1 [link] [source]
Two points of feedback:
Can y'all provide concrete examples of how you would find RETURNING useful. I can imagine cases where it would be useful, but in my own database programming (which this days is mostly confined to working on the Fossil source code) I don't recall ever coming across any such cases.
Anyone who is seriously interested in encouraging the implementation of new features through funding is welcomed to contact me directly at "drh at sqlite dot org".
I don't recall ever coming across any such cases.
Scanning the Fossil source code, I found two potential uses for RETURNING:
https://fossil-scm.org/home/artifact/73d98587f21769?ln=1395-1409
https://fossil-scm.org/home/artifact/6dff56283ae42aa27?ln=2330-2349
But neither of these are a big gain, either in performance or simplicity of code. Perhaps my coding style is atypical? Or perhaps there are other use cases that I'm just not seeing?
(8) By Warren Young (wyoung) on 2021-01-11 03:04:51 in reply to 7 [link] [source]
I suppose the value of RETURNING depends on a good answer to this question: Why would the calling code not already have the desired return values? Didn't it just send them to SQLite to update the DB?
To take the Fossil example, the pattern may be "create new artifact; return artifact ID". Didn't the C code creating that artifact create the new artifact's hash, thus doesn't need SQLite to give it back? It already has the data.
Most of my uses of DB update immediately followed by SELECT over the changed data are sufficiently well addressed by sqlite3_last_insert_rowid(), since it requires a subsequent trip up through the UI and back down into the app core before I'll know what that subsequent SELECT actually is. If I knew what data the user was going to request next, I'd just cache it as part of building the DB update query and return that, not ask SQLite to give me back something I just gave it.
That leads me to wonder if RETURNING is largely useful with complicated SQL queries that do calculation on supplied values, so the updated data aren't obvious from the executed query. This requires either use of custom functions or complicated expressions using standard SQLite functions.
Also, doesn't the SQLite caching layer remove a large part of the value of RETURNING? As far as I can tell, the main value of this SQL feature is predicated on the idea that a DBMS round-trip is expensive, but that's only true for client/server DBs. If you select from just-modified records, isn't SQLite -- being in-process -- going to return a result from RAM except in the rare instance that another concurrent query modified the same rows in between?
I repeat drh's challenge: what's the use case?
some reasons the calling code may not have access to the values:
database defaults.
non-integer primary key.
computed values.
batch inserts, where its easier to just insert then scan out the fields especially when combined with the 3 other issues above.
returning is really just a generalized form of last row id. I find it very useful from expressing the intent. yes I could write two queries but I also could just write one that does what I want, and generally the tooling already supports scanning results back out of the query.
I see it as a QOL improvements while developing beyond performance the performance benefits it provides in typical client/server environments. Once you have it, you start reaching for it in a bunch of contexts.
(12) By ddevienne on 2021-01-27 07:42:52 in reply to 11 [link] [source]
Completely agree. I've had these same thoughts for a while now,
but didn't bother writing them down. I'd also add to your list
compatibility with other DBs, including of course SQLite's usual
go-to for compatibility, PostgreSQL. This would make porting to
SQLite easier. I know of at least one large commercial product
swapping a client-server RDBMS backend in the enterprisey solution
with SQLite for the personal edition of that same product, and
it's also something I had in mind. Not having to work-around these
types of differences would be a plus for SQLite.
(9.1) By Ryan Smith (cuz) on 2021-01-11 10:27:32 edited from 9.0 in reply to 6 [link] [source]
I'm not sure there is much utility in the low-level code, using prepare-step-reset-etc.
The real utility for this comes in the high-level application code where you have abstracted calls to handle the above for you, much in the way that "sqlite3_execute()" does, or when working through a wrapper.
Here are a couple of typical examples with explicit utility:
exec("CREATE TABLE t(a INTEGER PRIMARY KEY, b TEXT);");
exec("INSERT INTO t(b) VALUES
('Johnny')
,('Joan')
,('Jane')
,('Jimmy')
;");
Now there is no way for me this high-level to know what the PK is for those inserted values unless I do those all one-by-one and get the LAST_INSERT_ROWID every time. A simple change like this:
query("INSERT INTO t(b) VALUES
RETURNING a,b
;")
would do the inserts and instantly give me a result like this:
1,Johnny
2,Joan
3,Jane
4,Jimmy
which can be parsed in my high-level side to know exactly what was inserted with which ID.
In that example the "inserted" seems obvious, those are the ones I asked for, but in the next example it is less obvious:
query("UPDATE t SET b = 'Mr. ' || b
WHERE b LIKE '%y'
will return:
a, b
1, Mr. Johnny
4, Mr. Jimmy
which again in the high-level parser will be extremely helpful in gaining easy access to feedback to a user (or programmer) what was updated - maybe even to construct a next query based on what was changed, if any.
I propose that the reason you do not find lots of application in current works for this RETURNING model, is merely because it did not exist yet and any possible use of it was handled another way - and perhaps you mainly use the low-level API and never have to work through a wrapper. Add it and application will arise (especially in higher-level code).
Last example:
query("DELETE from t WHERE a > 3 RETURNING b");
This obviates the need for a pre-query to see what will be affected, then a delete query to affect it, then a post-select query to see if all was indeed deleted as expected, and obviates the need for doing a transaction for all of this. One statement (a transaction unto itself) that executes the idea, and returns the result.
On the high-level side of the programming spectrum, perhaps working through a wrapper (which I know is not something you folks ever do), this kind of construct is an invaluable time-saver and code-quantity-saver. And less code means less opportunity for error and less debugging (as Richard always points out when advocating doing stuff in SQL rather than in code).
(10) By tom (younique) on 2021-01-11 11:14:44 in reply to 6 [link] [source]
My usecase for DELETE RETURNING would be to have a list of all deleted id's so that I can easiliy remove them from a virtual treeview component. Currently, I have to do a SELECT first to get the id's, then delete them afterwards. So it's 2 steps instead of just 1.
(14) By Keith Medcalf (kmedcalf) on 2021-01-27 13:22:33 in reply to 10 [link] [source]
Yeah, the RETURNING clause seems to be primarily associated with those who want to intermix "update" of the data with "display" of the data rather than maintain independence between the "update process" and the "display process".
It has been my experience that down this path is peril and monsters and much failed projects.
Storing and Updating the datastore is a quite independent process from displaying the contents of the datastore. Intermingling them for no good reason is unwise (and being "easier" is no good reason).
It has little to do with displaying the data Keith, and is all about
keeping the in-memory representation of the data in-sync with the
persistent store (SQLite) of that same data, when part of the data
is generated by the datastore (SQLite). That includes the good old
rowid, but now more content can be SQLite-side generated, given
UPSERT, Generated columns, triggers, etc...
last_insert_rowid() is basically global state, which is generally
a bad thing, and makes much more sense as a RETURNING clause. In fact
clients not interested in that rowid still have to pay for it being
stored, while with RETURNING only those explicitly asking for it would.
Of course BC mandates everyone will have to pay for it forever, still,
I don't see why anyone would agree this to be a good thing. Had RETURNING
been available then, we'd never have had last_insert_rowid() perhaps.
Which now that there are WITHOUT ROWID tables, feel all a misfeature.
Adding a RETURNING clause does nothing with respect to maintaining consistency between the persistent store and the in-memory view of the database. It is entirely possible and likely that changes to the persistent store will occur independently of the one bitty program that wants to use the RETURNING clause.
Reliance upon RETURNING for this purpose pre-supposes that the database is SINGLE-USER. Unless one is taking precautions to ensure that the datastore is in fact SINGLE-USER and cannot be modified by anyone else, then using RETURNING to maintain consistency is ill-conceived.
Rather than wasting time on ill-conceived endeavours, I would suggest that it would be far more productive to take a more holistic and realistic view which is not dependent on a state of fact that does not exist.
Now you're reaching into unrelated areas...
The DB does not need to be SINGLE-USER at all, the DB is locked by the
statement itself, or by a transaction. If changes can happen out of band,
then RETURNING or separate statements to fetch that same data after the fact
are no better or worse. Completely orthogonal.
You fail to understand. Just because you deleted something does not mean that it is the only change to the "tree view" control. Nor does it mean that the nanosecond after you deleted something, it was not added again by someone else.
The only way to obtain accurate results unless the database is single-user by the application and all other applications are precluded from making changes to the database is to re-read the database and make the "tree view" control consistent with the "authoritative source".
Otherwise, the "tree view" is merely a whimsy and not reflective of any actual state of affairs that actually existed at any point it time.
I'd say the same about you Keith :)
An in-memory view of the data has nothing to do with a UI or a tree view...
I'm talking about a C/C++ data objects here.
And single vs multi-user access to the DB (multi-connection in general)
is again completely unrelated and orthogonal to the benefits of a RETURNING clause.
You're a bit too quick to think everyone else but you understand issues IMHO, FWIW.
Sorry you feel that way, but the fact is that if you are assuming that nothing else is making concomitant changes to the datastore and design your code to rely on that fact, then you should be ensuring that this invariant condition is in fact true.
That is to say in the previous post that it would be perspicacious to address the manner of making the "in memory tree view" of the database consistent with the extant "persistent datastore" in an efficient manner rather than to make assumptions that there are no other influences on the "persistent datastore" (unless, of course, one has taken steps to ensure that there can be no other other mutators of that persistent datastore).
In other words, reliance on assumptions of fact being true, when they are actually false, will cause erroneous results.
I would point out that your argument goes directly against the "authoritative source" principle. The "authoritative source" of truth is the persistent datastore, not the copy of it that you happen to have in memory.
You must be prepared to deal with the fact that your copy may not be consistent with the "authoritative source" of truth and most efficient way to do that is to not have a copy which you have to continually ensure is consistent with the "authoritative source".
If you do choose to maintain a copy of the "authoritative source" for your use, you should be prepared to keep it consistent with the actual "authoritative source" and not with some proxy therefore.
(26) By doug (doug9forester) on 2021-01-30 05:27:30 in reply to 19 [link] [source]
Good point. If you want to always use the "auth source", how can SQLite help with that? Suppose you are displaying a list of xyz in your application, and someone adds (or deletes) members of xyz. What is the application supposed to do? It can't continually query the database in hopes of finding a change. Nor can it "listen" for a change and continually update the display of members, which would drive a user crazy.
So the single user design point works always when there actually is a single user. How can you actually design a user interface that faces continual (possible) updates in a multi-user environment? And can SQLite help with that?
(27) By Robert Ransom (rransom8774) on 2021-01-30 05:42:34 in reply to 26 [link] [source]
Nor can it "listen" for a change and continually update the display of members, which would drive a user crazy.
File management programs do this nowadays (when they can), and it doesn't drive their users crazy; people expect this capability now. In other applications, it may be better to gray out deleted items rather than removing them from the list.
In an SQLite-based system, this feature could be retrofitted in by using a trigger to call a user-defined 'doorbell' function, and having all instances of the table-viewer application listen for this event. Ideally this function would also be able to communicate the rowids of changed records to listeners.
(29) By Richard Damon (RichardDamon) on 2021-01-30 20:28:56 in reply to 27 [link] [source]
I believe that SQLite triggers only fire for the connection the executed the statement that did the deed, not other connections, which would require SQLite to create threads to make it happen.
For Windows, if I remember right, the file system can be asked to send a GUI event on a file change, so the GUI knows to update for the change (if needed). This would be beyond what would be expected of SQLite, but the program could set up a file system notification to the GUI on the database change.
No. The filesystem posts an event to an event semaphore.
This has nothing to do with the gooey application running on top of the Operating System.
The "Windows Gooey" is merely a WIMP interface running on top of the OS/2 New Technology (aka NT) Operating System (in previous incarnations it was a WIMP application running on top of DOS) much like X is a WIMP application that runs on top of Linux.
The operation of such events does not require a WIMP gooey and there is nothing which prevents the WIMP application (nor any application) from utilizing system services.
Technically, X is not a GUI. X is a presentation system on which various other stuff runs that provides the "window manager" and "shell services"; much like the display layer in "Windows" is called the GDI layer, and on top of that runs a bunch of other stuff that provides the "window manager" and the "shell services".
Microsoft has gone even further and wrapped the GDI layer and "window manager" and "shell services" with yet more gigabytes of layers of cruft which go by a variety of names which change on a daily basis though the underlying Operating System and GDI have remained relatively unchanged for several decades.
I appear to have misremembered, or that was the effect of some wrapper that was being used, as typically you are using the notification to cause the GUI update to reflect the file system change, so making it a message can be a common usage (and removes the multitude of issue that can pop up if you try to alter stuff in multiple threads).
That still makes it not really suitable to embed into SQLite itself as a way to notify an application of a data change.
You must not have ever worked with a non-bitty multiuser database application. The "view" presented to the user on the Cathode Ray Tube (or the Teletype machine) is not the "ongoing" state of affairs, it is "the truth" as it existed at the exact instant that it was claimed to have existed.
The fact that the bag-of-water reading the Teletype printout takes twenty minutes to read the output has zero relevance on the fact that, at the instance the teletype printed the data, in represented the exact truth at that instant. Not some programs "impression" or "wishful thinking" of what the state of truth was at that instance -- but the actual hard-boiled truth.
If the bag-of-water wants a subsequent printout of the truth as it exists at some later time, then the bag-of-water can request that another printout of the truth be obtained which reflects the truth at the time of the request.
If the bag-of-water wishes to change the "state of truth" from state A to state B by modifying C, then the very first step is to ensure that state A is still the truth before applying C to arrive at state B.
This is concurrency management 101. Actually, I think it is concurrency management pre-school (that is, it is a foundational concept) and as such no education is possible without a grounding in the foundational concepts.
This is the reason so many people find concurrent programming hard and why many attempts at concurrent programming fail (and this includes things like multithreading). Great effort is spent addressing symptoms rather than the root cause.
(23.1) Originally by Holger J (holgerj) with edits by Richard Hipp (drh) on 2021-01-28 12:38:22 from 23.0 in reply to 1 [link] [source]
If there is anybody who doubts that this is a useful feature, these are good readings:
https://www.postgresql.org/docs/current/dml-returning.html
https://dzone.com/articles/the-returning-keyword-in-postgresql
It saves a lot of round trips to the database after INSERTs and UPDATEs and allows deleting rows from one table while immediately inserting them into another. Advantages:
Data are not transferred between client and server (in case of SQLite between the lib and the application).
No explicit transaction is necessary as the whole statement is an autocommit transacation.
(24) By Richard Damon (RichardDamon) on 2021-01-28 13:00:50 in reply to 23.1 [source]
Note that there is a BIG difference in the cost of a 'Round Trip' to the database in something like a classical server-based database and SQLite, which is a critical difference. With a server-based database, there are significant communication delays in the 'round trip', reaching out to it and getting a response. With SQLite, there is basically no trip to speak of, as SQLite sits in your process space.
The whole concept of having lots of code to keep a cached version of the database can become a pessimism when you take into account that it will eat up process memory that could otherwise have been used to up the memory cache for SQLite and the OS, rather than building a duplicate cache for the data that is likely sitting in those already.
In the real world, applications which use use pulldown lists (sometimes nested), querying a database to gather the list (and marshal the values into a form required by the menu interface) is just too costly to performance. As soon as SQLite provides an interface that matches a SELECT query to an arbitrary in-memory structure, I'll be glad to give it a whirl. However, I think you'd agree that it's the application's responsibility to provide the data in a form that matches the interface, not the database's responsibility.
Have you actually checked the timing of this sort of thing with SQLite (as opposed to a full-service Client-Server Database). Remember that SQLite is running in-process accessing the same sort of memory as your cache system that you are writing to try to handle this. Yes, SQLite is likely a bit slow to get the data than from cache store optimized for a particular data model, but you also charge against the cache the operations it is doing to keep it up to date and for every data 'miss' to that cache. Also, it is using up memory that could have been added to the SQLite or OS caches to help avoid needing to go to the actual disk for data (since it is likely caching the recently accessed data that those other caches are holding).
IF you are submitting a change that you can't just know what the results are going to be (so you need the RETURNING clause), it seems that actually doing the SELECT to get fresh data isn't going to be that costly.


This is the surname research page for SYMONDS. This section is designed to contain general information about SYMONDS genealogy research. Please consider adding some of your own research, either as an editor or with journals below.
CHARLES GRAVES, PIONEER OF THE MORNINGTON PENINSULA, VIC., AUST. IN EARLY 1851.
LAND IN FINGAL AND WANNAEUE OWNED BY THE CAIRNS FAMILY AND THEIR IN-LAWS, VIC, AUST.


There are 2 new home developments in Central East Austin, Austin (City), a mix of high-rise and low-rise that are planned, under construction or recently completed. Of these, 1 are apartment developments . The median list price for a condo in Central East Austin is $400,000. There are 1 single family home developments in Central East Austin . The most active developer in Central East Austin is Lincoln Property Company.
Find your new construction home in Central East Austin by browsing the map, or using the filters above. Filter results based on Central East Austin homes for sale or homes for rent; condo, townhome or house building type, number of bedrooms or price. More filters are available on the map. Save your search to receive updates on Central East Austin new home inventory that meets your criteria.